JDBC Driver for SQL Server 2005, Class not found Exception

TOPIC CREATED: 2007-05-15

First Post devtamil
Registered: 2007-05-14 - Posts: 8

Hai, i am tried to use the Sql Server with Java and Tomcat 5.0 Application Server. But the connection doesn't created.
I am using the JDBC Driver for Java connecting with SQL Server. I am using SQL Server 2005.
I have used the following code for java database connectivity with SQL Server.

import java.sql.*;
public class Test {
public static void main(String[] args)
//load the driver class
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://; DatabaseName=timetracking ");
catch(ClassNotFoundException cnfe)
catch (SQLException sqle)

The above code was compiled successfully, but it's not running. The below error was raised. I have coped and paste it the JDBC Driver class for SQL Server 2005(sqljdbc.jar) to the WEB-INF/lib folder

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

I don't know what i am doing with wrong. If anybody know, how to solve this, kindly post me.



0 Replies