I want to connect to SQL 2000 database, I tried it with - Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn=DriverManager.getConnection("jdbc dbc:A"); Statement stmt=conn1.createStatement(); but its not working. Does anyone have the code to connect java to SQL 2000, the might be 4-5 line code ?
Joined: Jan 08, 2002
Try this: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con; //establish the connection with the data source String url = "jdbc dbc:MyDataSource"; con = DriverManager.getConnection(url, "loginName" ,"password");
Joined: Sep 20, 2001
>> String url = "jdbc dbc:MyDataSource";
How to code "MyDataSource"?
BJ - SCJP and SCWCD
We love Java programming. It is contagious, very cool, and lot of fun. - Peter Coad, Java Design