What's the status of 64-bit MATLAB support for ODBC?

3 次查看(过去 30 天)
Hi! I'm trying to get more information to answer my boss' question: "why are we still compiling in 32-bit MATLAB?" I knew it was due to problems with 64-bit MATLAB's support of ODBC (I know, it's really MicroSoft's fault), but I was/am vague on the details. I searched the MathWorks site for "64-bit ODBC" and "64-bit ODBC MicroSoft" and got lots of hits--nothing I clicked on, however, was dated 2012 or later--all essentially asking 'why does my DB code not work in 64-bit MATLAB' with the responses all being variations on 'MicroSoft f#$%ed-up the ODBC API for their 64-bit DB apps; workarounds are: A) revert back to 32-bit Matlab, or B) switch your Matlab apps to JDBC.' But those responses were meager on the details and thus, taken together, rather confusing (or at least not elucidating); I'm hoping someone can provide a clear, succinct explanation of the issues involved and the status quo. Thanks!
  1 个评论
Paul
Paul 2014-1-17
Hi, are there still no possibilities to handle a 32bit DB with a 64bit Matlab 2013b? It is no option for me to use 32bit Matlab. Thanks!

请先登录,再进行评论。

采纳的回答

Friedrich
Friedrich 2014-1-17
Hi,
please note that this is not a MATLAB limitation. An ODBC drive is a DLL (so a native library) which needs to get loaded into the process and a 64bit application cannot laod a 32bit DLL.
You could upgrade to a 64bit ODBC driver and use
database.ODBCConnection
to connect to your database using a 64bit ODBC driver. This function was introduced in R2013b.

更多回答(1 个)

Jing
Jing 2013-1-24
Hi,
I know little about ODBC, but I found the system requirement page in MathWorks web site: http://www.mathworks.cn/products/availability/index.html
The Database Toolbox are supported for ODBC on both 32bit and 64bit Windows from the webpage.

Community Treasure Hunt

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

Start Hunting!

Translated by