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

3 次查看（过去 30 天）
David Goldsmith
David Goldsmith 2013-1-24
回答： Friedrich 2014-1-17
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.

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by