• 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
Sheriff
Posts: 36032
432
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
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!