|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
SQL Connection |
|
From: |
steven |
|
Date: |
5/23/2000 12:44:17 AM |
|
IP: |
202.188.254.221 |
Dear all,
I knew that each connection should be closed individually after open. I have
situation where SQL connection was opened using ASP and was not closed.
This cause the web server memory usage keep increasing.
My question is that, is there any setting in SQL or command in ASP that
force to close the connection after certain time lets say 10 seconds.
Bcos I have noticed that the connections will close itself after certain
time. (I was using the sp_who to monitor it)
Your advice and help is much appreciated.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
