How to connect to database file in 2018b with GUI?

4 次查看（过去 30 天）
BSantos
BSantos 2018-10-24
编辑： BSantos 2018-10-24
Hi everyone,
I have developed a GUI that enables the user to connect, open and fetch results from a Microsoft Access file (.mdb). My code was previously written in Matlab R2014b (32-bit) using JDBC:OBDC bridge, which is no longer valid in Matlab R2018b (64-bit). The code below is active when the user pushes a GUI button.
Matlab R2014b (32-bit) code:
[file, dir] = uigetfile('*.mdb','Get Database','Database Selector');
DB.dbpath = fullfile(dir, file);
DB.conurl = ['jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ='DB.dbpath];
DB.con = database('','','','sun.jdbc.odbc.JdbcOdbcDriver', DB.conurl);
Question 1: Can someone help me on how to update this code for Matlab 2018b 64-bit version?
Question 2: Is it possible to set up a button on GUI to open Database Explorer, when the user runs application?
My system:
  • Windows 7, 64-bit
  • Matlab R2018b 64-bit
Thank you very much for your help!

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

回答（0 个）

类别

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

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by