dont keep it in the session object

That is probelm with session based connection .Well The way we did it 
out here we removed it from here we keep actice connections to the 
database and then remove them.If the database based trafiic is more in 
numbers numbers of connection will also hamper the effeciency of the app 



I hope this helps
thx
sid

-----Original Message-----
From: srotondo@h... [mailto:srotondo@h...]
Sent: Friday, July 26, 2002 3:24 PM
To: ASP Databases
Subject: [asp_databases] How do I kill my ADO connection to SQL Server?


I logon to my SQL Server database during sub session_onstart in the
global.asa file.  Via an ASP form, I write info to my data base.

Here's how I close the connection:

sub session_onEnd
adoCon.Close
set adoCon =3D nothing
end sub

However, when I close my browser session, my SQL Server session is still 

running.  How do I kill the session in my global.asa?

I logon to my SQL Server database during sub session_onstart in the 
global.asa file.  Via an ASP form, I write info to my data base.

Here's how I close the connection:

sub session_onEnd
adoCon.Close
set adoCon = nothing
end sub

However, when I close my browser session, my SQL Server session is still 
running.  How do I kill the session in my global.asa?