how to configure multiple ODBC datasources without using Data Explorer

Question

Dean Deng 2017-7-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/348513-how-to-configure-multiple-odbc-datasources-without-using-data-explorer

评论： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Amit Doshi 2017-7-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/348513-how-to-configure-multiple-odbc-datasources-without-using-data-explorer#answer_274476

在 MATLAB Online 中打开

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 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.

请先登录，再进行评论。