I am trying to call a stored procedure on SQL 2008 R2 version via a Websphere JDBC Adapter 184.108.40.206 in my WID 220.127.116.11.
The list for SQL server server is 2000 and 2005, 2008 R2 is not listed. I guess I can use "other" option with sqljdbc4.jar driver from Microsoft. But I am not sure if it is supported by Websphere JDBC adapter 18.104.22.168 in the runtime.
Please let me know, thanks
This topic has been locked.
1 reply Latest Post - 2011-12-22T08:43:07Z by SystemAdmin
Pinned topic Websphere JDBC adapter 22.214.171.124 and SQL 2008 R2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-12-22T08:43:07Z at 2011-12-22T08:43:07Z by SystemAdmin
SystemAdmin 110000D4XK67 PostsACCEPTED ANSWER
Re: Websphere JDBC adapter 126.96.36.199 and SQL 2008 R22011-12-22T08:43:07Z in response to JasonJavaHi,
All databases that have a JDBC driver that supports the JDBC specification 2.0 or later, such as DB2, SQL Server, and Oracle are supported by JDBC adapter. Consult the individual database vendor's documentation for details about the JDBC specification support.
If you get any problems while using the JDBC adapter with SQL server you can refer to the section of Solutions to common problems on below location for quick resolutions.