Results 1 to 3 of 3

Thread: Asp 0113

  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: ASP 0113 error

    Hi,

    I need some help please, I have set up a test MySQL dbase on my hosted webspace, the web server is running Linux and Chiliasp. The test ASP script I am trying to run is :

    <%
    on error resume next
    dim adoConn
    dim adoRS
    dim counter
    set adoConn = Server.CreateObject("ADODB.Connection")
    set adoRS = Server.CreateObject("ADODB.Recordset")
    adoConn.Open "Driver={mySQL}; Server=localhost; Database=dbscratch3db; Uid=dbscratch3; Pwd=wentworth;"
    adoRS.ActiveConnection = adoConn
    if adoConn.errors.count = 0 then
    response.write "<h2>Fields In The 'tblscores' Table:</h2>"
    adoRS.Open "describe tblscores"
    while not adoRS.EOF
    response.write adoRS.fields(0).value & "<br>"
    adoRS.MoveNext
    wend
    else
    response.write "ERROR: Couldn't connect to database"
    end if
    %>

    THis script works fine on my local setup of W2K, IIS and MySQL however when I run it on my hosted web space I get this error :

    Active Server Pages error 'ASP 0113'
    Script timed out
    /asp10/testcon.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 ASP administration tools.

    Could anyone help please.

    Thanks

    Les
    Last edited by rdlbooth; 07-22-03 at 08:26.

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    at the top of your asp page put

    Server.ScriptTimeOut = 3600

  3. #3
    Join Date
    Jul 2003
    Posts
    2
    Thanks for the info,
    But putting Server.ScriptTimeOut = 3600 at the top of the script doesnt fix the problem.

    Les

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •