Results 1 to 9 of 9

Thread: Timeout expired

  1. #1
    Join Date
    Jan 2003
    Posts
    30

    Unanswered: Timeout expired

    Hello guys!

    I am getting the following error on my website:

    Number: Microsoft OLE DB Provider for SQL Server
    (0x80004005)
    Timeout expired


    This error occuring in the update SQL command.

    What to do to avoid/fix this error?

    Thanks for any help.

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    this is likely because your update script is taking too long?

  3. #3
    Join Date
    Apr 2002
    Posts
    20

    Re: Timeout expired

    If you are running a really long task it possibly is taking a longer time than the default timeout for the query or connection. However if you are updating a row something else is wrong and we need more details.

    --jfp

  4. #4
    Join Date
    Jan 2003
    Location
    London, England
    Posts
    106
    This definetly sounds like an ASP/VB-application and if this is the case then setting the Server.ScriptTimeout might do you some good.

    ASP:
    <%
    Server.ScriptTimeout = 3000 ' -> seconds that is
    Set Conn = Server.CreateObject("ADODB.Connetion")
    Conn.Open Connectionstring
    Conn.Execute("myUpdateStatement")
    Conn.Close
    Set Conn = nothing
    %>
    Frettmaestro
    "Real programmers don't document, if it was hard to write it should be hard to understand!"

  5. #5
    Join Date
    Jan 2003
    Location
    London, England
    Posts
    106
    ...there might also be numerous ways to optimize your query...post it and we can take a look at it...
    Frettmaestro
    "Real programmers don't document, if it was hard to write it should be hard to understand!"

  6. #6
    Join Date
    Jan 2003
    Posts
    30
    Yes, this is an ASP/VB-application but the error is "Microsoft OLE DB Provider for SQL Server" and not "Script timeout"

    I fix the problem changing the recordset by SQL direct input

    "Insert Into MENSAGEM Values..."

    Thanks guys...


    BTW, where I found help for IIS?

  7. #7
    Join Date
    Apr 2002
    Posts
    20
    Try finding help here. (IIS is part of the OS install)

    http://www.microsoft.com/windows2000/en/server/iis/

    --jfp

  8. #8
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    How many rows were updated (raw estimate) ?

  9. #9
    Join Date
    Jan 2003
    Posts
    30
    It was a Insert.

    The problem is that this table receive a lot of insert.. and the size of the fields are big (a text field)...

    But now the problem was fixed doind INSERT direct into SQL..

Posting Permissions

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