I downloaded JDBC drivers 1.2 and 2.0 version for SQL 2005 from Microsoft. I copied jar files for both version each time in WMDir\IntegrationServer\lib\jars. When I try to enable connection JDBC Adapter, I get following error. I also have set the classpath for these jar files,
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Test7_1.adapter:Test7_1.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
The reason I am trying to use different JDBC drivers instead of WM Built in drivers because I want to handle explicit transaction commit and rollback and since one week I am not able to acheive it. When I use Built in drivers, Rollback does not work and I get following message by using get last error,
[ART.114.306] Adapter Runtime (Transaction): Unable to rollback transaction.