Problem with mssql jdbc

From: sp (spiazi67_at_netscape.net)
Date: 11/01/04 

Date: Mon, 01 Nov 2004 22:31:26 GMT

I can't connect with jdbc for mssql.

This is the code:

 try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
  try {
  conn =
    DriverManager.getConnection(
     "jdbc:microsoft:sqlserver://localhost:1433","username","pwd");
      dmd = conn.getMetaData();
  } catch (SQLException e1) {
    e1.printStackTrace();
  }

This is the error :
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:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at sgs.mssql.Prova.<init>(Prova.java:50)

at sgs.mssql.VisualizzaSQL.<init>(VisualizzaSQL.java:52)

at sgs.mssql.VisualizzaSQL.createAndShowGUI(VisualizzaSQL.java:114)

at sgs.mssql.VisualizzaSQL.access$0(VisualizzaSQL.java:102)

at sgs.mssql.VisualizzaSQL$2.run(VisualizzaSQL.java:135)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)

at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)

at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:151)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

Relevant Pages