SP_6721
Honored Contributor II

Hi @Y2KEngineer 

This issue is likely related to row fetching limits or buffer sizes in the driver or system settings. You can try adjusting a couple of things in your ODBC connection string:

  • Set RowsFetchedPerBlock=50000 to make sure it fetches all rows in one go.
  • Add EnableCloudFetch=0 to turn off Cloud Fetch, which sometimes causes problems with large result sets due to network or firewall restrictions.