how to configure multiple ODBC datasources without using Data Explorer

2 次查看（过去 30 天）
Dean Deng
Dean Deng 2017-7-13
评论： Dean Deng 2017-7-19
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
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 个评论
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.

请先登录，再进行评论。

类别

在 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