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

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.


the cyclist
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.


Edward Smart

Contact us