Skip to Content
author's profile photo Former Member
Former Member

JDBC connection to Microsoft Access database

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 30, 2009 at 08:15 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.