开发者

WSAD to SQL Server Connectivity Issue

开发者 https://www.devze.com 2022-12-16 03:36 出处:网络
I am facing issues connecting to SQL Server 2008 from WSAD5.1.2( WAS version 1.5.1.1 ). I am using Microsoft SQL Server 2005 J开发者_如何学CDBC Driver Version 1.2 on JRE 1.4.2 for the same as Driver V

I am facing issues connecting to SQL Server 2008 from WSAD 5.1.2 ( WAS version 1.5.1.1 ). I am using Microsoft SQL Server 2005 J开发者_如何学CDBC Driver Version 1.2 on JRE 1.4.2 for the same as Driver Version 2.0 for SQL Server 2008 is not compatible on JRE 1.4.2. The database connection is being established but while retrieving the data I get an exception

java.sql.SQLException: [IBM][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.”

Any help to resolve this issue is highly appreciated also any suggestions/alternate ways on connecting to SQL Server 2008 from WAS 1.5.1.1 is also welcome.


Issue was resolved using JDBC 1.2 drivers which run on jdk 1.4

0

精彩评论

暂无评论...
验证码 换一张
取 消