|
|
|
|
|
| | |
|
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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.
|
|
|
|
|
|
|
|
|
|
|
|
|