Professional Web Applications Themes

Provider error '8007000e' and Scripting.FileSystemObject - 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.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 ...

  1. #1

    Default Provider error '8007000e' and Scripting.FileSystemObject

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

    L192: If Not rst.EOF Then
    L193: arrRecords = rst.GetRows
    L194: iTotalRecords = Ubound(arrRecords,2) + 1
    L195: rst.MoveFirst
    L196: End If

    Another question here is I'm using scripting.FileSystemObject to write
    the data into the excel file. I manage to write all the data into the
    excel file but the excel worksheet just manage to write until 65535
    records and I couldnt write the data anymore. I wish to write the data
    into a few worksheet. can i know how to write the data into different
    worksheet in a workbook?

    I hope to get this solution asap as this is the last week issues not yet
    resolved.

    Thank you.



    *** 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' and Scripting.FileSystemObject

    Dayron wrote on 30 aug 2004 in microsoft.public.inetserver.asp.db:
     

    As it says, there is not enough memory allocated to hold

    800000 x number.of.fields x mean.field.length.
    [could be many many megabytes]

    Why would you want to retrieve them all at once?
    To show them on a web page?

    If the memory would not have errored out first,
    you probably would have got into timeout trouble.

    --
    Evertjan.
    The Netherlands.
    (Please change the x'es to dots in my emailaddress,
    but let us keep the discussions in the newsgroup)

    Evertjan. Guest

  3. #3

    Default Re: Provider error '8007000e' and Scripting.FileSystemObject

    Hi there

    Are you using the ASP code to read the data and then the file sys obj
    to save the data to a spreadsheet? This is my understanding of your
    questions.

    1 - Why do you need to read so many records in an ASP page?
    2 - If you're writing to an Excel file, why are you using ASP?

    You could use VBA in Excel to read directly from the DB and straight
    into the spreadsheet

    Sam

    Dayron <com> wrote in message news:<phx.gbl>... 
    Samuel Guest

Similar Threads

  1. Provider error '8007000e'
    By Dayron in forum ASP Database
    Replies: 4
    Last Post: August 25th, 02:09 PM
  2. Replies: 3
    Last Post: October 9th, 02:59 AM
  3. Scripting.FileSystemObject problems
    By PB4FUN in forum ASP
    Replies: 3
    Last Post: September 20th, 06:34 PM
  4. Scripting.FileSystemObject
    By Giorgio Cervati in forum ASP Components
    Replies: 1
    Last Post: September 3rd, 02:01 PM
  5. Provider error '8007000e' - Not enough storage ...
    By Claudio Ledermann in forum ASP
    Replies: 7
    Last Post: August 22nd, 07:19 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