This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
I wanted to make a connection to ODBC TEST 1:- Instead of creating a system dsn like "TestDSN" below String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String dbServer = "jdbc dbc:TestDSN"; String dbLogin = ""; String dbPassword = ""; Class.forName(dbDriver); return DriverManager.getConnection(dbServer, dbLogin, dbPassword);
TEST 2":- Is it possible to directly specify the mdb file instaead of creating dsn and connecting as below
Hi Sunil, the very principle of ODBC is the access to a datasource by a DSN, so you can't acceed the mdb-file directly via the JDBC-ODBC-Bridge. I never heard of a JDBC-driver for MS Access yet. I think it wouldn't change a lot, because when accessing MS Access your local JET engine has to do all database related computation, so some little overhead created by the JDBC-ODBC-bridge won't kill the rat (or whatever Greetings, Samuel