MySQL Forums
Forum List  »  Microsoft Access

ODBC--call failed [MySQL][ODBC 5.3(w) Driver]pmysqld-5.7.15-log] Sort Aborted
Posted by: Kurt Vangsness
Date: October 07, 2016 05:39PM

I have 3 tables in a MySQL Data Schema on which I am trying to perform a summary query in MS Access via ODBC. The query connects the tables via Left Joins, i.e., Table 1=>Table 2=>Table 3. The joined fields have indexes.

Table 1 contains about 1.9 million records
Table 2 contains about 15 thousand records
Table 3 contains about 100 records

The MySQL Schema is connected via System DSN using the 32-bit MySQL ODBC 5.3 Unicode Driver.

When I run the Query, I receive the following error message in MS Access:

ODBC--call failed.
[MySQL][ODBC 5.3(w) Driver]pmysqld-5.7.15-log]Sort Aborted: Query execution was interrupted, maximum statement execution time exceeded (#1028)

I haven't been able to find anything via multiple searches on the MySQL site or in other developer forums that illuminates the issue and why it is occurring.

Is this a ODBC or MySQL settings issue or setup issue or is it a Performance issue or other?

Options: ReplyQuote

Written By
ODBC--call failed [MySQL][ODBC 5.3(w) Driver]pmysqld-5.7.15-log] Sort Aborted
October 07, 2016 05:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.