ASP session removed after seconds, can't find reason

oliflorence · #1 (**permalink**) 03-22-07, 05:15

Hello,
i have a site using sessions to login. The server is set up to remove sessions after 30 minutes but it seems sessions are often deleted after a few seconds or minutes and I can't figure out why.
I am using a global.asa file on this site, I am not too familiar with this and I am wondering if this could cause an error:

Code:

<SCRIPT LANGUAGE="JavaScript" RUNAT="Server">


function Session_OnStart()
{

Session.Timeout=60
}


var adoConnection = Server.CreateObject("ADODB.Connection");
adoConnection.Open("dsn=xxx;uid=xxx;pwd=xxxxx;");
function Session_OnEnd()
{


var removeL = "DELETE FROM tbllogged WHERE sesId = '"+String(Session.SessionID)+"'";
adoConnection.Execute(removeL)



}

function Application_OnStart()
{
//clear the logged table when the server restarts
var clearL = "DELETE FROM tbllogged";
adoConnection.Execute(clearL);

}



</script>

Or else what should I look out for, I just can't figure out why those sessions would be removed?

many thanks

gvee · #2 (**permalink**) 03-22-07, 06:54

Is the session timeout in seconds or in minutes?
I advise you look that up and post the answer in this thread

oliflorence · #3 (**permalink**) 03-22-07, 08:18

Hi there,
isn't this always in minutes?

Ref; http://www.w3schools.com/asp/prop_timeout.asp

It is the Script.TimeOut that is in seconds.

Kind regards,

gvee · #4 (**permalink**) 03-22-07, 08:21

It depends on the IIS/host settings. If you remove your timeout line, how does the application fair? default timeout is 20minutes.

Your {}'s in the OnStart are a bit funny too..

gvee · #5 (**permalink**) 03-22-07, 08:22

Not function - SUB!
I think
:. no parens too

oliflorence · #6 (**permalink**) 03-27-07, 10:19

Hello,
by removing the global.asa file the problem is defninitly gone so I am quiet sure the problem is coming from this.
I have removed the
function Session_OnStart()
{

Session.Timeout=60
}
all together since the default is 20 minutes any way but the problem is now back, any idea what could be changed on this:
PS: the {} are there because it is in ASP JS.

Code:

<SCRIPT LANGUAGE="JavaScript" RUNAT="Server">





var adoConnection = Server.CreateObject("ADODB.Connection");
adoConnection.Open("dsn=xxxx;uid=xxxx;pwd=xxxxx;");
function Session_OnEnd()
{


var removeL = "DELETE FROM tbllogged WHERE sesId = '"+String(Session.SessionID)+"'";
adoConnection.Execute(removeL)



}

function Application_OnStart()
{
//clear the logged table when the server restarts
var clearL = "DELETE FROM tbllogged";
adoConnection.Execute(clearL);

}



</script>

Internet Services

Web Development

Digital Marketing

Consumer Tech