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

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.

1 Comment

Oleg Komarov on 26 Aug 2011

Use jdbc connection.

George

Products

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.

0 Comments

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?
http://www.mathworks.com/support/solutions/en/data/1-BF0CBI/index.html?product=DB&solution=1-BF0CBI

George
Answer by Edward Smart on 21 Dec 2011

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

0 Comments

Edward Smart

Contact us