MATLAB Answers


Connect Matlab to SQL Server using visual query builder

Asked by George
on 26 Aug 2011


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.

  1 Comment

Use jdbc connection.


No products are associated with this question.

3 Answers

Answer by the cyclist
on 26 Aug 2011

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


Answer by George
on 26 Aug 2011

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 Comment

When you were using 64 bit MATLAB, did you set up the 64 bit ODBC admin?

Answer by Edward Smart
on 21 Dec 2011

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


Join the 15-year community celebration.

Play games and win prizes!

Learn more
Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

MATLAB Academy

New to MATLAB?

Learn MATLAB today!