This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Error in establishing socket (sqlserver2000 driver) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error in establishing socket (sqlserver2000 driver)" Watch "Error in establishing socket (sqlserver2000 driver)" New topic
Author

Error in establishing socket (sqlserver2000 driver)

satya nath
Greenhorn

Joined: Feb 27, 2007
Posts: 9
Hi friends!

I am using JDBC to connect to sqlserver2000 driver i had downloaded sqlserver2000 sp3 driver and set my classpath to three jar files.

when i am trying to connect through java using
Driver d = (Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection dbCon = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=sa;selectMethod=cursor");

It is showing Connection failure :[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Please tell me how to resolve this problem
[ March 11, 2007: Message edited by: satya nath ]
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

have a look this thread hope this helps to resolve this..


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

by googling i found something related with above error
http://support.microsoft.com/kb/313178
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error in establishing socket (sqlserver2000 driver)
 
Similar Threads
Error establising socket for Weblogic81 to Oracle9i
connection Problem With SqlServer 2000 using Microsoft jdbc Driver
SQL Exception -Error establishing socket
Connecting to sql server
JDBC Conection pool