http://www.learnasp.com/advice/whygetrows.asp use Getrows and Getstring on this page and EVERY busy page on your site.
Access has finite number of simultaneous connections. If it exceeds them all scripts will timeout hwen that limit is exceeded and for some time after due to orphaned connections and RS due to timed out scripts. On your bigger scripts fetching many records considering adding: http://learnasp.com/learn/isclientconnected.asp as well. This will reduce odds of orphaned RS and Connections. If you are not closing RS and connections you need to be. Review your busiest scripts. If you control the server install the counters suggested here to help get to root of cause if above does not work: Undocumented Logging Features exist in ASP http://www.15seconds.com/Issue/981015.htm On Thu, 24 Feb 2005 05:19:52 -0000, dcase14 <[EMAIL PROTECTED]> wrote: > > > Hi Everybody > > I'm trying to pull data from a table on an asp page and deposit it > into a form on another asp page. > > When I click on my 'edit' link > code is: > Response.Write "<a href=db_edit.asp?classid=" & MyClassID & > ">Edit</a>" > > Where MyClassID is the variable assigned to the classid field from the > database. > > When I test the page, it seems to be loading for a long time, and then > I get an error: > ====================== > Error Type: > Active Server Pages, ASP 0113 (0x80004005) > 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. > /nickd/factsheets/db_edit.asp > > ====================== > > If anybody is able to help, that would be great. I'm happy to provide > more info or code if needed. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
