Monday, February 20, 2012

JDBC error on estabilishing the socket on HPUX machine

I am trying to install the JDBC driver for SQL server 2000 on MY HPUX machine. After installing I am trying to run the test program. I found the following error message. Did any one help me how to resolve this problem?
java -classpath " :./lib/mssqlserver.jar ./lib/msbase.jar ./lib/msutil.jar" Test
Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<in it>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnecti on.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplC onnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknow n Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at Test.<init>(Test.java:18)
at Test.main(Test.java:55)
Regards
Senthil
Senthil wrote:

> I am trying to install the JDBC driver for SQL server 2000 on MY HPUX machine. After installing I am trying to run the test program. I found the following error message. Did any one help me how to resolve this problem?
> java -classpath " :./lib/mssqlserver.jar ./lib/msbase.jar ./lib/msutil.jar" Test
> Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
>
Hi. The driver is installed fine. This usually means the DBMS you're connecting to
is either not listening for tcp connection requests, or listening on a different port
number than the one you gave in the URL.
Joe Weinstein at BEA
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source)
> at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
> at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
> at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<in it>(Unknown Source)
> at com.microsoft.jdbc.sqlserver.SQLServerImplConnecti on.open(Unknown Source)
> at com.microsoft.jdbc.base.BaseConnection.getNewImplC onnection(Unknown Source)
> at com.microsoft.jdbc.base.BaseConnection.open(Unknow n Source)
> at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager .java:512)
> at java.sql.DriverManager.getConnection(DriverManager .java:171)
> at Test.<init>(Test.java:18)
> at Test.main(Test.java:55)
>
> Regards
> Senthil

No comments:

Post a Comment