JDBC connection to Microsoft Access database

[Former Member]

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

Edited by: Evan Soukoreff (Rewired Software) on Sep 2, 2009 9:27 PM (bold font didn't work so well)

Edited by: Evan Soukoreff (Rewired Software) on Sep 2, 2009 9:28 PM

[former_member11696 · Accepted solution]

This was posted to the Database forum. Access is for testing only and not reliable.

[Former Member · Accepted solution]

Thank Don yes this was a cross-post - I accidentally filed my question in the wrong forum.