i'm using websphere application server 5.1 and sql server 2000.when i create the data source for database through jdbc providers from admin then after creating the datasource,when i click on test connection i get the following error:
Test connection failed for data source test1 on server server1 at node comp-webNode01 with the following exception: java.lang.Exception: java.sql.SQLException: IBMSQLServer JDBC DriverError establishing socket. Connection refused: connectDSRA0010E: SQL State = 08001, Error Code = 0. View JVM logs for further details.
pls. help me out from this problem.
Pinned topic problem to set jdbc driver for sql server
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-05-09T21:10:21Z at 2010-05-09T21:10:21Z by teebabs
teebabs 2700035YJS1 Post
Re: problem to set jdbc driver for sql server2010-05-09T21:10:21ZThis is the accepted answer. This is the accepted answer.i'm using websphere application server 7.0/sql server 2008 and also encountering the same problem. My sql server is running on port 1434 and i already set the driver location for the sqlserver.jar.
driver name : DataDirect ConnectJDBC type 4 driver for MS SQL Server
implementation Class Name = com.ddtek.jdbcx.sqlserver.SQLServerDataSource
When i click on test connection i get the following error:
The test connection operation failed for data source testDS on server server1 at node cheetahNode01 with the following exception: java.sql.SQLNonTransientException: DataDirectSQLServer JDBC DriverError establishing socket to host and port: cheetah:1434. Reason: Connection refused: connectDSRA0010E: SQL State = 08001, Error Code = 0. View JVM logs for further details.
what is being done wrong ?