java - ClassNotFoundException: com.microsoft.sqlserver.jdbc

Question

When I ran my web application under Eclipse IDE everything worked fine. But when I exported my project into war-file and deployed in tomcat I've got following message:

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

I've tried putting sqljdbc4.jar everywhere:

• catalina-homelib dir
• WEB-INFlib dir
• both of them

What I'am missing? Environment: tomcat 6.0.20, sql server 2005

Answer 1

The driver class is "com.microsoft.sqlserver.jdbc.SQLServerDriver". You've just missed the class name off the end.