I am trying to call a stored procedure on SQL 2008 R2 version via a Websphere JDBC Adapter 220.127.116.11 in my WID 18.104.22.168.
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 22.214.171.124 in the runtime.
Please let me know, thanks
Pinned topic Websphere JDBC adapter 126.96.36.199 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 Posts
Re: Websphere JDBC adapter 188.8.131.52 and SQL 2008 R22011-12-22T08:43:07ZThis is the accepted answer. This is the accepted answer.Hi,
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.