Skip to Content
0
Former Member
Sep 02, 2009 at 10:10 PM

JDBC connection to Microsoft Access database

51 Views

I am attempting to connect to a Microsoft Access database table in the report designer but I'm having limited success. When I create a new JDBC connection, I fill it out accordingly (selecting the default JDBC Connection):

Connection URL:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Projects/sample.mdb;

Database Classname: sun.jdbc.odbc.JdbcOdbcDriver

There is no password (or username) set for the database so I click Next twice and it connects and shows me a list of the databases that are in that folder. When I try to drill-down on one of them I get this unhelpful error:

Database Connector Error: 'Exception: [Error Message:]null'

Any thoughts as to why is this happening? Is it because the JDBC driver doesn't play well with Access?

Thank you,

Evan