how to configure multiple ODBC datasources without using Data Explorer

2017 7 13
1 个回答
更新时间：2017 7 19
5 次查看（30 天）

0 个投票

I need to set up multiple access databases all at once and so wonder if I can set the datasources all at once using command line without using DataExplorer.
Thanks

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

回答（1 个）

Amit Doshi
Amit Doshi 2017-7-17

0 个投票

Hello Dean,
You can create multiple connection objects for multiple databases using the command line.
For example:
conn1 = database('dbtoolboxdemo','admin','admin');
conn2 = database('dbtoolboxdatabase_2','admin','admin');
Refer the below link to know how to connect to Microsoft Access Using ODBC Driver and Command Line: https://www.mathworks.com/help/database/ug/microsoft-access-odbc-windows.html#bt8kis8-1

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Dean Deng
Dean Deng 2017-7-19
Actually what I am asking is how to configure and build up the datasource through the command line; not connecting to the datasource. I ended up using cmd command lines to set up the datasource with odbcconf. Hope that this might help others who are seeking similar answers.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

提问:

Dean Deng
Dean Deng
2017-7-13

评论：

Dean Deng
Dean Deng
2017-7-19

Community Treasure Hunt

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

Start Hunting!

Translated by