By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,918 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,918 IT Pros & Developers. It's quick & easy.

connection to sqlserver using jsp(urgent)

P: 12
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
Jan 22 '07 #1
Share this Question
Share on Google+
1 Reply


acoder
Expert Mod 15k+
P: 16,027
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.
Jan 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.