ADODB. Recordset out of memory exception while handling large data

Question

I have converted my c++ application to 64 bit and tried to load large data using msado15.dll Recordset object.

it gives out of memory error after loading 196224 records with 34 fields in each record ( around 2.3 gb) loaded but then it throws out of memory exception.

To utilize more memory space I have converted everything to 64 bit and make sure all are 64bit dll's but still fails at same as 32 bit version of the application.

Any problem with msado15.dll (64 bit) version of the dll.

Answer 1

Are you using server or client side cursor? Client cursor can eat up the memory. See The Significance of Cursor Location and https://learn.microsoft.com/en-us/sql/ado/guide/data/types-of-cursors-ado?view=sql-server-ver16