Database Toolbox: Talking to MS Access using JDBC

5 views (last 30 days)
Hi, I am attempting to use Sun's JDBC-ODBC bridge to connect to Microsoft Access using the Database Toolbox.
Configuration: Microsoft Access 2010 (32-bit), MATLAB R2010b (32-bit), running on Windows 7 Enterprise (64-bit).
The command I tried is:
conn = database('MS Access Database', '', '', ...
'sun.jdbc.odbc.JdbcOdbcDriver', ...
'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=<PATH TO ACCDB FILE>');
The message I get in conn.Message is
"[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'."
Is there a way to connect to a Microsoft Access ACCDB file using JDBC, without having to set up the data source in advance, if the path to the ACCDB file is available?
Thanks.
  1 Comment
sst
sst on 13 Jun 2012
Point to note: The problem seems to exist with both MDB and ACCDB files.

Sign in to comment.

Accepted Answer

Andreas Pomp
Andreas Pomp on 17 Apr 2013
We had the same problem. We could resolve it by replacing the 64 bit Matlab version by a 32 bit version. The connection to Microsoft Access runs smoothly with the 32 bit Matlab version. No additional installations od drivers were needed on our side.
Regards Andreas

More Answers (0)

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!