Error Message :
Open Database Connectivity (ODBC) error occurred. state: ‘HY000’. Native Error Code: 2008. [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.1.22-MariaDB]MySQL client ran out of memory
This error is caused due to large number of rows that are stored in client machine memory. If you are reading data from MYSQL and not performing any seek operation, then you can disable Caching and free up the memory.
Control Panel > Administrative Tools > ODBC (64 big ODBC client)
C:\Windows\SysWOW64\odbcad32.exe (32 bit ODBC client)
Open your DSN Name > Configure > Details > Cursor / Results and check “Don’t cache results of forward-only cursors.