Provider error '8007000e'
 

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

Wat does the error message means? is it memory error or coding error?
can anyone pls let me know?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Re: Provider error '8007000e'
 

I'd suggest the following articles since you didn't post enough
information for me to say just one of them.

http://www.aspfaq.com/show.asp?id=2131
http://www.aspfaq.com/show.asp?id=2301
http://www.aspfaq.com/show.asp?id=2355

Hopefully one of those will help you with this error.

Dayron wrote:

> 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
>
> Wat does the error message means? is it memory error or coding error?
> can anyone pls let me know?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Re: Provider error '8007000e'
 

I had that error, and it was a networking error. not an asp error.

Could that be true for you?

"joker" <no-spam@netzero.com> wrote in message
news:O5Ygh2miEHA.1644@tk2msftngp13.phx.gbl...
> I'd suggest the following articles since you didn't post enough
> information for me to say just one of them.
>
> http://www.aspfaq.com/show.asp?id=2131
> http://www.aspfaq.com/show.asp?id=2301
> http://www.aspfaq.com/show.asp?id=2355
>
> Hopefully one of those will help you with this error.
>
> Dayron wrote:
>
> > 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
> >
> > Wat does the error message means? is it memory error or coding error?
> > can anyone pls let me know?
> >
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>