By skyforbes 
[ODBC Source [2]] Error: Open Database Connectivity (ODBC) error occurred. state: ‘HY000’. Native Error Code: 2008. [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.10-log]MySQL client ran out of memory
When trying to retrieve data from MySQL, MariaDB or AWS Aurora via ODBC MySQL connector, you might encounter the above error.
Its not a server issue, tweaking your ODBC connector solves the issue.
ODBC Settings click
Details button
Under Connection Tab
Check the Enable Automatic reconnect
Under Cursor / Results Tab
Check the following boxes
Don’t cache results of forward-only cursors
Force use of forward-only cursors.
Enabling forward only doesn’t have capability to move forward / backward in the result set. If something goes wrong, it again starts from first to last.