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

We have been moving sites from a SQL 2000 machine over to a new SQL server 2005 server and we came across this error: “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 […]

We have been moving sites from a SQL 2000 machine over to a new SQL server 2005 server and we came across this error:
“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 isn’t 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:

Duncan Isaksen-Loxton

Educated as a web developer, with over 20 years of internet based work and experience, Duncan is a Google Workspace Certified Collaboration Engineer and a WordPress expert.
Login
Log in below to access your courses.
Log In With Google
Forgot Password
Enter your email address or username and we’ll send you instructions to reset your password.