I need to update a database table with the time the user logs out of my site/when their session ends.
I've been using a global.asa file with the following Session_OnEnd code, but it doesnt seem to be working for me........ can anybody help?

<script language=vbscript runat=server>
Sub Session_OnEnd
set conn = Server.CreateObject("ADODB.Connection"
conn.Open "DSN=....."

query = "UPDATE User_LogTime SET Logout_Time = "now()" WHERE SID="&Session.SessionID&"

conn.Execute(query)
conn.Close
set conn = Nothing
End Sub
</script>