how to configure multiple ODBC datasources without using Data Explorer

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

Answer 1

[Amit Doshi]

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

[Dean Deng]

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.