JDBC Exception Resolution connecting to SQL Server

[doniravi]

hi all
i need help to connect to sql ser4ver usng jsp

i m using sql server 2000,i installed Microsoft SQL Server 2000
Driver for JDBC in my system....
i placed all jar files in class path....

when try to run my applicatio 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 in</h2>");
try
{
Class.forName("com.microsoft.jdbc.SQLServerDriver" );
Connection con=DriverManager.getConnection
("jdbc:host://localhost:8080/ravi","srinivas","sa""sa");
Statement st = con.createStatement();

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

[Colloid Snake]

hi all
i need help to connect to sql ser4ver usng jsp

i m using sql server 2000,i installed Microsoft SQL Server 2000
Driver for JDBC in my system....
i placed all jar files in class path....

when try to run my applicatio 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 in</h2>");
try
{
Class.forName("com.microsoft.jdbc.SQLServerDriver" );
Connection con=DriverManager.getConnection
("jdbc:host://localhost:8080/ravi","srinivas","sa""sa");
Statement st = con.createStatement();

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

Just to make sure, you have either included the the jdbc .jar file with the program, or added it to your classpath, correct? What what environment are you using?

Also, in your code:

("jdbc:host://localhost:8080/ravi","srinivas","sa""sa"); // is there a reason you have 'sa' in there twice in quotes? (Is "sasa" your passwd, or is it just "sa"?)
 

[r035198x]

Just to make sure, you have either included the the jdbc .jar file with the program, or added it to your classpath, correct? What what environment are you using?

Also, in your code:

("jdbc:host://localhost:8080/ravi","srinivas","sa""sa"); // is there a reason you have 'sa' in there twice in quotes? (Is "sasa" your passwd, or is it just "sa"?)
 

And also just to add that all this should really have been taking place in the Java forum

[Banfa]

And now it is :D

And I have also given the thread a more meaningful name.

[r035198x]

And now it is :D

And I have also given the thread a more meaningful name.

Thanks Banfa. I hope the OP's problem was resolved.

[hirak1984]

i think you should add ojdbc14.jar or at least classes12.jar in the libraries.
then probs will be solved