SQL Server JDBC - "Data type unknow" when using SQL 2000 jdbc driver to access SQL 2

Author

"Data type unknow" when using SQL 2000 jdbc driver to access SQL 2

eric dong

2005-12-05, 9:23 am

When I use JDBC driver for SQL Server 2000 (sp3) to access SQL Server 2005
in server cursor mode (selectMethod=Cursor
), there will be an error (as
below) returning for any select statement.

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

Error does not occur if I set the property "selectMethod=direct". Does SQL
2000 JDBC driver cannot work with SQL 2005 in server cursor mode?

Thanks.

Sue Purkis

2005-12-06, 9:23 am

Eric,
The JDBC driver for SQL Server 2000 is not certified to work against SQL
Server 2005.

Microsoft is running a beta of their new 2005 driver. You can download it
from http://www.microsoft.com/sql/downloads/jdbc.mspx

DataDirect (among others) has a released driver for SQL Server 2005. You
can download it from:
http://www.datadirect.com/downloads..._jdbc/index.ssp

Sue Purkis
DataDirect Technologies

"eric dong" <eric dong@discussions.microsoft.com> wrote in message
news:73BF7A1A-37AE-4C46-9F63- D6C47831FFF4@microso
ft.com...
>
> When I use JDBC driver for SQL Server 2000 (sp3) to access SQL Server 2005
> in server cursor mode (selectMethod=Cursor
), there will be an error (as
> below) returning for any select statement.
>
> "[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."
>
> Error does not occur if I set the property "selectMethod=direct". Does SQL
> 2000 JDBC driver cannot work with SQL 2005 in server cursor mode?
>
> Thanks.

Sponsored Links