Sorry for my stupid, I still don't know how to form the data source url for creating a connection. Example: If I have a MS Access database- "JavaTest.mdb", I write code as follows, It always says cannot find the data source. WHAT should the variable "url" be?
Class.forName("jdbc.odbc.JdbcOdbcDriver"); //loads the driver String url = "jdbc dbc:MS Access;DBQ=c:\\JavaTest.mdb"; Connection con = DriverManager.getConnection( url, "userID", "passwd");
If somedoay can help me, please mail to me "firstname.lastname@example.org". Thanks and wish you good luck! [This message has been edited by fengzixuan zheng (edited August 23, 2001).]