MATLAB Answers

George

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.

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


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


Answer by Edward Smart
on 21 Dec 2011

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

  0 Comments


Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply today