Timeout Expired Error

Results 1 to 2 of 2

Thread: Timeout Expired Error

  1. #1
    Join Date
    Dec 1969

    Default Timeout Expired Error

    Do you know of any ways to allow the ASP page not to get the Timeout Expired error? Whenever the SQL statement would need to take more than 50 seconds to run, I would receive the Timeout error message. I have tried using the Server.ScriptTimeout property to set for a number more than 1 hour on the ASP page, but this ScriptTimeout property has no effect at all on the ASP page. I also set this ASP Script time out property in IIS, but this would not help neither. I hope you would share an answer with me if you know how to resolve the Time Out problem.

  2. #2
    Join Date
    Dec 1969

    Default RE: Timeout Expired Error

    set the timeout in your connectionobject<BR><BR>objConn.CommandTimeOut = [Value in seconds]<BR><BR>You get this error because ADO has to wait to long for an replay from the SQL Server, and not because the ASP-page itselfs takes too long to complete.

Posting Permissions

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