Global.asa problem...

[TPetersonFlorida]

I have in my global.asa file a function that fires off when someones session ends. It was working but has now quit working. I dont see anything wrong with the function. Is there something that i dont know about the global.asa file such as it being inconsistent? any ideas?? please help!

thanks in advance.

 

[onpnt]

what is the function doing? could you post it so we can get a better idea of what is going on.

_____________________________________________________________________

_{Hakuna matata!!}

 

[TPetersonFlorida]

Here is the contents of my global.asa file:



<script language=&quot;vbscript&quot; runat=&quot;server&quot;>

sub Session_OnStart
end sub

sub Session_OnEnd

Set myConn = Server.CreateObject(&quot;ADODB.Connection&quot
myConn.Provider = &quot;Microsoft.Jet.OLEDB.4.0&quot;
myConn.Open = Server.MapPath(&quot;data\SS.mdb&quot

strSQL = &quot;DELETE MembersOnline.UserID FROM MembersOnline &quot; _
& &quot;WHERE (((MembersOnline.UserID)=&quot; & session(&quot;varUser&quot & &quot);&quot;
myConn.Execute(strSQL)

strSQL = &quot;UPDATE Members SET Members.LastOnline = Now() &quot; _
& &quot;WHERE (((Members.UserID)=&quot; & session(&quot;varUser&quot & &quot);&quot;
myConn.Execute(strSQL)

myConn.close
Set myConn = nothing
end sub


</script>