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