2. ASPRunnerPro General questions
  3. Exporting Data over 800 records
This topic is locked

Exporting Data over 800 records

 		8/22/2005 6:03:56 PM
ASPRunnerPro General questions
Alberto author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1756&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' /> Hello Sergey,
I have a problem exporting records to any format when it goes over 800 rows.
I get the same error every time I try to export when certain number of records are involved. I spent the time testing one of them and the maximum number of records was 800. I do not think is data problem because I exported all rows in groups below or equal to 799 records.
This is critical due to a hight need of exporting data.
Working with SQL Server 2000/MS Windows 2003
Sergey Kornilov admin 8/23/2005

Alberto,
could you send me an URL where I can see this error?
Otherwise please zip and send to support@xlinesoft.com all files from ASPRunnerPro output folder with subfolders along with project file and your sample database. I'll find what's wrong running it on my test box.
Alberto author 8/23/2005

Sergey:
I just sent you by e-mail 2 url for your tests regarding this errors.
Thanks for your help
Alberto author 8/28/2005

I applied the fixing you recommended (response.flush) for the _export.asp file and apparently solved the problem. We do not get the same error anymore, but, we are now experiencing another situation. We now get the excel file with some data but not all records.
At the beginning of the file we are getting a message like this: (please check attachement, I got about 1000 records)
Active Server Pages error 'ASP 0113'
Script timed out
/prod/Nivel1/tbAgendamientos_export.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
I changed the value of Server.ScriptTimeout from 120 to 360 but did not work. In one of my tests it took a very long time to finally show the same error.
Sergey Kornilov admin 8/29/2005

Alberto,
answered to your personal email.