[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
I am using Microsoft SQL Server 2000 Driver to connect to SQL Sever 2000 from a remote machine having Linux OS. But this is giving below error:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
The Driver I am using is :"com.microsoft.jdbc.sqlserver.SQLServerDriver";
Connection string :"jdbc:microsoft:sqlserver://203.199.95.194:1433;databasename=Spears2;SelectMethod=Cursor";
I read somewhere the Type-4 driver does not support SSL and encrypted connections , may be because of that its giving this error...I am not sure of this ...Is that true ? any idea ?
When i am using simple JDBC-ODBC bridge Driver
Driver : "sun.jdbc.odbc.JdbcOdbcDriver";
Connection string :"jdbc:odbc:driver={SQL Server};Server=203.199.95.194;UID=sa;DATABase=Spears2";its giving me this error:
java.lang.NullPointerException
sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
Can anyone help me out of this ?
or Is there any other driver(free) for Linux that can be used to connect to remote SQL server that support SSL and encrypted connections ? I want DSNless connection.
Can anyone help me ? Thanks.
