global.asa problem

[duane]

I am trying to fire off a delete query against an access database when the session ends to clean up some records. The code works fine from an asp page in testing, but does not seem to work at all when the user session ends. I know for sure that the session_end event is firing because I am having it modify an application variable for trouble shooting.
Is it just not possible to run queries against access databases from the global.asa?

thanks,
duane

[bruce]

duane,

you should be able to run any code in the global.asa file.

i've seen many people posting on the internet regarding this type of issue. i don't know if this is a general problem with ASP or not.

I remember one suggestion was to not use the OnEnd function and use other scheduled script to clear the db


[b]quote:Originally posted by duane

I am trying to fire off a delete query against an access database when the session ends to clean up some records. The code works fine from an asp page in testing, but does not seem to work at all when the user session ends. I know for sure that the session_end event is firing because I am having it modify an application variable for trouble shooting.
Is it just not possible to run queries against access databases from the global.asa?

thanks,
duane
</blockquote id="quote"></font id="quote">

[duane]

Thanks Bruce

What I wanted to do was keep track of who was logged in to my site. Since I couldn't get it to work with a DB, I just wrote all the users to a single application variable and "split" them out when needed. On_end event works fine to clear that out.

You said "use other scheduled script to clear the db"...
How might that be done? I was not aware there was a scheduling tool...

dw

[bruce]

WE don't have a scheduling tool as of currently (we'll have it some time in Q4 03)

Many users have created a schedule task on their workstation to kick off a http call at prescribe time.


[b]quote:Originally posted by duane

Thanks Bruce

What I wanted to do was keep track of who was logged in to my site. Since I couldn't get it to work with a DB, I just wrote all the users to a single application variable and "split" them out when needed. On_end event works fine to clear that out.

You said "use other scheduled script to clear the db"...
How might that be done? I was not aware there was a scheduling tool...

dw
</blockquote id="quote"></font id="quote">