MATLAB Answers

32-bit and 64-bit and DB issues, oh my!

20 views (last 30 days)
Hi! Just had my platform upgraded to Win7 64-bit (from 32-bit XP). Trying to get my database toolbox stuff to work. After failing w/ 64-bit R2012a, I installed 32-bit R2011b, which is what I was using before the upgrade, i.e., under which everything worked fine. Here's the output of ver:
>> ver
-------------------------------------------------------------------------------------
MATLAB Version 7.13.0.564 (R2011b)
MATLAB License Number: xxxxx
Operating System: Microsoft Windows 7 Version 6.1 (Build 7601: Service Pack 1)
Java VM Version: Java 1.6.0_17-b04 with Sun Microsystems Inc. Java HotSpot(TM) Client VM mixed mode
-------------------------------------------------------------------------------------
MATLAB Version 7.13 (R2011b)
Database Toolbox Version 3.10 (R2011b)
SEAWATER Library Version 3.2
Signal Processing Toolbox Version 6.16 (R2011b)
(Note the absence of 64-bit in the Java info line; the About window also indicates I'm running a 32-bit MATLAB, but these posts don't allow screenshots, so you'll just have to take my word for it. :-) )Here's the info on the SQL Server driver I'm using, courtesy of odbcad32.exe:
SQL Server Version 6.01.7601.17514 File SQLSRV32.DLL
In other words, AFAICT, I am using a 32-bit Matlab and a 32-bit ODBC driver. Now, here's what I get when I try to establish a MATLAB connection to a database I have no trouble connecting to using SQL Server Management Studio:
>> DB = database('EAPMW','','');
>> DB.Message
ans =
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application Please verify that login information and database url are valid.
When I search the MathWorks Web site for "DSN contains an architecture mismatch," all I get is 'make sure the bit-version of your MATLAB matches the bit-version of yur ODBC driver.' Any other ideas? Thanks!
  2 Comments
Andreas Goser
Andreas Goser on 10 Sep 2013
FYI, I xxxed out the license number...

Sign in to comment.

Accepted Answer

Juan B. Gutierrez
Juan B. Gutierrez on 18 May 2012
There are two ODBC managers availabe to you:
%windir%\system32\odbcad32.exe
and
%windir%\SysWOW64\odbcad32.exe
One manges 32-bit ODBCs and the other 64-bit ODBCs. Try creating your DSN in both 32 and 64 bit versions of the ODBC manager. Additionally, you might want to check the answer at: http://www.mathworks.com/matlabcentral/answers/37595-how-can-i-read-database-from-database-row-by-row
Hope that helps. Good luck.
  3 Comments
Keith Phillips
Keith Phillips on 10 Sep 2013
Should I be able to use .NET to connect to a 32bit version of Access with a 64bit version of Matlab?

Sign in to comment.

More Answers (1)

Thomas Vargas
Thomas Vargas on 5 Dec 2012
Getting the JDBC Drivers to work right is really really complicated and almost not worth it.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by