sub Application_OnStart

Application("conn")="dsn=;uid=;pwd="

end sub

Sub session_onstart

session("ip")=Request.ServerVariables("REMOTE_ADDR")
session("stime")=now()

application.Lock
if application("clicks")="" then
application("clicks")=0
end if
application("clicks")=application("clicks")+1

application.UnLock

End Sub

Sub Session_Onend

application.Lock

StrSQL="dsn=;uid=;pwd="
set conn=server.createobject("ADODB.CONNECTION")
conn.open StrSQL

SQL = "insert into client(c_date,stime,etime,ip) values('"&date()&"','"&session("stime")&"','"&now()&"','"&session("ip")&"')"

conn.Execute(sql)

conn.Close
set conn=nothing

application.UnLock

End Sub