Configure ODBC Data Sources without dexplore

Question

BSantos 2013-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/88187-configure-odbc-data-sources-without-dexplore

评论： Marc Youcef 2018-7-6

Hello!!

So, here's my project:

I would like to update a Ms Access Database, via GUI using Database Toolbox, whenever the user wants. so far, I was able to do so, following the tutorial suggested by Matlab.

But, before we start, we have to configure OBDC Data sources using the dexplore function or Apps > Database Explorer.

My question is: Is there any way of doing the same without dexplore? Using commands, for example or code.

I ask this, because, I don't want my User to be troubled with this set up, every time he starts the program. Perhaps, just giving File directory/path... So far, I couldn't find any solution.

Any suggestions/ideas??

Thanks in advance!!!

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

请先登录，再进行评论。

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

Answer 1

Mihir Daptardar 2014-1-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/88187-configure-odbc-data-sources-without-dexplore#answer_121200

Assuming that you are on a WINDOWS system, there is a way to configure ODBC Data sources from outside of MATLAB as well. Please note that you would need admin rights on the computer that you are using to configure.

Click on Start Menu and type ODBC Data Sources (For Windows Vista and Later) or you can navigate to C:\Windows\SysWOW64\odbcad32.exe

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

Marc Youcef 2018-7-6

Hi, I do not know if this answers his question as he is looking for a programmatic way to do this configuration. I am looking actually for similar thing without having to go through any interface (windows or MATLAB). Thanks.

请先登录，再进行评论。