Cannot enable JDBC connection?


I have a wm7 server with a SQL Server 2k8. I can access my database using pure Java code and I can even access it with the old WmDB with the following config:

URL: jdbc:sqlserver://;instanceName=SQLEXPRESS;databaseName=test;
DB Driver:

Alright, now in my JDBC connection, I set “” as DataSource class, test for Database Name and “instanceName=SQLEXPRESS” in Other Properties. All of this seems fine to me but when I try to enable the connection I get:

Error encountered [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource database:TESTCONN.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.

Does someone know if I am doing something wrong?


have u tried by pasting sqljdbc.jar files in ur bin folder


Do you have the SQL Server Jars in the IntegrationServer\lib\jars?
You need to restart the server after putting the jars on this folder

Hope this Helps