I was trying to configure JDBC Adapter 6.0.3 to MS SQL Server 2000.
I am using msbase.jar,msutil.jar and mssqlserver.jar in the classpath.
I am getting this errror though all the wM configurations are accurate according to the wM JDBC Docs.
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource jdbcAdapConn:CLDCon.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.jdbcx.sqlserver.SQLServerDataSource”.
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
My configuration:
Connection Properties
Transaction Type LOCAL_TRANSACTION
DataSource Class com.microsoft.jdbcx.sqlserver.SQLServerDataSource
serverName Vmdevcssql01
user SA-WMD
password ******
databaseName CLD
portNumber 1434
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Environment:
wM IS 6.0.1
I am not able to find out what the problem is. I went through whole of wMusers forum and its archives, but still could not figure out a proper solution. That is the reason I have started a new thread.
Srinivas,
Microsoft SQL Server 2000 (for JDBC 2.20019) does not require a value for the databaseName property in the JDBC adapter configuration settings.
Try the below configurations:
Connection Properties
Transaction Type LOCAL_TRANSACTION
DataSource Class com.microsoft.jdbcx.sqlserver.SQLServerDataSource
serverName Vmdevcssql01
user SA-WMD
password ******
databaseName
portNumber 1434
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
If the port 1434 doesn’t work try the default port 1433.
Srivats,
what did you do with the driver install exe you downloaded from microsoft??
If you have already tried port number 1433 and IP address (instead of server name), I suggest that you post the server classpath on your IS installation??
R U using JDBC pools on the IS?
This error is different than other ones as it is “Error establishing socket” error. In all probability, it is able to find the driver class from the jars.
I am having the same issues as you are and you can see the thread running there as well, the link is
[url=“wmusers.com”]wmusers.com
Secondly, I was able to overcome the third error, namely, the ADA error by using Microsoft provided SQL Server 2000 JDBC Drivers SP1 instead of Microsoft provided SQL Server 2000 JDBC Drivers SP3.
Also, make sure SQL is in the mixed mode authentication.
SQL driver jars files should be available in the Adapter package as well.“IS\packages\your adapter package\code\jars\”
If you are able to overcome the other 2 errors, please let me know as well, as I am stuck at this stage myself, looking for any good solutions.
Hi,
I had exactly the same problem as Srivats, I downloaded the sql server 2000 driver for JDBC from microsoft & restarted IS6.1 and it started working.
hi all.
i am trying to work on JDBC adapter 6.0.3. when i am trying to configure the jdbc adapter it is given the following errors…
I am using SQL server 2000…
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource sampadap:asdlasn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class “com.microsoft.jdbcx.sqlserver.SQLServerDataSource” cannot be located.
com.microsoft.jdbcx.sqlserver.SQLServerDataSource.class not found