|
| |
|
|
hzarabet
Posts: 1540
From: New Milford CT USA
Status: offline
 |
Closing databases - 3/31/2001 22:16:00
I have just installed an ad rotator on my site. All asp code. It is freeware so there isn't much support. I have been reading their bulletin board and there are complaints of leaking resources. Pages were named where databases weren't closed or improperly closed. I went in and closed some pages on my site. Here is my question. Is there any damage done by putting a closing statement on a page that doesn't need it? If I wasn't sure about the need for a closing on a page, I put it in "just in case". <%
oRS.Close
Set oRS = Nothing
oConn.Close
Set oConn = Nothing
%> Thanks guys ------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Closing databases - 3/31/2001 22:46:00
You may get an object error if you attempt to close an object that doesnt exist, unless you state "On error resume next" to prevent (hide) errors
| |
|
|
|
hzarabet
Posts: 1540
From: New Milford CT USA
Status: offline
|
RE: Closing databases - 3/31/2001 22:53:00
Nope, no errors. It is running fine. Just forget about it?------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
