Connect Matlab to SQL Server using visual query builder

1 次查看（过去 30 天）
George
George 2011-8-26
Hi
I am trying to connect to SQL Server using ODBC data source. I have windows 7 x64, matlab 7.11.00 (R2010b) and Microsoft SQL Server 2008 R2.
I have added the SQL Data Source but when i click on the database name, Matlab visual query builder ask for a username and password.
This happens and if i use the "odbcad32.exe" located in SysWOW64 directory.
Sorry for my english.
Any help would be apreciated.

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

回答（3 个）

the cyclist
the cyclist 2011-8-26
You could ask the database administrator what your username and password are.
George
George 2011-8-26
I have used the correct username and password but matlab can not "see" the databases. I installed the 32 bit version of matlab and i used the odbcad32.exe located in System32 directory and the problem stops.
  1 个评论
Chirag Gupta
Chirag Gupta 2011-8-26
When you were using 64 bit MATLAB, did you set up the 64 bit ODBC admin?
http://www.mathworks.com/support/solutions/en/data/1-BF0CBI/index.html?product=DB&solution=1-BF0CBI

请先登录，再进行评论。

Edward Smart
Edward Smart 2011-12-21
I have the same issue, and my Matlab is 64bit.

类别

在 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