Connect Matlab to SQL Server using visual query builder

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.

[Oleg Komarov]

Use jdbc connection.

Answer 1

[the cyclist]

You could ask the database administrator what your username and password are.

Answer 2

[George]

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.

[Chirag Gupta]

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

Answer 3

[Edward Smart]

I have the same issue, and my Matlab is 64bit.