wood burning stoves 2.0*
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
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Error in establishing socket (sqlserver2000 driver)
 
Similar Threads
Connecting to sql server
connection Problem With SqlServer 2000 using Microsoft jdbc Driver
JDBC Conection pool
Error establising socket for Weblogic81 to Oracle9i
SQL Exception -Error establishing socket