Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connection Problem With SqlServer 2000 using Microsoft jdbc Driver

 
kiran mohan
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Everybody,
I am getting the below exception when i am trying out to execute the program that just connects sql server 2000 using java. I wish somebody help me solve the problem.


java.lang.ClassNotFoundException:com.microsoft.jdbc.sqlserver.SQLServerDrive


Thank You
Kiran
 
Annie Smith
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Download the SQL server driver JARs and add them to the runtime classpath.
 
kiran mohan
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank You Annie, I have done as said and it worked out fine. Thank you once again
bye take care
kiran
 
yi qian
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everybody.I have a problem.I have connection problem with sqlserver2000 using Mirosoft jdbc Driver in XP operation System.But I got the problem:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
Could you tell me what's wrong?Thank you in advance
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yi,
Are you able to connect to SQL Server from the command line (aka not through Java)

Welcome to JavaRanch! For the future, note that since this is a new question it is ok to start a new thread.

Jeanne
JDBC Forum Bartender
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic