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

Invalid URL on JDBC connection to SQL Server 2000

P: 12
hello sir...

i m using sql server 2000 database and usig jsp to access it
when accessig i am getting followig error

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

i installed Microsoft SQL Server 2000 Driver for JDBC in my system.
do i need to do ay thing extra other tha thse thing?

this is my code:

<%@ page import = "java.io.*" import = "java.lang.*"
import = "java.sql.*" %>
<%
out.println("<h2>Successfully logged in11111111</h2>");
try
{
Class.forName("com.microsoft.jdbc.SQLServerDriver" );
Connection con=DriverManager.getConnection( "jdbc:host://localhost:8080/ravi","sa","sa");
Statement st = con.createStatement();
String sql="INSERT INTO ravi1 VALUES ('Michael', 'dba', '90000' )";
st.executeUpdate(sql);
}


waiting for u r rply


thanks in advace
Jan 20 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
This question is being moved to the Javascipt Forum.

ADMIN
Jan 21 '07 #2

Post your reply

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