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 ?
posted 14 years ago
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");
posted 11 years ago
>> 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