Hi, I use ASP code to generate report that I retrieve about 100,000 to
800,000 records from database using ADODB.Recordset. But when i run the
code, it show me the following error.Sometimes it wont show me this
error and it can be run. But if the records near 800,000 then program
show me the following error. If the records is about 100,000 sometimes
it can be run correctly.
Provider error '8007000e'
Not enough storage is available to complete this operation.
/e-survey/progress3.asp, line 192
Here is my code:
L188: Set rst = server.CreateObject("ADODB.RecordSet")
L189: rst.Open strSQL, connection, 3, 3
L191: iProcessedSoFar ...