f



MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)

I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and
the MS SQL 2000 Server JDBC driver.

I have installed and configured the MS SQL Server 2000 onto two computers,
which reside on the same network.  (In fact, these two computers comprise
the entire network).

The network server (computer name=SUNCDS1), and the lone node (SUNCDS2),
each have their own SQL Server 2000 instance.

The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL
Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2.
It may be worthwhile to mention that the SUNCDS2 instance on the Enterprise
console does not show the SQL Server Agent as being started, but I can
navigate to the SUNCDS2 databases, and display the table information.  If I
try to start the SQL Server Agent for SUNCDS2, I receive the message "Access
is Denied".  The enterprise console on the SUNCDS2 machine indeed shows the
SQL Server Agent as being started.

I have written a sample Java application that uses both the MS SQL Server
ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to establish
a connection to the SUNCDS2 instance.  This application resides on the
SUNCDS1 network server.  The ODBC driver will connect to SUNCDS2 instance
wihout a problem.

The JDBC driver does not connect to SUNCDS2.  The JDBC driver will, however,
connect to the local SQL Server instance that resides on SUNCDS1.

Following are the code snippet to establish the JDBC driver connection, and
also the DriverManager logging messages that show the failure.  (I have also
included the messages regarding the successful ODBC connection to SUNCDS2 at
the end of this post, for what it's worth).

static void testJDBCConnection()
 {
    System.out.println("testing JDBC connection type 4");
 Driver d = null;
 DriverManager.println("===================== testing JDBC connection type 4
=====================");

 try {
  d =
(Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  } catch (InstantiationException e) {e.printStackTrace();}
    catch (IllegalAccessException e) {e.printStackTrace();}
    catch (ClassNotFoundException e) {
         e.printStackTrace();}
    try
    {
        String url =
"jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master";
        System.out.println(url);
        System.out.println(d);
        Connection conn = DriverManager.getConnection(url, "sa", "scd123");
        DatabaseMetaData dma = conn.getMetaData ();
  System.out.println("\nConnected to " + dma.getURL());
  System.out.println("Driver       " +    dma.getDriverName());
  System.out.println("Version      " +   dma.getDriverVersion());
  System.out.println("");
  conn.close();

    }
    catch (SQLException e) {e.printStackTrace();}
 }


===================== testing JDBC connection type 4 =====================
 registerDriver:
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver@7a1576]
 DriverManager.getConnection("jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master")    tryingdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] *Driver.connect(jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master)    tryingdriver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver@7a1576] Connection.finalize sun.jdbc.odbc.JdbcOdbcConnection@79e304 *Connection.close 0 Statement(s) to close ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@273686 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver forJDBC]Connectiontimed out: connect at com.microsoft.jdbc.base.BaseExceptions.createException(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(UnknownSource) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(UnknownSource) 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 SQLConnection.testJDBCConnection(SQLConnection.java:228) at SQLConnection.getDBConnection(SQLConnection.java:117) at SQLConnection.test(SQLConnection.java:22) at SQLConnection$1.actionPerformed(SQLConnection.java:66) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) atjavax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) atjava.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) SQLException: SQLState(HY000) java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Errorestablishing 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(UnknownSource) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(UnknownSource) 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 SQLConnection.testJDBCConnection(SQLConnection.java:228) at SQLConnection.getDBConnection(SQLConnection.java:117) at SQLConnection.test(SQLConnection.java:22) at SQLConnection$1.actionPerformed(SQLConnection.java:66) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) atjavax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) atjava.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) SQLException: SQLState(08001) getConnection failed: java.sql.SQLException: [Microsoft][SQLServer 2000Driver for JDBC]Error establishing socket. :===================== testing ODBC connection ===================== DriverManager.getConnection("jdbc:odbc:Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; PWD=scd123")    tryingdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] *Driver.connect (jdbc:odbc:Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; PWD=scd123) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet Allocating Environment handle (SQLAllocEnv) hEnv=51647136 Allocating Connection handle (SQLAllocConnect) hDbc=51647304 Connecting (SQLDriverConnect), hDbc=51647304, szConnStrIn=Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; PWD=scd123 RETCODE = 1 WARNING - Generating SQLWarning... SQLWarning: reason([Microsoft][ODBC SQL Server Driver][SQL Server]Changeddatabase context to 'master'.) SQLstate(01000) vendor code(5701) SQLWarning: reason([Microsoft][ODBC SQL Server Driver][SQL Server]Changedlanguage setting to us_english.) SQLstate(01000) vendor code(5703) *Connection.getMetaData *DatabaseMetaData.getDriverName Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL *DatabaseMetaData.getDriverVersion Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 *DatabaseMetaData.getDriverName Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL Driver name:    JDBC-ODBC Bridge (SQLSRV32.DLL) *DatabaseMetaData.getDriverVersion Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 Driver version: 2.0001 (03.85.1117) Caching SQL type information *Connection.getMetaData *DatabaseMetaData.getTypeInfo Allocating Statement Handle (SQLAllocStmt), hDbc=51647304 hStmt=51650696 Get type info (SQLGetTypeInfo), hStmt=51650696, fSqlType=0 Number of result columns (SQLNumResultCols), hStmt=51650696 value=20 Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=10,len=300 03.52.0000 Fetching (SQLFetch), hStmt=51650696 Column attributes (SQLColAttributes), hStmt=51650696, icol=1, type=2 value (int)=-9 Column attributes (SQLColAttributes), hStmt=51650696, icol=1, type=3 value (int)=256 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 sql_variant Get integer data (SQLGetData), hStmt=51650696, column=2 value=-150 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 uniqueidentifier Get integer data (SQLGetData), hStmt=51650696, column=2 value=-11 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 ntext Get integer data (SQLGetData), hStmt=51650696, column=2 value=-10 Get integer data (SQLGetData), hStmt=51650696, column=3 value=1073741823 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 nvarchar Get integer data (SQLGetData), hStmt=51650696, column=2 value=-9 Get integer data (SQLGetData), hStmt=51650696, column=3 value=4000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 sysname Get integer data (SQLGetData), hStmt=51650696, column=2 value=-9 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 nchar Get integer data (SQLGetData), hStmt=51650696, column=2 ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@30d82d Connection.finalize sun.jdbc.odbc.JdbcOdbcConnection@c09554 *Connection.close 0 Statement(s) to close ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@18bf072 value=-8 Get integer data (SQLGetData), hStmt=51650696, column=3 value=4000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 bit Get integer data (SQLGetData), hStmt=51650696, column=2 value=-7 Get integer data (SQLGetData), hStmt=51650696, column=3 value=1 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 tinyint Get integer data (SQLGetData), hStmt=51650696, column=2 value=-6 Get integer data (SQLGetData), hStmt=51650696, column=3 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 tinyint identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=-6 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 bigint Get integer data (SQLGetData), hStmt=51650696, column=2 value=-5 Get integer data (SQLGetData), hStmt=51650696, column=3 value=19 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 bigint identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=-5 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 image Get integer data (SQLGetData), hStmt=51650696, column=2 value=-4 Get integer data (SQLGetData), hStmt=51650696, column=3 value=2147483647 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 varbinary Get integer data (SQLGetData), hStmt=51650696, column=2 value=-3 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 binary Get integer data (SQLGetData), hStmt=51650696, column=2 value=-2 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 timestamp Get integer data (SQLGetData), hStmt=51650696, column=2 value=-2 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 text Get integer data (SQLGetData), hStmt=51650696, column=2 value=-1 Get integer data (SQLGetData), hStmt=51650696, column=3 value=2147483647 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 char Get integer data (SQLGetData), hStmt=51650696, column=2 value=1 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 numeric Get integer data (SQLGetData), hStmt=51650696, column=2 value=2 Get integer data (SQLGetData), hStmt=51650696, column=3 value=38 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 numeric() identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=2 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 decimal Get integer data (SQLGetData), hStmt=51650696, column=2 value=3 Get integer data (SQLGetData), hStmt=51650696, column=3 value=38 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 money Get integer data (SQLGetData), hStmt=51650696, column=2 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smallmoney Get integer data (SQLGetData), hStmt=51650696, column=2 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 decimal() identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 int Get integer data (SQLGetData), hStmt=51650696, column=2 value=4 Get integer data (SQLGetData), hStmt=51650696, column=3 value=10 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 int identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=4 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smallint Get integer data (SQLGetData), hStmt=51650696, column=2 value=5 Get integer data (SQLGetData), hStmt=51650696, column=3 value=5 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smallint identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=5 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 float Get integer data (SQLGetData), hStmt=51650696, column=2 value=6 Get integer data (SQLGetData), hStmt=51650696, column=3 value=15 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 real Get integer data (SQLGetData), hStmt=51650696, column=2 value=7 Get integer data (SQLGetData), hStmt=51650696, column=3 value=7 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 datetime Get integer data (SQLGetData), hStmt=51650696, column=2 value=11 Get integer data (SQLGetData), hStmt=51650696, column=3 value=23 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smalldatetime Get integer data (SQLGetData), hStmt=51650696, column=2 value=11 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 varchar Get integer data (SQLGetData), hStmt=51650696, column=2 value=12 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 End of result set (SQL_NO_DATA) *ResultSet.close Free statement (SQLFreeStmt), hStmt=51650696, fOption=1 *ResultSet has been closed Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=44 int value=23 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=168 int value=8065 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=151 int value=73695 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=145 int value=69599 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=121 int value=15 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=120 int value=2 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=153 int value=1 getConnection returningdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] *Connection.getMetaData *DatabaseMetaData.getURL *DatabaseMetaData.getDriverName Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL *DatabaseMetaData.getDriverVersion Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 *Connection.close 0 Statement(s) to close Disconnecting (SQLDisconnect), hDbc=51647304 Closing connection (SQLFreeConnect), hDbc=51647304 Closing environment (SQLFreeEnv), hEnv=51647136

0
Stuart
1/2/2005 6:08:50 PM
comp.lang.java.databases 3049 articles. 0 followers. samyaksulabh (16) is leader. Post Follow

4 Replies
1430 Views

Similar Articles

[PageSpeed] 22

Hi. In order for the jdbc driver to connect to the DBMS, the DBMS needs to be
configured to listen for TCP connection requests. It does not do this by default.
Ie: "Mixed mode" connections in setup. 1433 is the default port for a SQLServer
to use for tcp connections. You should verify that the DBMS is using that port...
Joe Weinstein at BEA

Stuart Leonard wrote:

> I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and
> the MS SQL 2000 Server JDBC driver.
> 
> I have installed and configured the MS SQL Server 2000 onto two computers,
> which reside on the same network.  (In fact, these two computers comprise
> the entire network).
> 
> The network server (computer name=SUNCDS1), and the lone node (SUNCDS2),
> each have their own SQL Server 2000 instance.
> 
> The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL
> Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2.
> It may be worthwhile to mention that the SUNCDS2 instance on the Enterprise
> console does not show the SQL Server Agent as being started, but I can
> navigate to the SUNCDS2 databases, and display the table information.  If I
> try to start the SQL Server Agent for SUNCDS2, I receive the message "Access
> is Denied".  The enterprise console on the SUNCDS2 machine indeed shows the
> SQL Server Agent as being started.
> 
> I have written a sample Java application that uses both the MS SQL Server
> ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to establish
> a connection to the SUNCDS2 instance.  This application resides on the
> SUNCDS1 network server.  The ODBC driver will connect to SUNCDS2 instance
> wihout a problem.
> 
> The JDBC driver does not connect to SUNCDS2.  The JDBC driver will, however,
> connect to the local SQL Server instance that resides on SUNCDS1.
> 
> Following are the code snippet to establish the JDBC driver connection, and
> also the DriverManager logging messages that show the failure.  (I have also
> included the messages regarding the successful ODBC connection to SUNCDS2 at
> the end of this post, for what it's worth).
> 
> static void testJDBCConnection()
>  {
>     System.out.println("testing JDBC connection type 4");
>  Driver d = null;
>  DriverManager.println("===================== testing JDBC connection type 4
> =====================");
> 
>  try {
>   d =
> (Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
> 
>   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
>   } catch (InstantiationException e) {e.printStackTrace();}
>     catch (IllegalAccessException e) {e.printStackTrace();}
>     catch (ClassNotFoundException e) {
>          e.printStackTrace();}
>     try
>     {
>         String url =
> "jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master";
>         System.out.println(url);
>         System.out.println(d);
>         Connection conn = DriverManager.getConnection(url, "sa", "scd123");
>         DatabaseMetaData dma = conn.getMetaData ();
>   System.out.println("\nConnected to " + dma.getURL());
>   System.out.println("Driver       " +    dma.getDriverName());
>   System.out.println("Version      " +   dma.getDriverVersion());
>   System.out.println("");
>   conn.close();
> 
>     }
>     catch (SQLException e) {e.printStackTrace();}
>  }
> 
> 
> ===================== testing JDBC connection type 4 =====================
>  registerDriver:
> driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver@7a1576]
>  DriverManager.getConnection("jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master")    tryingdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] *Driver.connect(jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master)    tryingdriver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver@7a1576] Connection.finalize sun.jdbc.odbc.JdbcOdbcConnection@79e304 *Connection.close 0 Statement(s) to close ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@273686 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver forJDBC]Connectiontimed out: connect at com.microsoft.jdbc.base.BaseExceptions.createException(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(UnknownSource) at com.microsoft.jdbc.base.BaseConnection.getNewImplC
onnection(UnknownSource) 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 SQLConnection.testJDBCConnection(SQLConnection.java:228) at SQLConnection.getDBConnection(SQLConnection.java:117) at SQLConnection.test(SQLConnection.java:22) at SQLConnection$1.actionPerformed(SQLConnection.java:66) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) atjavax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel..java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Compone
nt.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) atjava.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThr
ead.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) SQLException: SQLState(HY000) java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Errorestablishing 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(UnknownSource) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(UnknownSource) 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 SQLConnection.testJDBCConnection(SQLConnection.java:228) a
t SQLConnection.getDBConnection(SQLConnection.java:117) at SQLConnection.test(SQLConnection.java:22) at SQLConnection$1.actionPerformed(SQLConnection.java:66) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) atjavax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java
:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) atjava.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) SQLException: SQLState(08001) getConnection failed: java.sql.SQLException: [Microsoft][SQLServer 2000Driver for JDBC]Error establishing socket. :===================== testing ODBC connection ===================== DriverManager.g
etConnection("jdbc:odbc:Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; PWD=scd123")    tryingdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] *Driver.connect (jdbc:odbc:Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; PWD=scd123) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet Allocating Environment handle (SQLAllocEnv) hEnv=51647136 Allocating Connection handle (SQLAllocConnect) hDbc=51647304 Connecting (SQLDriverConnect), hDbc=51647304, szConnStrIn=Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; PWD=scd123 RETCODE = 1 WARNING - Generating SQLWarning... SQLWarning: reason([Microsoft][ODBC SQL Server Driver][SQL Server]Changeddatabase context to 'master'.) SQLstate(01000) vendor code(5701) SQLWarning: reason([Microsoft][ODBC SQL Server Driver][SQL Server]Changedlanguage setting to us_english.) SQLstate(01000) vendor code(5703) *Connection.getMetaData *Databa
seMetaData.getDriverName Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL *DatabaseMetaData.getDriverVersion Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 *DatabaseMetaData.getDriverName Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL Driver name:    JDBC-ODBC Bridge (SQLSRV32.DLL) *DatabaseMetaData.getDriverVersion Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 Driver version: 2.0001 (03.85.1117) Caching SQL type information *Connection.getMetaData *DatabaseMetaData.getTypeInfo Allocating Statement Handle (SQLAllocStmt), hDbc=51647304 hStmt=51650696 Get type info (SQLGetTypeInfo), hStmt=51650696, fSqlType=0 Number of result columns (SQLNumResultCols), hStmt=51650696 value=20 Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=10,len=300 03.52.0000 Fetching (SQLFetch), hStmt=51650696 Column attributes (
SQLColAttributes), hStmt=51650696, icol=1, type=2 value (int)=-9 Column attributes (SQLColAttributes), hStmt=51650696, icol=1, type=3 value (int)=256 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 sql_variant Get integer data (SQLGetData), hStmt=51650696, column=2 value=-150 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 uniqueidentifier Get integer data (SQLGetData), hStmt=51650696, column=2 value=-11 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 ntext Get integer data (SQLGetData), hStmt=51650696, column=2 value=-10 Get integer data (SQLGetData), hStmt=51650696, column=3 value=1073741823 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 nvarchar Get integer data (SQLGetData), hStmt=51650696, column=2 value=-9 Get integer data
 (SQLGetData), hStmt=51650696, column=3 value=4000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 sysname Get integer data (SQLGetData), hStmt=51650696, column=2 value=-9 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 nchar Get integer data (SQLGetData), hStmt=51650696, column=2 ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@30d82d Connection.finalize sun.jdbc.odbc.JdbcOdbcConnection@c09554 *Connection.close 0 Statement(s) to close ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@18bf072 value=-8 Get integer data (SQLGetData), hStmt=51650696, column=3 value=4000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 bit Get integer data (SQLGetData), hStmt=51650696, column=2 value=-7 Get integer data (SQLGetData), hStmt=51650696, column=3 value=1 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), h
Stmt=51650696, column=1, maxLen=257 tinyint Get integer data (SQLGetData), hStmt=51650696, column=2 value=-6 Get integer data (SQLGetData), hStmt=51650696, column=3 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 tinyint identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=-6 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 bigint Get integer data (SQLGetData), hStmt=51650696, column=2 value=-5 Get integer data (SQLGetData), hStmt=51650696, column=3 value=19 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 bigint identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=-5 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 image Get integer data (SQLGetData), hStmt=51650696, column=2 value=-4 Get integer data (SQLGetData), hSt
mt=51650696, column=3 value=2147483647 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 varbinary Get integer data (SQLGetData), hStmt=51650696, column=2 value=-3 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 binary Get integer data (SQLGetData), hStmt=51650696, column=2 value=-2 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 timestamp Get integer data (SQLGetData), hStmt=51650696, column=2 value=-2 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 text Get integer data (SQLGetData), hStmt=51650696, column=2 value=-1 Get integer data (SQLGetData), hStmt=51650696, column=3 value=2147483647 Fetching (SQLFetch), hStmt=51650696 Get 
string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 char Get integer data (SQLGetData), hStmt=51650696, column=2 value=1 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 numeric Get integer data (SQLGetData), hStmt=51650696, column=2 value=2 Get integer data (SQLGetData), hStmt=51650696, column=3 value=38 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 numeric() identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=2 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 decimal Get integer data (SQLGetData), hStmt=51650696, column=2 value=3 Get integer data (SQLGetData), hStmt=51650696, column=3 value=38 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 money Get integer data
 (SQLGetData), hStmt=51650696, column=2 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smallmoney Get integer data (SQLGetData), hStmt=51650696, column=2 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 decimal() identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 int Get integer data (SQLGetData), hStmt=51650696, column=2 value=4 Get integer data (SQLGetData), hStmt=51650696, column=3 value=10 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 int identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=4 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smallint Get integer data (SQLGetData), hStmt=51650696, col
umn=2 value=5 Get integer data (SQLGetData), hStmt=51650696, column=3 value=5 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smallint identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=5 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 float Get integer data (SQLGetData), hStmt=51650696, column=2 value=6 Get integer data (SQLGetData), hStmt=51650696, column=3 value=15 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 real Get integer data (SQLGetData), hStmt=51650696, column=2 value=7 Get integer data (SQLGetData), hStmt=51650696, column=3 value=7 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 datetime Get integer data (SQLGetData), hStmt=51650696, column=2 value=11 Get integer data (SQLGetData), hStmt=51650696, column=3 value=23 Fetching (S
QLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 smalldatetime Get integer data (SQLGetData), hStmt=51650696, column=2 value=11 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 varchar Get integer data (SQLGetData), hStmt=51650696, column=2 value=12 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 End of result set (SQL_NO_DATA) *ResultSet.close Free statement (SQLFreeStmt), hStmt=51650696, fOption=1 *ResultSet has been closed Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=44 int value=23 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=168 int value=8065 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=151 int value=73695 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=145 int value=69599 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=121 int value=15 Get connection info (
SQLGetInfo), hDbc=51647304, fInfoType=120 int value=2 Get connection info (SQLGetInfo), hDbc=51647304, fInfoType=153 int value=1 getConnection returningdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] *Connection.getMetaData *DatabaseMetaData.getURL *DatabaseMetaData.getDriverName Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL *DatabaseMetaData.getDriverVersion Get connection info string (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 *Connection.close 0 Statement(s) to close Disconnecting (SQLDisconnect), hDbc=51647304 Closing connection (SQLFreeConnect), hDbc=51647304 Closing environment (SQLFreeEnv), hEnv=51647136
> 

0
Joe
1/2/2005 7:17:52 PM
Stuart Leonard wrote:
> I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and
> the MS SQL 2000 Server JDBC driver.

FWIW, the M$ JDBC driver hasn't been well reviewed. I'd advise you to 
pick up a copy of the jTDS driver instead. Not that this is the answer 
to your problem, but it might be a good thing just the same.

Luke
0
Luke
1/2/2005 11:55:12 PM
Joe, thanks for the tip.  I am running Windows XP Professional OS.  I 
modified the Windows Firewall "Exceptions" tab on the node computer to allow 
port 1433.  That resolved the problem.  However, since I am not a network 
admin,  I am not sure that doing this was the best solution, but it worked.

"Joe Weinstein" <joeNOSPAM@bea.com> wrote in message 
news:41D848E0.5070600@bea.com...
> Hi. In order for the jdbc driver to connect to the DBMS, the DBMS needs to 
> be
> configured to listen for TCP connection requests. It does not do this by 
> default.
> Ie: "Mixed mode" connections in setup. 1433 is the default port for a 
> SQLServer
> to use for tcp connections. You should verify that the DBMS is using that 
> port...
> Joe Weinstein at BEA
>
> Stuart Leonard wrote:
>
>> I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, 
>> and
>> the MS SQL 2000 Server JDBC driver.
>>
>> I have installed and configured the MS SQL Server 2000 onto two 
>> computers,
>> which reside on the same network.  (In fact, these two computers comprise
>> the entire network).
>>
>> The network server (computer name=SUNCDS1), and the lone node (SUNCDS2),
>> each have their own SQL Server 2000 instance.
>>
>> The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL
>> Server instances, the (local) instance, which is SUNCDS1, and also 
>> SUNCDS2.
>> It may be worthwhile to mention that the SUNCDS2 instance on the 
>> Enterprise
>> console does not show the SQL Server Agent as being started, but I can
>> navigate to the SUNCDS2 databases, and display the table information.  If 
>> I
>> try to start the SQL Server Agent for SUNCDS2, I receive the message 
>> "Access
>> is Denied".  The enterprise console on the SUNCDS2 machine indeed shows 
>> the
>> SQL Server Agent as being started.
>>
>> I have written a sample Java application that uses both the MS SQL Server
>> ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to 
>> establish
>> a connection to the SUNCDS2 instance.  This application resides on the
>> SUNCDS1 network server.  The ODBC driver will connect to SUNCDS2 instance
>> wihout a problem.
>>
>> The JDBC driver does not connect to SUNCDS2.  The JDBC driver will, 
>> however,
>> connect to the local SQL Server instance that resides on SUNCDS1.
>>
>> Following are the code snippet to establish the JDBC driver connection, 
>> and
>> also the DriverManager logging messages that show the failure.  (I have 
>> also
>> included the messages regarding the successful ODBC connection to SUNCDS2 
>> at
>> the end of this post, for what it's worth).
>>
>> static void testJDBCConnection()
>>  {
>>     System.out.println("testing JDBC connection type 4");
>>  Driver d = null;
>>  DriverManager.println("===================== testing JDBC connection 
>> type 4
>> =====================");
>>
>>  try {
>>   d =
>> (Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
>>
>>   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
>>   } catch (InstantiationException e) {e.printStackTrace();}
>>     catch (IllegalAccessException e) {e.printStackTrace();}
>>     catch (ClassNotFoundException e) {
>>          e.printStackTrace();}
>>     try
>>     {
>>         String url =
>> "jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master";
>>         System.out.println(url);
>>         System.out.println(d);
>>         Connection conn = DriverManager.getConnection(url, "sa", 
>> "scd123");
>>         DatabaseMetaData dma = conn.getMetaData ();
>>   System.out.println("\nConnected to " + dma.getURL());
>>   System.out.println("Driver       " +    dma.getDriverName());
>>   System.out.println("Version      " +   dma.getDriverVersion());
>>   System.out.println("");
>>   conn.close();
>>
>>     }
>>     catch (SQLException e) {e.printStackTrace();}
>>  }
>>
>>
>> ===================== testing JDBC connection type 4 
>> =====================
>>  registerDriver:
>> driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver@7a1576]
>> 
>> DriverManager.getConnection("jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master") 
>> tryingdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] 
>> *Driver.connect(jdbc:microsoft:sqlserver://SUNCDS2:1433;databaseName=master) 
>> tryingdriver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver@7a1576] 
>> Connection.finalize sun.jdbc.odbc.JdbcOdbcConnection@79e304 
>> *Connection.close 0 Statement(s) to close ResultSet.finalize 
>> sun.jdbc.odbc.JdbcOdbcResultSet@273686 java.sql.SQLException: 
>> [Microsoft][SQLServer 2000 Driver forJDBC]Connectiontimed out: connect at 
>> com.microsoft.jdbc.base.BaseExceptions.createException(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(UnknownSource) 
>> at com.microsoft.jdbc.base.BaseConnection.getNewImplC
> onnection(UnknownSource) 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 
> SQLConnection.testJDBCConnection(SQLConnection.java:228) at 
> SQLConnection.getDBConnection(SQLConnection.java:117) at 
> SQLConnection.test(SQLConnection.java:22) at 
> SQLConnection$1.actionPerformed(SQLConnection.java:66) at 
> javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) 
> atjavax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) 
> atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel..java:420) 
> at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) 
> atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) 
> at java.awt.Component.processMouseEvent(Component.java:5100) at 
> java.awt.Compone
> nt.processEvent(Component.java:4897) at 
> java.awt.Container.processEvent(Container.java:1569) at 
> java.awt.Component.dispatchEventImpl(Component.java:3615) at 
> java.awt.Container.dispatchEventImpl(Container.java:1627) at 
> java.awt.Component.dispatchEvent(Component.java:3477) at 
> java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at 
> java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at 
> java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at 
> java.awt.Container.dispatchEventImpl(Container.java:1613) at 
> java.awt.Window.dispatchEventImpl(Window.java:1606) at 
> java.awt.Component.dispatchEvent(Component.java:3477) at 
> java.awt.EventQueue.dispatchEvent(EventQueue.java:456) 
> atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) 
> atjava.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) 
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) 
> at java.awt.EventDispatchThr
> ead.pumpEvents(EventDispatchThread.java:137) at 
> java.awt.EventDispatchThread.run(EventDispatchThread.java:100) 
> SQLException: SQLState(HY000) java.sql.SQLException: [Microsoft][SQLServer 
> 2000 Driver for JDBC]Errorestablishing 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(UnknownSource) 
> at 
> com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(UnknownSource) 
> 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 
> SQLConnection.testJDBCConnection(SQLConnection.java:228) a
> t SQLConnection.getDBConnection(SQLConnection.java:117) at 
> SQLConnection.test(SQLConnection.java:22) at 
> SQLConnection$1.actionPerformed(SQLConnection.java:66) at 
> javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) 
> atjavax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) 
> atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) 
> at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) 
> atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) 
> at java.awt.Component.processMouseEvent(Component.java:5100) at 
> java.awt.Component.processEvent(Component.java:4897) at 
> java.awt.Container.processEvent(Container.java:1569) at 
> java.awt.Component.dispatchEventImpl(Component.java:3615) at 
> java.awt.Container.dispatchEventImpl(Container.java:1627) at 
> java.awt.Component.dispatchEvent(Component.java:3477) at 
> java.awt.LightweightDispatcher.retargetMouseEvent(Container.java
> :3483) at 
> java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at 
> java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at 
> java.awt.Container.dispatchEventImpl(Container.java:1613) at 
> java.awt.Window.dispatchEventImpl(Window.java:1606) at 
> java.awt.Component.dispatchEvent(Component.java:3477) at 
> java.awt.EventQueue.dispatchEvent(EventQueue.java:456) 
> atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) 
> atjava.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) 
> SQLException: SQLState(08001) getConnection failed: java.sql.SQLException: 
> [Microsoft][SQLServer 2000Driver for JDBC]Error establishing socket. 
> :===================== testing ODBC connection ===================== 
> DriverManager.g
> etConnection("jdbc:odbc:Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; 
> PWD=scd123") 
> tryingdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] 
> *Driver.connect 
> (jdbc:odbc:Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; 
> PWD=scd123) JDBC to ODBC Bridge: Checking security No SecurityManager 
> present, assuming trusted application/applet Allocating Environment handle 
> (SQLAllocEnv) hEnv=51647136 Allocating Connection handle (SQLAllocConnect) 
> hDbc=51647304 Connecting (SQLDriverConnect), hDbc=51647304, 
> szConnStrIn=Driver={SQLServer};Server=SUNCDS2;Database=master;UID=sa; 
> PWD=scd123 RETCODE = 1 WARNING - Generating SQLWarning... SQLWarning: 
> reason([Microsoft][ODBC SQL Server Driver][SQL Server]Changeddatabase 
> context to 'master'.) SQLstate(01000) vendor code(5701) SQLWarning: 
> reason([Microsoft][ODBC SQL Server Driver][SQL Server]Changedlanguage 
> setting to us_english.) SQLstate(01000) vendor code(5703) 
> *Connection.getMetaData *Databa
> seMetaData.getDriverName Get connection info string (SQLGetInfo), 
> hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL 
> *DatabaseMetaData.getDriverVersion Get connection info string 
> (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 
> *DatabaseMetaData.getDriverName Get connection info string (SQLGetInfo), 
> hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL Driver name:    JDBC-ODBC 
> Bridge (SQLSRV32.DLL) *DatabaseMetaData.getDriverVersion Get connection 
> info string (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 
> Driver version: 2.0001 (03.85.1117) Caching SQL type information 
> *Connection.getMetaData *DatabaseMetaData.getTypeInfo Allocating Statement 
> Handle (SQLAllocStmt), hDbc=51647304 hStmt=51650696 Get type info 
> (SQLGetTypeInfo), hStmt=51650696, fSqlType=0 Number of result columns 
> (SQLNumResultCols), hStmt=51650696 value=20 Get connection info string 
> (SQLGetInfo), hDbc=51647304, fInfoType=10,len=300 03.52.0000 Fetching 
> (SQLFetch), hStmt=51650696 Column attributes (
> SQLColAttributes), hStmt=51650696, icol=1, type=2 value (int)=-9 Column 
> attributes (SQLColAttributes), hStmt=51650696, icol=1, type=3 value 
> (int)=256 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 sql_variant Get integer data (SQLGetData), hStmt=51650696, 
> column=2 value=-150 Get integer data (SQLGetData), hStmt=51650696, 
> column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 Get string data 
> (SQLGetData), hStmt=51650696, column=1, maxLen=257 uniqueidentifier Get 
> integer data (SQLGetData), hStmt=51650696, column=2 value=-11 Fetching 
> (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, 
> column=1, maxLen=257 ntext Get integer data (SQLGetData), hStmt=51650696, 
> column=2 value=-10 Get integer data (SQLGetData), hStmt=51650696, column=3 
> value=1073741823 Fetching (SQLFetch), hStmt=51650696 Get string data 
> (SQLGetData), hStmt=51650696, column=1, maxLen=257 nvarchar Get integer 
> data (SQLGetData), hStmt=51650696, column=2 value=-9 Get integer data
> (SQLGetData), hStmt=51650696, column=3 value=4000 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 sysname Get integer data (SQLGetData), hStmt=51650696, column=2 
> value=-9 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 nchar Get integer data (SQLGetData), 
> hStmt=51650696, column=2 ResultSet.finalize 
> sun.jdbc.odbc.JdbcOdbcResultSet@30d82d Connection.finalize 
> sun.jdbc.odbc.JdbcOdbcConnection@c09554 *Connection.close 0 Statement(s) 
> to close ResultSet.finalize sun.jdbc.odbc.JdbcOdbcResultSet@18bf072 
> value=-8 Get integer data (SQLGetData), hStmt=51650696, column=3 
> value=4000 Fetching (SQLFetch), hStmt=51650696 Get string data 
> (SQLGetData), hStmt=51650696, column=1, maxLen=257 bit Get integer data 
> (SQLGetData), hStmt=51650696, column=2 value=-7 Get integer data 
> (SQLGetData), hStmt=51650696, column=3 value=1 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), h
> Stmt=51650696, column=1, maxLen=257 tinyint Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=-6 Get integer data (SQLGetData), 
> hStmt=51650696, column=3 value=3 Fetching (SQLFetch), hStmt=51650696 Get 
> string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 tinyint 
> identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=-6 
> Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 bigint Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=-5 Get integer data (SQLGetData), 
> hStmt=51650696, column=3 value=19 Fetching (SQLFetch), hStmt=51650696 Get 
> string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 bigint 
> identity Get integer data (SQLGetData), hStmt=51650696, column=2 value=-5 
> Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 image Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=-4 Get integer data (SQLGetData), hSt
> mt=51650696, column=3 value=2147483647 Fetching (SQLFetch), hStmt=51650696 
> Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 
> varbinary Get integer data (SQLGetData), hStmt=51650696, column=2 value=-3 
> Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 
> Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 binary Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=-2 Get integer data (SQLGetData), 
> hStmt=51650696, column=3 value=8000 Fetching (SQLFetch), hStmt=51650696 
> Get string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 
> timestamp Get integer data (SQLGetData), hStmt=51650696, column=2 value=-2 
> Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 text Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=-1 Get integer data (SQLGetData), 
> hStmt=51650696, column=3 value=2147483647 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 char Get integer data (SQLGetData), hStmt=51650696, column=2 
> value=1 Get integer data (SQLGetData), hStmt=51650696, column=3 value=8000 
> Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 numeric Get integer data 
> (SQLGetData), hStmt=51650696, column=2 value=2 Get integer data 
> (SQLGetData), hStmt=51650696, column=3 value=38 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 numeric() identity Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=2 Fetching (SQLFetch), hStmt=51650696 Get 
> string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 decimal Get 
> integer data (SQLGetData), hStmt=51650696, column=2 value=3 Get integer 
> data (SQLGetData), hStmt=51650696, column=3 value=38 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 money Get integer data
> (SQLGetData), hStmt=51650696, column=2 value=3 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 smallmoney Get integer data (SQLGetData), hStmt=51650696, 
> column=2 value=3 Fetching (SQLFetch), hStmt=51650696 Get string data 
> (SQLGetData), hStmt=51650696, column=1, maxLen=257 decimal() identity Get 
> integer data (SQLGetData), hStmt=51650696, column=2 value=3 Fetching 
> (SQLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, 
> column=1, maxLen=257 int Get integer data (SQLGetData), hStmt=51650696, 
> column=2 value=4 Get integer data (SQLGetData), hStmt=51650696, column=3 
> value=10 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 int identity Get integer data 
> (SQLGetData), hStmt=51650696, column=2 value=4 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 smallint Get integer data (SQLGetData), hStmt=51650696, col
> umn=2 value=5 Get integer data (SQLGetData), hStmt=51650696, column=3 
> value=5 Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 smallint identity Get integer data 
> (SQLGetData), hStmt=51650696, column=2 value=5 Fetching (SQLFetch), 
> hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, column=1, 
> maxLen=257 float Get integer data (SQLGetData), hStmt=51650696, column=2 
> value=6 Get integer data (SQLGetData), hStmt=51650696, column=3 value=15 
> Fetching (SQLFetch), hStmt=51650696 Get string data (SQLGetData), 
> hStmt=51650696, column=1, maxLen=257 real Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=7 Get integer data (SQLGetData), 
> hStmt=51650696, column=3 value=7 Fetching (SQLFetch), hStmt=51650696 Get 
> string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 datetime 
> Get integer data (SQLGetData), hStmt=51650696, column=2 value=11 Get 
> integer data (SQLGetData), hStmt=51650696, column=3 value=23 Fetching (S
> QLFetch), hStmt=51650696 Get string data (SQLGetData), hStmt=51650696, 
> column=1, maxLen=257 smalldatetime Get integer data (SQLGetData), 
> hStmt=51650696, column=2 value=11 Fetching (SQLFetch), hStmt=51650696 Get 
> string data (SQLGetData), hStmt=51650696, column=1, maxLen=257 varchar Get 
> integer data (SQLGetData), hStmt=51650696, column=2 value=12 Get integer 
> data (SQLGetData), hStmt=51650696, column=3 value=8000 Fetching 
> (SQLFetch), hStmt=51650696 End of result set (SQL_NO_DATA) 
> *ResultSet.close Free statement (SQLFreeStmt), hStmt=51650696, fOption=1 
> *ResultSet has been closed Get connection info (SQLGetInfo), 
> hDbc=51647304, fInfoType=44 int value=23 Get connection info (SQLGetInfo), 
> hDbc=51647304, fInfoType=168 int value=8065 Get connection info 
> (SQLGetInfo), hDbc=51647304, fInfoType=151 int value=73695 Get connection 
> info (SQLGetInfo), hDbc=51647304, fInfoType=145 int value=69599 Get 
> connection info (SQLGetInfo), hDbc=51647304, fInfoType=121 int value=15 
> Get connection info (
> SQLGetInfo), hDbc=51647304, fInfoType=120 int value=2 Get connection info 
> (SQLGetInfo), hDbc=51647304, fInfoType=153 int value=1 getConnection 
> returningdriver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1f06dc3] 
> *Connection.getMetaData *DatabaseMetaData.getURL 
> *DatabaseMetaData.getDriverName Get connection info string (SQLGetInfo), 
> hDbc=51647304, fInfoType=6,len=300 SQLSRV32.DLL 
> *DatabaseMetaData.getDriverVersion Get connection info string 
> (SQLGetInfo), hDbc=51647304, fInfoType=7,len=300 03.85.1117 
> *Connection.close 0 Statement(s) to close Disconnecting (SQLDisconnect), 
> hDbc=51647304 Closing connection (SQLFreeConnect), hDbc=51647304 Closing 
> environment (SQLFreeEnv), hEnv=51647136
>>
> 


0
Stuart
1/3/2005 3:12:49 AM
Irrespective of the driver used, MS SQL will still need to communicate
over port 1433 (or some other port that we define), right?

So, if I want to communicate over a network to a Machine running MS SQL
(or any other DB) I will need to open a port, right?

- manzoor

0
Manzoorul
1/6/2005 4:59:39 PM
Reply:

Similar Artilces:

Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to manage them all. When I tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a message saying it's not compatible, so I'll have to use 2005 I guess. We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM work with these okay? Also I want to make sure SQL 2005 Enterprise Manager won't be adding to, changing, or 'upgrading' the DTS scripts or anythi...

MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services,
MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other 16,000 more CDs, [ no dongles, no activations, etc ... needed ! ] (free donge)! No time limitation! CD NR 4203 MicroSoft SQL Server 2000 4in1 CD NR 9452 Microsoft SQL Server 2000 Service Pack 2 CD NR 11 298 AppDev SQL Server 2000 Accelerated Training [3 CDs] CD NR 12 000 Microsoft SQL Server 2000 Developer Edition 64 Bit CD NR 13 424 TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1 CD NR 14 688 SQL Server 2000 Reporting Services (c) Microsoft CD NR 15 412 SQL Server 2000 Reporting Services Enterprise (c) Microsoft please send e-mail, to ola2@mail.gr, zorba@mail.gr ...

MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services,
MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other 16,000 more CDs, [ no dongles, no activations, etc ... needed ! ] (free donge)! No time limitation! CD NR 4203 MicroSoft SQL Server 2000 4in1 CD NR 9452 Microsoft SQL Server 2000 Service Pack 2 CD NR 11 298 AppDev SQL Server 2000 Accelerated Training [3 CDs] CD NR 12 000 Microsoft SQL Server 2000 Developer Edition 64 Bit CD NR 13 424 TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1 CD NR 14 688 SQL Server 2000 Reporting Services (c) Microsoft CD NR 15 412 SQL Server 2000 Reporting Services Enterprise (c) Microsoft please send e-mail, to ola2@mail.gr, zorba@mail.gr ...

MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Ser
MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other 16,000 more CDs, [ no dongles, no activations, etc ... needed ! ] (free donge)! No time limitation! CD NR 4203 MicroSoft SQL Server 2000 4in1 CD NR 9452 Microsoft SQL Server 2000 Service Pack 2 CD NR 11 298 AppDev SQL Server 2000 Accelerated Training [3 CDs] CD NR 12 000 Microsoft SQL Server 2000 Developer Edition 64 Bit CD NR 13...

MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services,
MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other 16,000 more CDs, [ no dongles, no activations, etc ... needed ! ] (free donge)! No time limitation! CD NR 4203 MicroSoft SQL Server 2000 4in1 CD NR 9452 Microsoft SQL Server 2000 Service Pack 2 CD NR 11 298 AppDev SQL Server 2000 Accelerated Training [3 CDs] CD NR 12 000 Microsoft SQL Server 2000 Developer Edition 64 Bit CD NR 13 424 TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1 CD NR 14 688 SQL Server 2000 Reporting Services (c) Microsoft CD NR 15 412 SQL Server 2000 Reporting Services Enterprise (c) Microsoft please send e-mail, to ola2@mail.gr, zorba@mail.gr ...

jdbc connection problem to ms sql server 2000
What have been done: ------------------------------- installed jdbc driver for ms sql server 2000; found a sample / edited it to form some java code for testing connection to a sql server 2000 db; compiled it; java run time/environment: jre1.5.0x Problem: when attempted to execute/run the java class even adding all the correct classpath (for mssqlserver.jar and the two jar files), and yet jre complained about class not found error, wtf? searched the NG for possible solution to no avail. dissed. what's wrong? tia. Problem resolved. Stupid MS default path for the driver installation. Setting the classpath at dos command line like c:\program files\... is the culprit. NickName wrote: > What have been done: > ------------------------------- > installed jdbc driver for ms sql server 2000; > found a sample / edited it to form some java code for testing > connection to a sql server 2000 db; > compiled it; > > java run time/environment: jre1.5.0x > > Problem: > when attempted to execute/run the java class even adding all the > correct classpath (for mssqlserver.jar and the two jar files), and yet > jre complained about class not found error, wtf? > > searched the NG for possible solution to no avail. dissed. > > what's wrong? > > tia. ...

trouble getting a connection from MS SQL Server 2000 database server from WSAD
Hi , I have java servlet that creates a connection from connection pool . and I am getting the following errror.I am working on WSAD 4.x. I am using Microsoft SQL Server 2000 JDBC Driver Implementation class: com.microsoft.jdbcx.sqlserver.SQLServerDataSource and provided all the required jar files located at. C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib.also i have given the resoure properties. WebSphere DataSource:CMProperties for DataSource "MSSQLServerConDev" DataSource Properties [com.microsoft.jdbcx.sqlserver.SQLServerDataSou...

SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases
While I was out of the office the Lan Team moved one of my SQL Server 2000 servers to a new network domain. Since then the maintenance job has not ran. The error log for the SQL Agents has the message listed in the subject line. I have not found any useful articles on the MS SQL Server site. Anyone know what might be wrong and how to fix it. HTH -- Mark D Powell -- Mark D Powell (Mark.Powell@eds.com) writes: > While I was out of the office the Lan Team moved one of my SQL Server > 2000 servers to a new network domain. Since then the maintenance job > has not ran. > &...

Java Web Server 6.1 & Pooled SQL Server 2000 JDBC Connections
If anyone can shed some light on this problem I would greatly appreciate it. I am unsuccessfully trying to use a database connnection retrieved from a pool configured using Java System Web Server 6.1 with the SQL Server 2000 JDBC Driver. The background: 1. I have downloaded the SQL Server 2000 JDBC Driver and installed it on the web server. 2. I used the Administration GUI to add the .jars(namely msbase.jar, msutil.jar, and mssqlserver.jar), to the classpath. 3. Upon creating a simple JSP to access connection metadata using the direct connect method, ie., Class.forName( com.m...

Entreprise Manager error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '#####'. The user is not associated with a trusted SQL Server connection.(28000,18452)"
Can anyone give a quick description of the meaning of this message and what needs to be done to get a connection. I'm running DBArtisan with SQLServer 2000 client SP4 installed. I also get the same message with MS Enterprise Manager so this is coming out of the actual ODBC connection attempt. Thanks in advance! In the future, please do not put part of your message in the subject line. Makes it harder to read. In any case, you're trying to do integrated login and don't have that login set up in the DB. You need to add that login, or change to a SQL Login. -- Greg Moore SQL...

Problem by design
Hi. Sorry for cross posting! After I've installed MS-SQL Server 2000, I've got a problem each time I open a table, view or diagram in design, in a MS-Access project. Something like a table is popping up, but only the headline of the table, there is no name in the headline. The (ghost) table is automatic getting focus, (like a dialog box), and I can't do anything. I can close the (ghost) table using ALT-F4 combination, but it is very annoying me. I've tried to uninstall both the MS-SQL Server 2000 and MS-Access 2000, I've also tried to compact and repair the dat...

Help! SQL Server error
Dear all, On Win2000 server with SP3, I am trying to access a SQL Server 7.0 database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO 2.7. In SQL Server Enterprise Manager, there is a login named "Tester". In its property window, NO "Server Roles" was assigned but its "Database Access" was set to "TestDB". This login was also made as the user of "TestDB" with "public", "db_datareader" and "db_datawriter" selected as its "Database role membership". All the tables I am trying to ac...

Problem with JDBC Driver for MS SQL Server
Dear All, I developed an web application which use MS SQL Server 2000. I encounter the following SQLException "[Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache". Did anyone encounter this problem before? What does this exception mean and how to solve this problem? [Remarks: The web application work properly on development machine and this machine but encounter this exception when move to another machine, so is this exception related to the machine?] Thank you for your attention. Yours faithfully, Benny Benny wrote: > Dear Al...

MS SQL Linked Servers(Linking MySQL to MS SQL) Collation problem.
Hello, I have a problem. I've linked MySql server to MsSql, in MySql I have a table with Latvian data(character set is ucs2, ucs2_general_ci) and the problem is that when I use openquery to read data from MySQL server, some characters are not translated correctly! I receive question symbols instead of Latvian special characters. Maybe someone had this kind of problem with collation? P?vels Mihailovs (iceravenlv@gmail.com) writes: > I have a problem. I've linked MySql server to MsSql, in MySql I have a > table with Latvian data(character set is ucs2, ucs2_general_ci) and > th...

MS SQL Server 2000 / MS Access
Hello all! I have such question to all of you. I have some tables linked from MS SQL Server 2000. Is time of processing query based on these linked tables from MS SQL Server 2000, faster or slower than the time of processing the same query based on tables, which are not linked but imported to MS Access? Can you answer this question? Thank you in advance for posts Marcin from Poland. No idea - it depends how big the tables are, what your queries look like, how you execute your queries etc. If you're using stored procedures, for example, then I would expect MSSQL to be faster, as all...

Writing to TEXT Field in MS SQL SERVER with MS JDBC Driver
Has anyone out there gotten this message java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). upon executing a PreparedStatement when using TEXT fields? I am not sure how to properly set my TEXT field parameter. Do I use stmt.setObject(...) stmt.setAsciiStream(...) stmt.setBinaryStream(...) I did use a non-prepared statement e.g. INSERT INTO mytable (textfield) VALUES ('my test text') And it worked. However, I'd like do this the right way so as not to fall into some sort of SQL string size limitation. My prepared statement looks something like this INSERT INTO mytable (textfield) VALUES (?) Any help would be appreciated. thanks, Moran Ben-David "Moran Ben-David" <moran@rogers.com> wrote in message news:Tm6xb.63360$X2W1.36370@news04.bloor.is.net.cable.rogers.com... > Has anyone out there gotten this message > > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > JDBC]Invalid parameter binding(s). > > upon executing a PreparedStatement when using TEXT fields? I am not sure > how to properly set my TEXT field parameter. Do I use > > stmt.setObject(...) > stmt.setAsciiStream(...) > stmt.setBinaryStream(...) > > I did use a non-prepared statement e.g. > > INSERT INTO mytable (textfield) VALUES ('my test text') > > And it worked. How...

ODBC connection
Hello all! I have such question to all of you. I have some tables linked from MS SQL Server 2000. Is time of processing query based on these linked tables from MS SQL Server 2000, faster or slower than the time of processing the same query based on tables, which are not linked but imported to MS Access? Can you answer this question? Thank you in advance for posts Marcin from Poland. On Tue, 19 Apr 2005 17:23:48 +0200, "Kamyk" <marcinzmyslowski@poczta.onet.pl> wrote: >Hello all! > >I have such question to all of you. >I have some tables linked from MS SQL Serv...

java.sql.Date value truncated using JDBC in MS-SQL Server
Hi, I'm trying to write a java.sql.Date to a database and the minutes/ seconds etc. are not being written. I've seen and tested many examples found via searches and still have come up with nothing. Here's what I have: java.sql.Date formation - recommended constructor forms: java.sql.Date entryDttm = new java.sql.Date(System.currentTimeMillis()); OR java.sql.Date entryDttm = new java.sql.Date(new java.util.Date().getTime()); // prepared statement insert pstmt.setDate(1, entryDttm); // what is written to database 2007-02-07 12:00:00.000 // what needs to be w...

Query related to JDBC connectivity to MS-SQL server 2000
Hi, I'm running MS-SQL Server 2000 on a server with a database "EPROC" I'm trying to connect it with JSP using Tomcat 5.5.9 I used the following statements Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://NIT2;databaseName=EPROC;user=sa"); where NIT2 is my server name java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. Is this syntax correct ? or Is there anything to configure in tomcat server ? How to know the url of a dat...

Java Web Server 6.1 & Pooled SQL Server 2000 JDBC Connections
If anyone can shed some light on this problem I would greatly appreciate it. I am unsuccessfully trying to use a database connnection retrieved from a pool configured using Java System Web Server 6.1 with the SQL Server 2000 JDBC Driver. The background: 1. I have downloaded the SQL Server 2000 JDBC Driver and installed it on the web server. 2. I used the Administration GUI to add the .jars(namely msbase.jar, msutil.jar, and mssqlserver.jar), to the classpath. 3. Upon creating a simple JSP to access connection metadata using the direct connect method, ie., Class.forName( com.m...

Too few parameters expected 2 error occurs after migrating "MS Access 2000" to "MS SQL Server"
Hello all I get Too few parameters expected 2 error and "The MS Jet Database engine cannot find the input table or query "myTempTablename". Make sure it exists and that its name is spelled correctly. 3078" after I migrated "MS Access 2000" to "MS SQL Server 2000" and relinked all linked tables. The front-end interface of my application is MS Access 2000. The back-end is MS SQL Server 2000. After I migrated the database and relinked all linked tables, "Too few parameters expected 2" and "input table or query "myTempTablename" 30...

calling external vb.net code in labview and how to connect database(sql server 2000, MS access)
kindly help me in solving my queries. 1) how to call vb.net codes in labview. &nbsp; 2) how to call vb codes in labview. &nbsp; 3) how to connect database like sql server 2000, MS access with labview. &nbsp; kindly mention if there is any tutorial link to my quries. &nbsp; Hi! &nbsp; to point 3) We use the Enterprise connectivity toolkit from NI. Search site about. You also can use DDE to access MS-Access. See Examples that are installed with LabVIEW. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...

Connecting to MS SQL Server 2000
I need to be able to querry the database on a Microsoft SQL Server 2000 from my Ruby script. My only experience has been to connect to a MySQL database and I'm hoping that someone from this august forum might be able to point me in the right direction? thanks jack -- Posted via http://www.ruby-forum.com/. This may help. Its for 2005, though: https://www.ruby-forum.com/topic/125915 On Fri, Jun 12, 2009 at 3:47 PM, jackster the jackle<johnsheahan@sflistdb.com> wrote: > I need to be able to querry the database on a Microsoft SQL Server 2000 > from my Ruby script. > >...

MS SQL Server 2000 and Java
Hi all, I have a problem that deals with long time of creation java.sql.Statement object: Statement stmt =conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPD ATABLE); Time of call of such line is sometimes 4500 milisec. Database: Microsoft SQL Server 2000, JRE: JVM 1.4.1 JDBC Drivers: Microsoft w. SP 1 I do not use JDBC - ODBC bridge. Does anybody know why it takes so much time? When application and DB server is on the same machine everythink works fine. When I connect form other machine times of creation Statement object are too big. Gregory ...

Web resources about - MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket) - comp.lang.java.databases

Treaty establishing a Constitution for Europe - Wikipedia, the free encyclopedia
The Treaty establishing a Constitution for Europe (TCE), (commonly referred to as the European Constitution or as the Constitutional Treaty ), ...

Establishing Shot: The 405 - Flickr - Photo Sharing!
Photo by Mrs. Newbie. Nearly 15,000 views! This is I-405 on the west side. This is Los Angeles, without a doubt. NOTE: I changed the rights to ...

Successfully Establishing and Representing DevOps in an Audit by James DeLuccia - YouTube
Presented at FlowCon San Francisco 2013 http://flowcon.org/flowcon-sanfran-2013/schedule/index.jsp Organizations and development teams are moving ...

Why NRL should revisit idea of establishing its own TV channel
WAY back in 1994, pay television was but a twinkling in Australia's eye. But ARL head honchos John Quayle and Ken Arthurson had an idea:

France releases case establishing chemical attack against Assad
A FRENCH intelligence report says forces loyal to Bashar al-Assad carried out a "massive" chemical attack last month, as the Syrian leader warned ...

Trade union royal commission: Federal Government establishing police taskforce to investigate corruption ...
... a police taskforce to investigate evidence of criminal conduct uncovered by the trade union royal commission. The Federal Government is establishing ...

Boko Haram says it's establishing Islamic Caliphate in Nigeria
Boko Haram, Nigeria's Islamic extremist rebel group, said it controls the northeastern city of Gwoza and has added it to an Islamic state that ...

Ontario leads way in establishing advisory group on physician-assisted dying
Ontario, with the participation of 11 provinces and territories, is establishing an "expert advisory group" to look at the issues of physician-assisted ...

China Praises Trudeau's Father For His 'Extraordinary Vision' In Establishing Relations
Xi Jinping told Canada's current prime minister that China will never forget Pierre Elliott Trudeau's decision to open diplomatic relations. ...

21 Asian countries sign MOU on establishing AIIB
People's Daily Online 21 Asian countries sign MOU on establishing AIIB People's Daily Online Chinese Finance Minister Lou Jiwei (L front) ...

Resources last updated: 3/2/2016 8:34:32 PM