• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Error while accessing MSAccess in JSP

 
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 149
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Your name 'info_seeker' does not comply with the JavaRanch naming policy. Please choose one that meets the requirements.
 
reply
    Bookmark Topic Watch Topic
  • New Topic