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

    Post 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
    Sussex, England
    Posts
    404

    Jet 4.0 timing out in asp

    Funny thing I had to take instructions like

    oConn.close
    set oConn = nothing

    off my Brinkster pages, because they kept crashing the code!


Posting Permissions

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