Professional Web Applications Themes

Provider error '8007000e' - ASP Database

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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default 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



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

  2. #2

    Default Re: Provider error '8007000e'

    Please read the following pages as you don't seem to know that you are
    not supposed to "cross-post"

    http://www.aspfaq.com/show.asp?id=2081
    http://www.microsoft.com/communities/conduct/default.mspx

    Dayron wrote:
     

    joker Guest

  3. #3

    Default Re: Provider error '8007000e'

    Please note that this issue was also posted in the
    microsoft.public.inetserver.asp.general newsgroup. I'll be posting over
    there unless someone posts over here.

    joker wrote:
     
    >
    >[/ref]

    joker Guest

  4. #4

    Default Re: Provider error '8007000e'

    joker wrote: 

    :-)
    Looks like you could stand to read those pages as well. It's not
    crossposting to which we object, it's multiposting.
    Multiposting vs Crossposting: http://www.blakjak.demon.co.uk/mul_crss.htm

    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Guest

  5. #5

    Default Re: Provider error '8007000e'

    Sorry I couldn't remember which one was which.

    Bob Barrows [MVP] wrote:
     
    >
    >
    > :-)
    > Looks like you could stand to read those pages as well. It's not
    > crossposting to which we object, it's multiposting.
    > Multiposting vs Crossposting: http://www.blakjak.demon.co.uk/mul_crss.htm
    >[/ref]

    joker Guest

Similar Threads

  1. Server object error 'ASP 0177 : 8007000e'
    By NB in forum ASP Components
    Replies: 5
    Last Post: October 24th, 10:08 AM
  2. Replies: 4
    Last Post: October 22nd, 10:02 AM
  3. Provider error '8007000e' - Not enough storage ...
    By Claudio Ledermann in forum ASP
    Replies: 7
    Last Post: August 22nd, 07:19 PM
  4. Provider error?
    By Ray at in forum ASP
    Replies: 10
    Last Post: August 1st, 12:49 AM
  5. Replies: 2
    Last Post: July 1st, 02:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139