don't do that The suggestions I gave will eliminate need for that.
If you do that you have to do http://learnasp.com/learn/isclientconnected.asp to reduce odds of orphaned RS and Connections. Any DB operation or query or Sproc that takes an hour needs to be done differently. People have showed me 20 hour queries and I showed them how to cut thmem donw to 10 minutes etc. Show me any 1 hour DB operation -- I will show you how to get it down to minutes or seconds. On Thu, 24 Feb 2005 17:16:37 +0800, GJ <[EMAIL PROTECTED]> wrote: > Or if you have a large database, you can set your server.scriptTimeout > to 1 hour or more. > > > 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. > > > > peace & thanks i advance > > Nick > > > > > > > > > > > > > > > > Yahoo! Groups Sponsor > > ADVERTISEMENT > > > > ________________________________ > > 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 the Yahoo! Terms of Service. > > > > Yahoo! Groups Sponsor > > ADVERTISEMENT > > > ________________________________ > 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 the Yahoo! Terms of Service. 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/
