Provider error '8007000e'

  • Thread starter Thread starter Dayron
  • Start date Start date
D

Dayron

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.

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 = 0

L192: If Not rst.EOF Then
L193: arrRecords = rst.GetRows
L194: iTotalRecords = Ubound(arrRecords,2) + 1
L195: rst.MoveFirst
L196: End If
 
Note that this is not the right NG to post ASP questions,
you will get better help posting to:

microsoft.public.inetserver.asp.general and/or

microsoft.public.inetserver.asp.db

Willy.
 
Back
Top