Re: about connect to sql 2000

Hi,

Your error log says "Error establishing socket".
Most obvious reason might be your client is not able to
talk to the server via the port "1433". Make sure that
server is listening on 1433 TCP/IP.

For details how to enable TCP/IP on 1433:

PRB: Error Establishing Socket with JDBC Driver
http://support.microsoft.com/default.aspx?scid=kb;en-us;313185


For further details :

INFO: Microsoft SQL Server 2000 Driver for JDBC Does Not Support HTTP
Tunneling
http://support.microsoft.com/default.aspx?scid=kb;en-us;313178

HOW TO: Get Started with Microsoft JDBC
http://support.microsoft.com/default.aspx?scid=kb;en-us;313100


HTH
John

-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[email protected]]On Behalf Of Jen
Sent: Sunday, May 25, 2003 1:34 PM
To: [email protected]
Subject: Re: about connect to sql 2000


try to use:
Driver driver = Class.forName(...);
COnnection conn  = driver.connect(...);

--- hxd han <[email protected]> wrote:

---------------------------------
Dear all;
I want to use the mssql jdbc to connent to sql2000;
as:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection

("jdbc:microsoft:sqlserver://a18:1433","sa","");

I get the exception :
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)


tks




---------------------------------
MSN 8 helps ELIMINATE E-MAIL VIRUSES.  Get 2 months
FREE*.______________________________________________________________________
_____To
unsubscribe, send email to [email protected] and
include in the bodyof the message "signoff
SERVLET-INTEREST".Archives:
http://archives.java.sun.com/archives/servlet-interest.htmlResources:
http://java.sun.com/products/servlet/external-resources.htmlLISTSERV
Help: http://www.lsoft.com/manuals/user/user.html


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html