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. 7 2121
> 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" <Ja**@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.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 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.
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: 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" <Ja**@discussions.microsoft.com> wrote in message news:0F**********************************@microsof t.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 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.
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" <Ja**@discussions.microsoft.com> wrote in message
news:FE**********************************@microsof t.com... 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:
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" <Ja**@discussions.microsoft.com> wrote in message news:0F**********************************@microsof t.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 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.
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: 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" <Ja**@discussions.microsoft.com> wrote in message news:FE**********************************@microsof t.com... 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:
> 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" <Ja**@discussions.microsoft.com> wrote in message news:0F**********************************@microsof t.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 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.
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" <Ja**@discussions.microsoft.com> wrote in message
news:A5**********************************@microsof t.com... 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:
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" <Ja**@discussions.microsoft.com> wrote in message news:FE**********************************@microsof t.com... 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:
> > 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" <Ja**@discussions.microsoft.com> wrote in message > news:0F**********************************@microsof t.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
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. > > >
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" <Ja**@discussions.microsoft.com> skrev i meddelandet
news:0F**********************************@microsof t.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 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.
Thanks for the explanation Steven. I appreciate it. Regards
"Steven Burn" wrote: 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" <Ja**@discussions.microsoft.com> wrote in message news:A5**********************************@microsof t.com... 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:
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" <Ja**@discussions.microsoft.com> wrote in message news:FE**********************************@microsof t.com... > 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: > > > > 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" <Ja**@discussions.microsoft.com> wrote in message > > news:0F**********************************@microsof t.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 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. > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Roman |
last post by:
Hi,
I've installed .net on my server and since then I'm loosing my
sessions from my (old) asp.
e.g.: Session("test") works on the same page, but if the page is
changed the whole session is...
|
by: Mikko Penkkimäki |
last post by:
Hi
Looks like I can not change Web page's timeout setting. In practise it's all
the time 20 minutes - no matter what I do.
I have this kind of setting in web.config:
<sessionState...
|
by: Vishal |
last post by:
Hello,
can anybody tell me how I can extend the session
expiry time? Is it done via code or via IIS? Sorry I am
new and dont know about this.
|
by: jensen bredal |
last post by:
Hello,
i'm struggling with a somehow badly understood session scenario.
I provide acces to my pages based on form authentication using
Session cookies.
Som of my pages are supposed to be...
|
by: Rajesh.jain25 |
last post by:
Hi,
I am facing a problem of automatic session timeout problem and
automatic session_end event fired.
Case1: As I have analyzed I get to know that the default session
timeout is 20 in...
|
by: ABC |
last post by:
How to automatic redirect if session timeout using ASP.NET 1.1?
|
by: UJ |
last post by:
I have a page where the user can upload a video file. As you can guess, this
may take a while. Is there a way I can change the session timeout for just
this one page? I would also want to change...
|
by: metsie |
last post by:
Hi all,
How can I set the session TimeOut from inside the Code? Also is there a
way to make the session variables Expires after a number of minutes of
inactivity. i.e. I want to make the session...
|
by: thig95 |
last post by:
Hi,
I've got a web application written in ASP class with VBScript. We have a home grown conctact management system for my company that our users stay active in throughout the day. My problem lies...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |