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

Question

David Goldsmith 2013-1-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59713-what-s-the-status-of-64-bit-matlab-support-for-odbc

回答： 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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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!

请先登录，再进行评论。

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

Answer 1

Friedrich 2014-1-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59713-what-s-the-status-of-64-bit-matlab-support-for-odbc#answer_121185

在 MATLAB Online 中打开

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.