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

3 次查看（过去 30 天）
David Goldsmith
David Goldsmith 2012-5-17
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 个评论
Geoff
Geoff 2012-5-18
What happens if you install the 64-bit ODBC driver?
Andreas Goser
Andreas Goser 2013-9-10
FYI, I xxxed out the license number...

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Juan B. Gutierrez
Juan B. Gutierrez 2012-5-18
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 个评论
显示 1更早的评论
Juan B. Gutierrez
Juan B. Gutierrez 2012-5-19
David, I am glad this answer helped you :) I am not familiar with the database toolbox, even though I access heterogeneous databases routinely from MATLAB (e.g. MySQL, SQL Server, Oracle, Posgres). I use .NET within MATLAB to do that (that is the link I posted in my initial answer). I find the .NET libraries to access ANY database to be very powerful and complete. You could do the same with Java classes. Therefore, you have many avenues to access your database.
Keith Phillips
Keith Phillips 2013-9-10
Should I be able to use .NET to connect to a 32bit version of Access with a 64bit version of Matlab?

请先登录，再进行评论。

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by