permaculture playing cards
The moose likes JDBC and Relational Databases 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 Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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)
 
It's not a secret anymore!