ColdFusion MX 6.1 and 7.x and MS SQL 2005
Posted by Joe Rebis (Import) on 26 June 2007 09:17 AM

If you are having trouble getting your ColdFusion MX 6.1 and 7.x DSN's working with MS SQL 2005 you probably need to update your DataDirect JDBC drivers to version 3.5. Review the Adobe TechNote article first.

You may have seen the following error in your ColdFusion Application logs from the CF Administrator:

"Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""""): Data type 0x38 is unknown."

San Diego web hosting coldfusion log files

ColdFusion administrator log file location can vary depending on current version.

Solution:

Adobe TechNote: http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a&sliceId=1

  1. Download the macromedia_drivers.zip from the TechNote above.
  2. Stop all ColdFusion Services.
  3. Backup "drive:\\CFusionMX7\lib\macromedia_drivers.jar"
  4. Extract the drivers into "drive:\\CFusionMX7\lib\" overwriting the existing files.
  5. Restart all Cold Fusion services.

* "CFusionMX7" should be replaced with your cf_root installation folder.

That should do it for you.

(1266 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Copyright © 2015 EPhost, Inc. All rights reserved.