Connect Matlab to SQL Server using visual query builder

1 次查看(过去 30 天)
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 CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by