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

12 vues (au cours des 30 derniers jours)
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

Réponses (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

Catégories

En savoir plus sur Converters (High power) dans Help Center et File Exchange

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by