Database Toolbox: Talking to MS Access using JDBC

2 次查看（过去 30 天）
sst
sst 2012-6-13
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.

请先登录，再回答此问题。

采纳的回答

Andreas Pomp
Andreas Pomp 2013-4-17
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by