Connect Matlab to SQL Server using visual query builder

2011 8 26
3 个回答
1 次查看（30 天）

0 个投票

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

0 个投票

You could ask the database administrator what your username and password are.
George
George 2011-8-26

0 个投票

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 个评论
显示 -1更早的评论 隐藏 -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

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

提问:

George
George
2011-8-26

Community Treasure Hunt

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

Start Hunting!

Translated by