MS SQL Server Datasource in Weblogic

[Ganesh Kumar C V]

Hi - I have to create a datasource in Weblogic for MS SQL Server database. But I am NOT sure on which driver to choose in the drop down list. Are there any criteria in selecting a particular driver. But I tried each driver one by one and each one is throwing different errors during test connection. Errors are like driver class not found or some dll is missing. Do I require any jar? Please help.

Thanks
Ganesh

[Mohamed Nahfees]

This is the standard drivers provided by Weblogic. If you using transaction, use (1) otherwise use (2)

(1) XA: weblogic.jdbcx.sqlserver.SQLServerDataSource
(2) Non-XA: weblogic.jdbc.sqlserver.SQLServerDriver

Click for more information
JDCB SQL Driver information