MATLAB Answers


Database Toolbox: Talking to MS Access using JDBC

Asked by sst
on 13 Jun 2012
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?

  1 Comment

Point to note: The problem seems to exist with both MDB and ACCDB files.

Sign in to comment.

1 Answer

Answer by Andreas Pomp on 17 Apr 2013
 Accepted Answer

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


Sign in to comment.