Hi,
I get the following error when I try to connect to MSAccess in
JSP :
Root Error-1: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'DriverId'.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'DriverId'.
The same piece of jave code is able to retrieve data when executed as a
java application.
this is the piece of java code:
------------------- -----------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection =
DriverManager.getConnection(
"jdbc
dbc:Access","","") ;
statement= connection.createStatement();
statement.executeQuery("select * from <tablename>");
------------------------------
I would appreciate any help in this matter.
Thanks
info_seeker
