Cannot enable JDBC connection?

, ,
1

Hello,

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://127.0.0.1;instanceName=SQLEXPRESS;databaseName=test;
DB Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Alright, now in my JDBC connection, I set “com.microsoft.sqlserver.jdbc.SQLServerDriver” 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.

com.microsoft.sqlserver.jdbc.SQLServerDriver
"

Does someone know if I am doing something wrong?

Thanks!

2

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

3

Hi,

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
Mourão