469,275 Members | 1,497 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

Using Global.asa

1
Hello,

I am developing a website with an MS-Access backend database.

One of the tables in the database is tblUser.

On accessing my website, a user is required to provide a valid user id and a password. Once a user id and password is provided, it is validated against appropriate fields in tblUser and a "logged in" flag (another field in tblUser) is set to "True".

I want to set the flag to "False" at the end of the session. Session can end in two ways - (1) Formal Log off from the website (whose coding is very easy). (2) File - Close closing the browser or even "X"ing it to close the window - this is the coding that is challenging me.

I have created a global.asa file which is giving me problems in the Session_OnEnd subroutine. In the Application_OnStart I specify the connect string correctly because the subsequent pages in the site work nicely using the connect string.

However the connect string as determined in the Session_OnEnd bombs!

Would anyone have a sample of a global.asa which they have used and which they know has been working? I would especially like the Application_OnStart and the Session_OnEnd subroutines - as is state if it does not violate any copyright or reveals any sensitive information.

Thanks in advance.

Uttam

PS: I have been trying to get a solution to this problem for quite a while now, I have posted this question on numerous forums but have not found a valid answer - hopefully I will get a good answer here. Yes. I have spent a lot of time and my Boss is now after me to get a solution.
Jul 28 '06 #1
1 2108
Hello,

I am developing a website with an MS-Access backend database.

One of the tables in the database is tblUser.

On accessing my website, a user is required to provide a valid user id and a password. Once a user id and password is provided, it is validated against appropriate fields in tblUser and a "logged in" flag (another field in tblUser) is set to "True".

I want to set the flag to "False" at the end of the session. Session can end in two ways - (1) Formal Log off from the website (whose coding is very easy). (2) File - Close closing the browser or even "X"ing it to close the window - this is the coding that is challenging me.

I have created a global.asa file which is giving me problems in the Session_OnEnd subroutine. In the Application_OnStart I specify the connect string correctly because the subsequent pages in the site work nicely using the connect string.

However the connect string as determined in the Session_OnEnd bombs!

Would anyone have a sample of a global.asa which they have used and which they know has been working? I would especially like the Application_OnStart and the Session_OnEnd subroutines - as is state if it does not violate any copyright or reveals any sensitive information.

Thanks in advance.

Uttam

PS: I have been trying to get a solution to this problem for quite a while now, I have posted this question on numerous forums but have not found a valid answer - hopefully I will get a good answer here. Yes. I have spent a lot of time and my Boss is now after me to get a solution.
hi,

i dont know correctly ans... but may be u can use connect string in another page and include in ur pages.
Jul 31 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

28 posts views Thread by Daniel | last post: by
9 posts views Thread by Charley Kyd | last post: by
4 posts views Thread by Japhy | last post: by
12 posts views Thread by Luther Hert | last post: by
12 posts views Thread by John M | last post: by
1 post views Thread by Anonieko | last post: by
4 posts views Thread by Al Santino | last post: by
8 posts views Thread by Victor | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.