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

Oleg Komarov
on 26 Aug 2011

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

Chirag Gupta
on 26 Aug 2011

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.


Discover MakerZone

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

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!