Error when using JDBC Driver- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Question

I am trying to use the Microsoft SQL Server 2008 Type 4 JDBC Driver in a java desktop application.

However when I run the program I get the following error--

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

How do I overcome this error? The code looks to be OK as it is...Its a single sql statement to be executed into local sql server 2008 database.

Darin Dimitrov · Accepted Answer · 2011-09-25 12:07:49Z

2

Make sure that the .jar containing this driver is in your CLASSPATH. Here's an article explaining how to setup this.

answered Sep 25, 2011 at 12:07

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user893664 Over a year ago

There are 2 Jar files in the driver for SQL Server 2008, I added both of those jars to the classpath variable, however I am still getting the same error?? (Note that the article you have helpfully linked to refers to jars for SQL Server 2000 so file names given there are different from those that I have with me for SQL Server 2008)...

Darin Dimitrov Over a year ago

@user893664, yes indeed the article I have linked to is for SQL Server 2000, but the same principles apply. The .jat files must in the CLASSPATH. It's simple. If you get this error it means that your are not.

user893664 Over a year ago

ok i checked, what you are saying is correct... Couple of things that I want to add- Sometimes in Windows if the jar is in a folder whose name>8 chars, then it may not work, in such case put the jar in C:\jdbc\ (or something else with folder name's length<=8 chars) and then add this to class path.... Also the JAR also has to be registered in the IDE (in addition to specifying class path in system settings). Thanks a ton for your help Darin...

Darin Dimitrov Over a year ago

@user893664, those are very good points that you brought. Indeed they are all important and must be taken care of. I am glad that you managed to get this working.

Collectives™ on Stack Overflow

Error when using JDBC Driver- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related