MySQL Forums
Forum List  »  Microsoft Access

Microsoft Access ODBC call failed MySQL client ran out of memory #2008
Posted by: Stephen Rigo
Date: November 16, 2022 08:41AM

Hello all,
I have been using AWS MySQLfor large databases for many years and have done analysis using Microsoft Access as a front end on my computer using MySQL ODBC Connector. Recently I upgraded to My Connector 8.0.31 32 Bit. I am losing connection to the database when I try to run queries on Large datasets with linked tables.

In testing I found that I can run query that returns 9 months of data without a problem. When I change the query to return 10 months I get the error below.


My error is ODBC call failed
MySQL ODBC 8.0(a) Driver mysqld - 5.7.12 MySQL client ran out of memory #2008

Is this a server configuration, parameter, or resource issue?

Or is this a Connector issue that needs some parameters changed?

Or is this my Computer running out of memory?

Options: ReplyQuote


Subject
Views
Written By
Posted
Microsoft Access ODBC call failed MySQL client ran out of memory #2008
22
November 16, 2022 08:41AM


Sorry, only registered users may post in this forum.

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.