What to use INSTEAD of SESSION_OnEnd

Results 1 to 2 of 2

Thread: What to use INSTEAD of SESSION_OnEnd

  1. #1
    Join Date
    Dec 1969

    Default What to use INSTEAD of SESSION_OnEnd

    Hi guys,<BR>the session_onEnd statement doesn´t work reliabel, I know, but what to use instad for this problem Without using session.abandon ?<BR>Thanx Michael<BR>----- Part of global.asa------<BR>Sub Session_OnEnd <BR>Dim sConnString<BR>set Verbindung = Server.CreateObject("ADODB.Connection")<BR>sConnSt ring = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ <BR> "DBQ=" & Server.MapPath("skillsland.mdb") & ";"<BR>Verbindung.Open(sConnString)<BR>Dim sSessionID<BR>sSessionID = Session.SessionID<BR>Verbindung.Execute ("DELETE * FROM Status WHERE SessionID = &#039;" & sSessionID & "&#039;")<BR>Verbindung.Close<BR>Set Verbindung = Nothing<BR>End Sub

  2. #2
    Join Date
    Dec 1969

    Default Geez...

    Session.Abandon is a method that will trigger Session_OnEnd.<BR>There is no sure fire way in IIS to automatically react to a session ending without the user&#039;s involvement. <BR><BR>You can use the code you have above with the understanding that some of the session records won&#039;t get deleted. You&#039;ll have to run some sort of scheduled job to delete records you know to have timed out.

Posting Permissions

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