Is it possible when catching the Session_OnEnd to open
a connection to a database and perform a SQL query? I
have my Session_OnEnd and its associated code block in
my global.asa, I have restarted IIS but the code does
not seem to be executed. Any ideas?

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

hi,

   you can access database during the event
'Session_OnEnd'. But it is fired when you explicitily
abondon the session by using 'session.abondon' method
or when the session is timed out. I think you know
that the default timeout period for session is 20
minutes. If the user is idle
without accessing any page until 20 minutes, the
session will be timed out and 'Session_OnEnd' event
will be fired.
I wrote under 'Session_OnEnd' event like the
following.

   set con=server.createobject("ADODB.connection")
   con.mode=admodereadwrite
   con.open "hiran"     'dsn name
   con.execute "insert into item
values('hiransatya','hiransatya')"

The above code is worked well.There is no need to
restart your IIS or PWS.

I think, this may help you.

regards,
hiransatya
   




--- "Laeg Ent." <laeg_enterprises@y...> wrote:
> 
> Is it possible when catching the Session_OnEnd to
> open
> a connection to a database and perform a SQL query?
> I
> have my Session_OnEnd and its associated code block
> in
> my global.asa, I have restarted IIS but the code
> does
> not seem to be executed. Any ideas?
> 
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/