I have an asp driven site with a sqlserver db that keeps causing iis to crash.
I think i may of tracked down the problem to my recordset's
currently the site draws alot of data from the db through a SQLOLEDB connection.
I noticed that in the crash logs for iis the first page to receive a request error was an asp page that had multipile record sets in the one page. (it is not isolated to one page)
to get to my point, how important is it to close all record sets and also clear them?
i have added the following code to a number of pages;
set recordset = nothing
(i know this should have been there to start with but im only maintaning the site, someone else wrote it)
is there anything else i can do to prevent the recordsets from causeing iis to crash?
thanks in advance.