Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Sprint World Campus
    Posts
    7

    Unanswered: Jet 4.0 timing out in ASP

    I am using MS Access 2002 as my backend database, and an ASP application as my frontend.

    Here is my ADODB connection string:

    dim oConn
    set oConn = Server.CreateObject("adodb.connection")
    oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=c:/inetpub/wwwroot/_database/nsc.mdb;"

    at the end of each page, I have this:

    oConn.close
    set oConn = nothing

    Everything will work fine for awhile, and then asp requests to the database (update, select, insert, etc.) all time out - and takes about 10 minutes before everything clears up. HTML pages without ASP code still work fine - but the ASP coded pages stop working. I can either wait for it to clear itself out, or I can restart IIS and it clears itself out. And then happens in about 30min to an hour or so.

    The fact that ASP code works for awhile tells me my code is fine. I have applied the latest patches for Jet, to no avail.


    Thanks in advance,
    -Jeremy

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Hmmm, that is a little strange... I assume you are closing and setting your recordsets to nothing as well as your connection objects.....

Posting Permissions

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