MySQL client ran out of memory

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.

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: