Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 24th, 2009, 03:58 PM
Friend of Wrox
 
Join Date: Oct 2006
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default SCRIPT TIMING OUT

Hi to all...

i have a web page that displays records from the database...
I added <% Server.ScriptTimeout = 2000 %> to my page...

but still after a while the page "The page cannot be displayed"...

I know it’s working because when I change my script to display least on screen it works…

Do you know if there something else to add or I need to change because it looks like it’s not reading the timeout…

Thx Rino
 
Old September 24th, 2009, 05:01 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Don't display so many records.

Learn to use "recordset paging". Display only 10 to 20 records per page.

Google for "asp recordset paging". Tons of examples out there. Some of them are even good ones.
 
Old September 24th, 2009, 05:18 PM
Friend of Wrox
 
Join Date: Oct 2006
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default

the reason why is that once displayed the user exports the data to excel...
so they are not going to view it in web page...
is there a way to just export it to excel instead of display it on screen then???

Thx Rino
 
Old September 24th, 2009, 07:03 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Quote:
is there a way to just export it to excel instead of display it on screen then???
Yeah, but it's about 20 or 30 times as much work and easy to mess up.

Okay, just bump up the DB connection timeout and the Script timeout. A bit ugly, but if it's not done TOO often it will be okay.





Similar Threads
Thread Thread Starter Forum Replies Last Post
timing out issue... RinoDM SQL Server 2000 1 September 24th, 2009 05:02 PM
Full Text timing out coww_pie SQL Server 2005 1 October 29th, 2007 11:47 PM
Remoting timing out after 2 minutes BrainWave ASP.NET 2.0 Professional 0 August 13th, 2007 06:54 AM
timing issue riteshu C++ Programming 2 September 22nd, 2004 07:10 AM
database timing gmoney060 BOOK: Beginning ASP 3.0 1 June 2nd, 2004 06:52 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.