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

New to MATLAB?

Connect Matlab to SQL Server using visual query builder

Asked by George

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

Oleg Komarov

on 26 Aug 2011

Use jdbc connection.

George

George

Products

No products are associated with this question.

3 Answers

Answer by the cyclist

the cyclist

on 26 Aug 2011

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

0 Comments

the cyclist

the cyclist

Answer by George

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

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

George

Answer by Edward Smart

Edward Smart

on 21 Dec 2011

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

0 Comments

Edward Smart

Edward Smart

Contact us