SQL incoming tabular data stream (TDS) remote procedure call error

Posted At : 31 October 2007 15:12 | Posted By : Duncan Loxton
Related Categories: SQL,ColdFusion

We have been moving sites from a SQL 2000 machine over to a new SQL server 2005 server and we came across this error:

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

It is caused by the connection method in the datasource settings. Using Cursor isnt friendly with SQL 2005, but Direct makes it purrrrr like a kitten.

Now if you create your data sources manually in ColdFusion admin, then you will never see this because the nice admin holds your hand and sets the default to "Direct".

However by using the ColdFusion Administrator API to create your data sources will mean you are stuck scratching your head and heading to Google. So to stop this happening set your "selectmethod" attributes to Direct:

stDSN.driver = "MSSQLServer";
   stDSN.name= D" BDSN";
   stDSN.host = "192.168.101.109";
   stDSN.port = "1433";
   stDSN.selectmethod = "direct";
   stDSN.database = "DBDSN";
   stDSN.username = "DBUsername";
   stDSN.password = "DBPassword";
   // now create    dsObj.setMSSQL(argumentCollection=stDSN);