Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error in establishing socket (sqlserver2000 driver)

 
satya nath
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1324
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
have a look this thread hope this helps to resolve this..
 
Muhammad Saifuddin
Ranch Hand
Posts: 1324
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
by googling i found something related with above error
http://support.microsoft.com/kb/313178
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic