Hi,
I am using the following
java file to get connected to an instance of MSSQL server on my desktop, but getting an exception, any ideas ?
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
/**
* Microsoft SQL Server
JDBC test program
*
*
http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml *
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q313100& */
public class Test {
static Test test;
public Test() throws Exception {
// Get connection
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
Connection connection = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://kdesktop_xp:1433", "sa", "123qweasd");
if (connection != null) {
System.out.println();
System.out.println("Successfully connected");
System.out.println();
// Meta data
DatabaseMetaData meta = connection.getMetaData();
System.out.println("Driver Information");
System.out.println("\tDriver Name: "+ meta.getDriverName());
System.out.println("\tDriver Version: "+ meta.getDriverVersion());
System.out.println("\nDatabase Information ");
System.out.println("\tDatabase Name: "+ meta.getDatabaseProductName());
System.out.println("\tDatabase Version: "+ meta.getDatabaseProductVersion());
// Select some data
/*
Statement select = connection.createStatement();
ResultSet result = select.executeQuery("SELECT msisdn FROM member");
while (result.next()) {
System.out.println(result.getString(1));
}
*/
}
} // Test
public static void main (
String args[]) throws Exception {
test = new Test();
}
}
Exception:
Exception in
thread "main" 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:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Test.<init>(Test.java:21)
at Test.main(Test.java:59)
i am using eclipse 3.1, and have included :
msbase.jar
mssqlserver.jar
msutil.jar
in the project.
Thanks in advance.
-Kamal.
