By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,053 Members | 1,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,053 IT Pros & Developers. It's quick & easy.

Provider error '8007000e'

P: n/a
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!
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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!


Jul 19 '05 #2

P: n/a
I had that error, and it was a networking error. not an asp error.

Could that be true for you?

"joker" <no*****@netzero.com> wrote in message
news:O5**************@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!

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.