JDBC Adapter Connection to SQL Server 2000

Hi,

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.

Your help is greatly appreciated.

Thanks,
Srivats

Srinivas,

I believe you forgot to mention this param in the
Connection Properties section:

Other Properties:selectMethod=cursor

please fill the above setting and try enabling the connection.
Also make sure your DB is Up,and remaining settings looks fine.

If not try with default SQLServer port :1433

HTH,
RMG

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.

Sivaram

Hi,

Thank you RMG and Sivaram for your responses. I tried what you both have said, but still I am getting the same error.

I have one doubt…is this due to some JDBC-ODBC bridge problems.

I am able to connect to that server through SQL Server Utility but not able to connect through wM JDBC Adapter.

Do I need to install something on the MS SQL Server 2000 side to make it talk to JDBC Adapter ?

Right now I am using Microsoft provided SQL Server 2000 JDBC Drivers SP3. Do I need to use anything other than this?

Please help me.

Thanks,
Srivats

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.

  • Saurabh.

Srinivas,

Try with IP address instead of physical server name in the
serverNamegive IPAddress)

webMethods default bundles with DataDirect drivers for Oracle/SQL server,if possible try with this option.

HTH,

Hi Srivats,

I am having the same issues as you are and you can see the thread running there as well, the link is
http://www.wmusers.com/wmusers/messages/117/36741.shtml?1092534155

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.

regards,
Naeem.

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

Rishi,
Did you install the SQL Server JDBC drivers?