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 (view profile)

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 (view profile)

on 26 Aug 2011

Use jdbc connection.

George

George (view profile)

Products

No products are associated with this question.

3 Answers

Answer by the cyclist

the cyclist (view profile)

on 26 Aug 2011

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

0 Comments

the cyclist

the cyclist (view profile)

Answer by George

George (view profile)

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 (view profile)

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 (view profile)

Answer by Edward Smart

Edward Smart (view profile)

on 21 Dec 2011

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

0 Comments

Edward Smart

Edward Smart (view profile)

Contact us