Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    8

    Question Unanswered: How do I get rid of this problem?

    Hi, I did a web page for the intranet where I work using ASP and a database in SQL Server, the connection line is the following:
    Set oConn=Server.CreateObject("ADODB.Connection")
    oConn.Open "Provider=sqloledb;Server=zapopan02;database=data; User Id=sa"
    The problem comes the first time I try to establish the connection after 5 min. (aprox) of inactivity.
    I get the following error:
    Microsoft OLE DB Provider for SQL Server error '80004005'
    Timeout expired
    Then, I refresh the page and it works fine (and keeps working until I stop using the page for a while)
    Could someone pleaseee tell me how to get rid of this problem?
    Thank in advance
    -Richard

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    extend the timeout- probably the session one...
    Code:
    session.Timeout time in minutes

Posting Permissions

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