JOIN DEVPPL

It looks like you are new here. If you want to get involved, click on Join below!



JDBC Driver for SQL Server 2005, Class not found Exception


D

keyboard_arrow_up
0
keyboard_arrow_down


First Post Mark as Spam devtamil
Posts: 8 - Registered: 2007-05-14 00:06:57

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.

Quoted text
import java.sql.*;
public class Test {
public static void main(String[] args)
{
try
{
//load the driver class
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433; DatabaseName=timetracking ");
}
catch(ClassNotFoundException cnfe)
{
System.err.println(cnfe);
}
catch (SQLException sqle)
{
System.err.println(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.

Thanks

Tamilvanan






JOIN DEVPPL

It looks like you are new here. If you want to get involved, click on Join below!




MENU
Advertising