how to configure multiple ODBC datasources without using Data Explorer

2 views (last 30 days)
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

Answers (1)

Amit Doshi
Amit Doshi on 17 Jul 2017
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 Comment
Dean Deng
Dean Deng on 19 Jul 2017
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.

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!