MATLAB Answers

sst
0

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?
Thanks.

  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

  0 Comments

Sign in to comment.