MATLAB: 32-bit and 64-bit and DB issues, oh the!

32-bit v. 64-bitDatabase Toolboxodbc driversql server

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!

Best Answer

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.
Related Question