Problem connecting with SQLServer 2000 Driver for JDBC

[jpotucek]

One of the programmers has a JAVA APP and is trying to connect to a Database on one of my SQL Server Instances. SQL Server 2000 Standard SP4

Getting this error: CAN ANYONE HELP?

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at DBConnection.<init>(DBConnection.java:45)
at IDMLabUpd.run(IDMLabUpd.java:32)
at IDMLabUpd.main(IDMLabUpd.java:18)

 

[jpotucek]

Also, this is the connection string:

SQLconn.user=Tower
SQLconn.pass=TowerPilotODBC
SQLconn.drivername=com.microsoft.jdbc.sqlserver.SQ LServerDriver
SQLconn.dbURL=jdbc:microsoft:sqlserver://KOCTOWERDEV02:1412

I checked my Server Properties and TCP\IP is enabled and listening on port 1412.