connection to sqlserver using jsp(urgent)

[doniravi]

hi all......

this is ravi
i m new to this forum.....

ok coming to the point

i m using database sqlserver n trying to conect through jsp

i installed sql server drivr 2000 in my system

when try to run my appliication i m getting following error

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

my code is:

<%@ page import = "java.io.*" import = "java.lang.*"
import = "java.sql.*" %>

<%
out.println("<h2>Successfully logged </h2>");
try
{
Class.forName("com.microsoft.jdbc.SQLServerDriver" );
Connection con=DriverManager.getConnection( "jdbc:SqlServer://localhost:8080/ravi","sa","sa");

Statement st = con.createStatement();

String sql="INSERT INTO ravi1 VALUES ('Michael', 'dba', '90000' )";
st.executeUpdate(sql);


give me advice

waiting for u r reply............

thanks in advance


regards..
ravi

[acoder]

You've posted a similar question earlier which has already been moved to the Javascript forum, though I think the Java forum would be more ideal for JSP problems.