Connecting Tech Pros Worldwide Help | Site Map

Problem with automatic session timeout

Jack
Guest
 
Posts: n/a
#1: Jul 22 '05
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.
Steven Burn
Guest
 
Posts: n/a
#2: Jul 22 '05

re: Problem with automatic session timeout


> 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" <Jack@discussions.microsoft.com> wrote in message
news:0F82099C-666D-41C1-BC0E-F4CD3582DB74@microsoft.com...[color=blue]
> 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[/color]
now),[color=blue]
> 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)[/color]
in[color=blue]
> 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[/color]
above[color=blue]
> error which means after sometime, the login screen will appear instead.[/color]
Does[color=blue]
> the custom timeout override the server default timeout? Any help is
> appreciated. Thanks
> Regards.[/color]


Jack
Guest
 
Posts: n/a
#3: Jul 22 '05

re: Problem with automatic session timeout


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" wrote:
[color=blue][color=green]
> > Does the custom timeout override the server default timeout?[/color]
>
> 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" <Jack@discussions.microsoft.com> wrote in message
> news:0F82099C-666D-41C1-BC0E-F4CD3582DB74@microsoft.com...[color=green]
> > 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[/color]
> now),[color=green]
> > 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)[/color]
> in[color=green]
> > 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[/color]
> above[color=green]
> > error which means after sometime, the login screen will appear instead.[/color]
> Does[color=green]
> > the custom timeout override the server default timeout? Any help is
> > appreciated. Thanks
> > Regards.[/color]
>
>
>[/color]
Steven Burn
Guest
 
Posts: n/a
#4: Jul 22 '05

re: Problem with automatic session timeout


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" <Jack@discussions.microsoft.com> wrote in message
news:FE5F1FA8-E01F-4C72-A010-36663AB6215A@microsoft.com...[color=blue]
> 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[/color]
action,[color=blue]
> after reloading a new record, I am waiting for more than one minute. Still[/color]
I[color=blue]
> do not see the page redirected to the login screen as shown in the code.[/color]
Any[color=blue]
> 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" wrote:
>[color=green][color=darkred]
> > > Does the custom timeout override the server default timeout?[/color]
> >
> > Alledgedly..... but in my experience, it's not very reliable.
> >
> > How about using the meta refresh tag to auto-redirect to the "logout"[/color][/color]
action[color=blue][color=green]
> > after for example, 15 mins? (AFAIK, the default timeout for most servers[/color][/color]
is[color=blue][color=green]
> > 20 mins).
> >
> > --
> >
> > Regards
> >
> > Steven Burn
> > Ur I.T. Mate Group
> > www.it-mate.co.uk
> >
> > Keeping it FREE!
> >
> > "Jack" <Jack@discussions.microsoft.com> wrote in message
> > news:0F82099C-666D-41C1-BC0E-F4CD3582DB74@microsoft.com...[color=darkred]
> > > 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.[/color][/color][/color]
Everything[color=blue][color=green][color=darkred]
> > > works fine. However, if this screen is kept idle (not sure for how[/color][/color][/color]
long[color=blue][color=green]
> > now),[color=darkred]
> > > 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[/color][/color][/color]
operator)[color=blue][color=green]
> > in[color=darkred]
> > > query expression 'SubgrantIntID ='.
> > > /gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32
> > >
> > > In this situation, I have to relogin again to do edits to this form[/color][/color][/color]
for a[color=blue][color=green][color=darkred]
> > > 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[/color]
> > above[color=darkred]
> > > error which means after sometime, the login screen will appear[/color][/color][/color]
instead.[color=blue][color=green]
> > Does[color=darkred]
> > > the custom timeout override the server default timeout? Any help is
> > > appreciated. Thanks
> > > Regards.[/color]
> >
> >
> >[/color][/color]


Jack
Guest
 
Posts: n/a
#5: Jul 22 '05

re: Problem with automatic session timeout


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" wrote:
[color=blue]
> 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" <Jack@discussions.microsoft.com> wrote in message
> news:FE5F1FA8-E01F-4C72-A010-36663AB6215A@microsoft.com...[color=green]
> > 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[/color]
> action,[color=green]
> > after reloading a new record, I am waiting for more than one minute. Still[/color]
> I[color=green]
> > do not see the page redirected to the login screen as shown in the code.[/color]
> Any[color=green]
> > 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" wrote:
> >[color=darkred]
> > > > 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"[/color][/color]
> action[color=green][color=darkred]
> > > after for example, 15 mins? (AFAIK, the default timeout for most servers[/color][/color]
> is[color=green][color=darkred]
> > > 20 mins).
> > >
> > > --
> > >
> > > Regards
> > >
> > > Steven Burn
> > > Ur I.T. Mate Group
> > > www.it-mate.co.uk
> > >
> > > Keeping it FREE!
> > >
> > > "Jack" <Jack@discussions.microsoft.com> wrote in message
> > > news:0F82099C-666D-41C1-BC0E-F4CD3582DB74@microsoft.com...
> > > > 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.[/color][/color]
> Everything[color=green][color=darkred]
> > > > works fine. However, if this screen is kept idle (not sure for how[/color][/color]
> long[color=green][color=darkred]
> > > 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[/color][/color]
> operator)[color=green][color=darkred]
> > > in
> > > > query expression 'SubgrantIntID ='.
> > > > /gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32
> > > >
> > > > In this situation, I have to relogin again to do edits to this form[/color][/color]
> for a[color=green][color=darkred]
> > > > 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[/color][/color]
> instead.[color=green][color=darkred]
> > > Does
> > > > the custom timeout override the server default timeout? Any help is
> > > > appreciated. Thanks
> > > > Regards.
> > >
> > >
> > >[/color][/color]
>
>
>[/color]
Steven Burn
Guest
 
Posts: n/a
#6: Jul 22 '05

re: Problem with automatic session timeout


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" <Jack@discussions.microsoft.com> wrote in message
news:A5FA8CFC-268A-4016-B448-49B602E4C334@microsoft.com...[color=blue]
> Thanks Steven for your help again. I have a quick question. With the[/color]
syntax[color=blue]
> 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"
>[/color]
content="10;url=http://localhost/gwisbrandnewready2/default.asp?logout=true"[color=blue]
>
> Please let me know. Regards.
>
>
> "Steven Burn" wrote:
>[color=green]
> > 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.[/color][/color]
For[color=blue][color=green]
> > 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[/color][/color]
have[color=blue][color=green]
> > one).
> >
> > --
> >
> > Regards
> >
> > Steven Burn
> > Ur I.T. Mate Group
> > www.it-mate.co.uk
> >
> > Keeping it FREE!
> >
> > "Jack" <Jack@discussions.microsoft.com> wrote in message
> > news:FE5F1FA8-E01F-4C72-A010-36663AB6215A@microsoft.com...[color=darkred]
> > > Thanks for your reply Steven. I just wrote the meta tag to my page and[/color][/color][/color]
am[color=blue][color=green][color=darkred]
> > > giving 10 secs to be redirected to the login page. However, with this[/color]
> > action,[color=darkred]
> > > after reloading a new record, I am waiting for more than one minute.[/color][/color][/color]
Still[color=blue][color=green]
> > I[color=darkred]
> > > do not see the page redirected to the login screen as shown in the[/color][/color][/color]
code.[color=blue][color=green]
> > Any[color=darkred]
> > > idea what's going on here? I wrote the meta tag in the <head> tag of[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > page. Thanks
> > > <META http-equiv="refresh"
> > > content="10;url=http://localhost/gwisbrandnewready2/default.asp">
> > > "Steven Burn" wrote:
> > >
> > > > > 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[/color][/color][/color]
"logout"[color=blue][color=green]
> > action[color=darkred]
> > > > after for example, 15 mins? (AFAIK, the default timeout for most[/color][/color][/color]
servers[color=blue][color=green]
> > is[color=darkred]
> > > > 20 mins).
> > > >
> > > > --
> > > >
> > > > Regards
> > > >
> > > > Steven Burn
> > > > Ur I.T. Mate Group
> > > > www.it-mate.co.uk
> > > >
> > > > Keeping it FREE!
> > > >
> > > > "Jack" <Jack@discussions.microsoft.com> wrote in message
> > > > news:0F82099C-666D-41C1-BC0E-F4CD3582DB74@microsoft.com...
> > > > > 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.[/color]
> > Everything[color=darkred]
> > > > > works fine. However, if this screen is kept idle (not sure for how[/color]
> > long[color=darkred]
> > > > 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[/color]
> > operator)[color=darkred]
> > > > in
> > > > > query expression 'SubgrantIntID ='.
> > > > > /gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32
> > > > >
> > > > > In this situation, I have to relogin again to do edits to this[/color][/color][/color]
form[color=blue][color=green]
> > for a[color=darkred]
> > > > > 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[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > > above
> > > > > error which means after sometime, the login screen will appear[/color]
> > instead.[color=darkred]
> > > > Does
> > > > > the custom timeout override the server default timeout? Any help[/color][/color][/color]
is[color=blue][color=green][color=darkred]
> > > > > appreciated. Thanks
> > > > > Regards.
> > > >
> > > >
> > > >[/color]
> >
> >
> >[/color][/color]


Sven Pernils
Guest
 
Posts: n/a
#7: Jul 22 '05

re: Problem with automatic session timeout


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

"Jack" <Jack@discussions.microsoft.com> skrev i meddelandet
news:0F82099C-666D-41C1-BC0E-F4CD3582DB74@microsoft.com...[color=blue]
> 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.[/color]


Jack
Guest
 
Posts: n/a
#8: Jul 22 '05

re: Problem with automatic session timeout


Thanks for the explanation Steven. I appreciate it. Regards

"Steven Burn" wrote:
[color=blue]
> 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" <Jack@discussions.microsoft.com> wrote in message
> news:A5FA8CFC-268A-4016-B448-49B602E4C334@microsoft.com...[color=green]
> > Thanks Steven for your help again. I have a quick question. With the[/color]
> syntax[color=green]
> > 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"
> >[/color]
> content="10;url=http://localhost/gwisbrandnewready2/default.asp?logout=true"[color=green]
> >
> > Please let me know. Regards.
> >
> >
> > "Steven Burn" wrote:
> >[color=darkred]
> > > 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.[/color][/color]
> For[color=green][color=darkred]
> > > 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[/color][/color]
> have[color=green][color=darkred]
> > > one).
> > >
> > > --
> > >
> > > Regards
> > >
> > > Steven Burn
> > > Ur I.T. Mate Group
> > > www.it-mate.co.uk
> > >
> > > Keeping it FREE!
> > >
> > > "Jack" <Jack@discussions.microsoft.com> wrote in message
> > > news:FE5F1FA8-E01F-4C72-A010-36663AB6215A@microsoft.com...
> > > > Thanks for your reply Steven. I just wrote the meta tag to my page and[/color][/color]
> am[color=green][color=darkred]
> > > > 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.[/color][/color]
> Still[color=green][color=darkred]
> > > I
> > > > do not see the page redirected to the login screen as shown in the[/color][/color]
> code.[color=green][color=darkred]
> > > Any
> > > > idea what's going on here? I wrote the meta tag in the <head> tag of[/color][/color]
> the[color=green][color=darkred]
> > > > page. Thanks
> > > > <META http-equiv="refresh"
> > > > content="10;url=http://localhost/gwisbrandnewready2/default.asp">
> > > > "Steven Burn" wrote:
> > > >
> > > > > > 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[/color][/color]
> "logout"[color=green][color=darkred]
> > > action
> > > > > after for example, 15 mins? (AFAIK, the default timeout for most[/color][/color]
> servers[color=green][color=darkred]
> > > is
> > > > > 20 mins).
> > > > >
> > > > > --
> > > > >
> > > > > Regards
> > > > >
> > > > > Steven Burn
> > > > > Ur I.T. Mate Group
> > > > > www.it-mate.co.uk
> > > > >
> > > > > Keeping it FREE!
> > > > >
> > > > > "Jack" <Jack@discussions.microsoft.com> wrote in message
> > > > > news:0F82099C-666D-41C1-BC0E-F4CD3582DB74@microsoft.com...
> > > > > > 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[/color][/color]
> form[color=green][color=darkred]
> > > 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[/color][/color]
> the[color=green][color=darkred]
> > > > > above
> > > > > > error which means after sometime, the login screen will appear
> > > instead.
> > > > > Does
> > > > > > the custom timeout override the server default timeout? Any help[/color][/color]
> is[color=green][color=darkred]
> > > > > > appreciated. Thanks
> > > > > > Regards.
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >[/color][/color]
>
>
>[/color]
Closed Thread