aspose file tools*
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 Spring in Action this week in the Spring 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
 
Don't get me started about those stupid light bulbs.
 
subject: Error in establishing socket (sqlserver2000 driver)