Topic
1 reply Latest Post - ‏2011-12-22T08:43:07Z by SystemAdmin
JasonJava
JasonJava
11 Posts
ACCEPTED ANSWER

Pinned topic Websphere JDBC adapter 7.0.0.3 and SQL 2008 R2

‏2011-12-21T05:53:51Z |
I am trying to call a stored procedure on SQL 2008 R2 version via a Websphere JDBC Adapter 7.0.0.3 in my WID 7.0.0.3.

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 7.0.0.3 in the runtime.

Please let me know, thanks
Updated on 2011-12-22T08:43:07Z at 2011-12-22T08:43:07Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    67 Posts
    ACCEPTED ANSWER

    Re: Websphere JDBC adapter 7.0.0.3 and SQL 2008 R2

    ‏2011-12-22T08:43:07Z  in response to JasonJava
    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.

    http://publib.boulder.ibm.com/infocenter/dmndhelp/v7r0mx/index.jsp?topic=%2Fcom.ibm.wbit.help.adapters.doc%2Ftopics%2Ftcreatecmps.html

    Thanks,
    Vinod Valecha