Session_OnEnd blues

Results 1 to 3 of 3

Thread: Session_OnEnd blues

  1. #1
    Join Date
    Dec 1969

    Default Session_OnEnd blues

    Can someone help me? I&#039;m trying to write to an access database in the Session_OnEnd event. If I put the following code in the Session_onStart event, it works fine. If I put it in the Session_onEnd event, it seems that line 4 (application("db").open "thudb") won&#039;t run. I have upgraded my MDAC to 2.71 and still no connection.<BR><BR>Any suggestions would be &#039;greatly&#039; appreciated.<BR><BR>Application("test2") = "start"<BR>set application("db") = Server.CreateObject("ADODB.Connection")<BR>applica tion("source") = "INSERT INTO User_LogTime (user_id, SID) VALUES (222,"&session.sessionid&")"<BR>application("db"). open "thudb"<BR>Application("test2") = "finished"<BR>application("db").execute application("source")<BR>application("db").close<B R>set application("db")=nothing

  2. #2
    Join Date
    Dec 1969

    Default RE: Session_OnEnd blues

    Session_OnEnd is buggy. Period. Especially with ADO it seems. More people seem to have problems writing to a DB in the OnEnd event handler than anything else. It really sucks, and I wish M$FT would get off their lazy asses and fix it. I mean, it&#039;s been around for quite a few versions, now. I wonder if ASP.NET experiences the same thing with whatever implementation it has for it (I&#039;m not a .NET&#039;er).<BR><BR>So, it&#039;s buggy, and that&#039;s why you&#039;re having problems. Unfortunately, there is no fix until M$FT gives us one.<BR><BR>~~Chaotix

  3. #3
    Join Date
    Dec 1969

    Default ASP.NET is better

    Check out the details and a work around solution that works really well for one of our production sites.<BR><BR>

Posting Permissions

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