Hello,
I just wanted to share this fix with rest of you folks. I spent almost a day trying to fix the problem.
Those who are trying to retrieve data from SQL Server 2005 using Microsoft's
JDBC driver might get the following error message.
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown.
All you need to do is change the connection
string.
Current : jdbc:microsoft:sqlserver://<ServerName>:<PortNumber>;databaseName=<DatabaseName>;SelectMethod=Cursor
New: jdbc:microsoft:sqlserver://<ServerName>:<PortNumber>;databaseName=<DatabaseName>;SelectMethod=Direct
By changing select method from Cursor to Direct you would be able to retrieve data.
HTH
[ March 02, 2007: Message edited by: Ram Bu ]