ColdFusion MX 6.1 and 7.x and MS SQL 2005

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."

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.