Problem with automatic session timeout

J

Jack

Hi,
In my application, the main page is accessed via a login screen. A
particular record is accessed based on the value of login page. Everything
works fine. However, if this screen is kept idle (not sure for how long now),
and then if I try to save, the following error message comes up:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'SubgrantIntID ='.
/gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32

In this situation, I have to relogin again to do edits to this form for a
particular record and save.
Now my question is: Is there any way to code to get one logged out
automatically after sometime, so that, I do not have to encounter the above
error which means after sometime, the login screen will appear instead. Does
the custom timeout override the server default timeout? Any help is
appreciated. Thanks
Regards.
 
S

Steven Burn

Does the custom timeout override the server default timeout?

Alledgedly..... but in my experience, it's not very reliable.

How about using the meta refresh tag to auto-redirect to the "logout" action
after for example, 15 mins? (AFAIK, the default timeout for most servers is
20 mins).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
 
J

Jack

Thanks for your reply Steven. I just wrote the meta tag to my page and am
giving 10 secs to be redirected to the login page. However, with this action,
after reloading a new record, I am waiting for more than one minute. Still I
do not see the page redirected to the login screen as shown in the code. Any
idea what's going on here? I wrote the meta tag in the <head> tag of the
page. Thanks
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp">
Steven Burn said:
Does the custom timeout override the server default timeout?

Alledgedly..... but in my experience, it's not very reliable.

How about using the meta refresh tag to auto-redirect to the "logout" action
after for example, 15 mins? (AFAIK, the default timeout for most servers is
20 mins).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Jack said:
Hi,
In my application, the main page is accessed via a login screen. A
particular record is accessed based on the value of login page. Everything
works fine. However, if this screen is kept idle (not sure for how long now),
and then if I try to save, the following error message comes up:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'SubgrantIntID ='.
/gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32

In this situation, I have to relogin again to do edits to this form for a
particular record and save.
Now my question is: Is there any way to code to get one logged out
automatically after sometime, so that, I do not have to encounter the above
error which means after sometime, the login screen will appear instead. Does
the custom timeout override the server default timeout? Any help is
appreciated. Thanks
Regards.
 
S

Steven Burn

It will only re-direct to the login page if the session has ended (i.e.
you've logged out). You need to set the URL to your "logout" URL first. For
example;

<meta http-equiv="refresh"
content="10;url=http://localhost/somepage.asp?logout=true">

This will have the same effect as clicking your "Logout" link (if you have
one).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Jack said:
Thanks for your reply Steven. I just wrote the meta tag to my page and am
giving 10 secs to be redirected to the login page. However, with this action,
after reloading a new record, I am waiting for more than one minute. Still I
do not see the page redirected to the login screen as shown in the code. Any
idea what's going on here? I wrote the meta tag in the <head> tag of the
page. Thanks
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp">
Steven Burn said:
Does the custom timeout override the server default timeout?

Alledgedly..... but in my experience, it's not very reliable.

How about using the meta refresh tag to auto-redirect to the "logout" action
after for example, 15 mins? (AFAIK, the default timeout for most servers is
20 mins).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Jack said:
Hi,
In my application, the main page is accessed via a login screen. A
particular record is accessed based on the value of login page. Everything
works fine. However, if this screen is kept idle (not sure for how
long
now),
and then if I try to save, the following error message comes up:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator)
in
query expression 'SubgrantIntID ='.
/gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32

In this situation, I have to relogin again to do edits to this form for a
particular record and save.
Now my question is: Is there any way to code to get one logged out
automatically after sometime, so that, I do not have to encounter the above
error which means after sometime, the login screen will appear
instead.
Does
the custom timeout override the server default timeout? Any help is
appreciated. Thanks
Regards.
 
J

Jack

Thanks Steven for your help again. I have a quick question. With the syntax
you provided, is logout a universal code here or it depends on the logout
screen name?
In other words, should my corrected syntax be:
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp?logout=true">
Please let me know. Regards.


Steven Burn said:
It will only re-direct to the login page if the session has ended (i.e.
you've logged out). You need to set the URL to your "logout" URL first. For
example;

<meta http-equiv="refresh"
content="10;url=http://localhost/somepage.asp?logout=true">

This will have the same effect as clicking your "Logout" link (if you have
one).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Jack said:
Thanks for your reply Steven. I just wrote the meta tag to my page and am
giving 10 secs to be redirected to the login page. However, with this action,
after reloading a new record, I am waiting for more than one minute. Still I
do not see the page redirected to the login screen as shown in the code. Any
idea what's going on here? I wrote the meta tag in the <head> tag of the
page. Thanks
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp">
Steven Burn said:
Does the custom timeout override the server default timeout?

Alledgedly..... but in my experience, it's not very reliable.

How about using the meta refresh tag to auto-redirect to the "logout" action
after for example, 15 mins? (AFAIK, the default timeout for most servers is
20 mins).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Hi,
In my application, the main page is accessed via a login screen. A
particular record is accessed based on the value of login page. Everything
works fine. However, if this screen is kept idle (not sure for how long
now),
and then if I try to save, the following error message comes up:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)
in
query expression 'SubgrantIntID ='.
/gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32

In this situation, I have to relogin again to do edits to this form for a
particular record and save.
Now my question is: Is there any way to code to get one logged out
automatically after sometime, so that, I do not have to encounter the
above
error which means after sometime, the login screen will appear instead.
Does
the custom timeout override the server default timeout? Any help is
appreciated. Thanks
Regards.
 
S

Steven Burn

it depends on how your logging out.

For example, if you have a logout link that points to;

<your_server>/dir/default.asp?action=logout&user=someone

You would replace the URL in the meta tag with the above.

Hope that makes sense.

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
Jack said:
Thanks Steven for your help again. I have a quick question. With the syntax
you provided, is logout a universal code here or it depends on the logout
screen name?
In other words, should my corrected syntax be:
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp?logout=true"

Please let me know. Regards.


Steven Burn said:
It will only re-direct to the login page if the session has ended (i.e.
you've logged out). You need to set the URL to your "logout" URL first. For
example;

<meta http-equiv="refresh"
content="10;url=http://localhost/somepage.asp?logout=true">

This will have the same effect as clicking your "Logout" link (if you have
one).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Jack said:
Thanks for your reply Steven. I just wrote the meta tag to my page and am
giving 10 secs to be redirected to the login page. However, with this action,
after reloading a new record, I am waiting for more than one minute.
Still
I
do not see the page redirected to the login screen as shown in the
code.
Any
idea what's going on here? I wrote the meta tag in the <head> tag of the
page. Thanks
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp">
:

Does the custom timeout override the server default timeout?

Alledgedly..... but in my experience, it's not very reliable.

How about using the meta refresh tag to auto-redirect to the
"logout"
action
after for example, 15 mins? (AFAIK, the default timeout for most
servers
is
20 mins).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Hi,
In my application, the main page is accessed via a login screen. A
particular record is accessed based on the value of login page. Everything
works fine. However, if this screen is kept idle (not sure for how long
now),
and then if I try to save, the following error message comes up:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)
in
query expression 'SubgrantIntID ='.
/gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32

In this situation, I have to relogin again to do edits to this
form
for a
particular record and save.
Now my question is: Is there any way to code to get one logged out
automatically after sometime, so that, I do not have to encounter the
above
error which means after sometime, the login screen will appear instead.
Does
the custom timeout override the server default timeout? Any help is
appreciated. Thanks
Regards.
 
S

Sven Pernils

Wouldn't it be esier to try to remember who loggged in, without using a
session variable, as I assume you are using now, maybe with a cookie, or
passing along the ID with some action from the login page. and then store
the ID in a local variable on the main page.

Regards,
Sven
 
J

Jack

Thanks for the explanation Steven. I appreciate it. Regards

Steven Burn said:
it depends on how your logging out.

For example, if you have a logout link that points to;

<your_server>/dir/default.asp?action=logout&user=someone

You would replace the URL in the meta tag with the above.

Hope that makes sense.

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
Jack said:
Thanks Steven for your help again. I have a quick question. With the syntax
you provided, is logout a universal code here or it depends on the logout
screen name?
In other words, should my corrected syntax be:
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp?logout=true"

Please let me know. Regards.


Steven Burn said:
It will only re-direct to the login page if the session has ended (i.e.
you've logged out). You need to set the URL to your "logout" URL first. For
example;

<meta http-equiv="refresh"
content="10;url=http://localhost/somepage.asp?logout=true">

This will have the same effect as clicking your "Logout" link (if you have
one).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Thanks for your reply Steven. I just wrote the meta tag to my page and am
giving 10 secs to be redirected to the login page. However, with this
action,
after reloading a new record, I am waiting for more than one minute. Still
I
do not see the page redirected to the login screen as shown in the code.
Any
idea what's going on here? I wrote the meta tag in the <head> tag of the
page. Thanks
<META http-equiv="refresh"
content="10;url=http://localhost/gwisbrandnewready2/default.asp">
:

Does the custom timeout override the server default timeout?

Alledgedly..... but in my experience, it's not very reliable.

How about using the meta refresh tag to auto-redirect to the "logout"
action
after for example, 15 mins? (AFAIK, the default timeout for most servers
is
20 mins).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Hi,
In my application, the main page is accessed via a login screen. A
particular record is accessed based on the value of login page.
Everything
works fine. However, if this screen is kept idle (not sure for how
long
now),
and then if I try to save, the following error message comes up:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator)
in
query expression 'SubgrantIntID ='.
/gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32

In this situation, I have to relogin again to do edits to this form
for a
particular record and save.
Now my question is: Is there any way to code to get one logged out
automatically after sometime, so that, I do not have to encounter the
above
error which means after sometime, the login screen will appear
instead.
Does
the custom timeout override the server default timeout? Any help is
appreciated. Thanks
Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,161
Messages
2,570,892
Members
47,427
Latest member
HildredDic

Latest Threads

Top