MATLAB Answers

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

3 views (last 30 days)
David Goldsmith
David Goldsmith on 24 Jan 2013
Answered: Friedrich on 17 Jan 2014
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 Comment
Paul
Paul on 17 Jan 2014
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!

Sign in to comment.

Accepted Answer

Friedrich
Friedrich on 17 Jan 2014
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.

More Answers (1)

Jing
Jing on 24 Jan 2013
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