MATLAB® crashes when using a Microsoft® Access™ ODBC driver

4 次查看（过去 30 天）
MathWorks Computational Finance Team
回答： MathWorks Computational Finance Team 2020-4-6
When you use the Microsoft® Access™ ODBC driver, MATLAB sometimes experiences unexpected behavior. The stack trace from a crash might be:
[ 0] 0x00007ff94f826de4 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01076708
[ 1] 0x00007ff94f826ee3 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01076963
[ 2] 0x00007ff94f825e8b C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01072779
[ 3] 0x00007ff94f8260b4 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01073332
[ 4] 0x00007ff94f82e3e8 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01106920
[ 5] 0x00007ff94f7ef30d C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00848653
[ 6] 0x00007ff94f7f5b25 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00875301
[ 7] 0x00007ff94f80818f C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00950671
[ 8] 0x00007ff94f7c24b5 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00664757
[ 9] 0x00007ff94f883180 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01454464

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

回答（1 个）

MathWorks Computational Finance Team
To avoid the unexpected behavior, you can use either of these workarounds:
  • Upgrade to the Access 2016 ODBC driver.
  • Create a MATLAB function to open the Access database connection, execute an SQL query, and close the connection; for example:
function out = myQueryExecute(sqlquery)
conn = database(datasource,username,password);
out = select(conn,sqlquery);
close(conn)
end

类别

在 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