Table has a total of 120,000 rows and 20 columns. When I run a select query on mysql directly like:

select * from <tablename> where UpdatedOn > '2020-10-05'

it gives the results which is about 50+ rows.

But when I run the same from MSSQL using ODBC Connection it throws "MySQL Client Out of Memory" every single time.

• The server has 8 GB RAM and no one else is using the server
• Running Select top gives the results without the error
• Running select with a single integer column like select id from ... throws a "MySQL Client out of memory"

What could be going wrong? I haven't been able to the issue.

Table has a total of 1,120,000 rows and 20 columns. When I run a select query on mysql directly like:

select * from <tablename> where UpdatedOn > '2020-10-05'

it gives the results which is about 50+ rows.

But when I run the same from MSSQL using ODBC Connection it throws "MySQL Client Out of Memory" every single time.

• The server has 8 GB RAM and no one else is using the server
• Running Select top gives the results without the error
• Running select with a single integer column like select id from ... throws a "MySQL Client out of memory"

What could be going wrong? I haven't been able to the issue.