MS access+asp accessing database problem

Discussion in 'Classic ASP' started by jiahan, Mar 11, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. My Website use MS ACCESS. It can connect database successfully ,but timed out when execute SQL, so the error message on the page is as follows:


    Active Server Pages error 'ASP 0113'


    Script timed out


    /sold.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.


    The Application is developed on the MS WINDOWSXP(Chinese), Access(Chinese),There is no problem when I tested it on my local computer. But it doesn't work on the space of "discountasp". Could you please help me to solve this problem?


    Thanks a lot!
     
  2. Aha


    This happend to me many times


    it occurs when I try to excute an endless script


    such as this


    dim Rs as recorset


    Rs.open "Select * from MyTable where MyColumn='Mycriteria' "


    Do while not Rs.oef


    reqest.write("Col1")


    Loop





    thisis an endless loop becasue i forgot to add


    Rs.movenext


    the correct script is:


    Rs.open "Select * from MyTable where MyColumn='Mycriteria' "


    Do while not Rs.oef


    reqest.write("Col1")


    Rs.movenext


    Loop


    Check your script for endless subs or functions


    Also check the variables names, some times your script loops while checking for a change in a variable , but the variable name is incorrect, so it stays unchanged..


    try to use


    <% option explicit %>





    hope I could help!
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page