memory issue with ADO recordset and ASP

[Guest_imported]

We have a web application that is using crystal reports 8.5. From an ASP page, we are retrieving an ADO recordset (from an Oracle database) and passing it to a crystal report (which uses a TTX) file. The recordset is passed in a session variable to the report (the only option crystal offers). We are following their recommendations and issuing the following statements when the user closes the activeX report viewer to destroy the session objects:

set session("oPageEngine&quot = nothing
set session("oRpt&quot = nothing
set session("oApp&quot = nothing

Session.Contents.Remove("oPageEngine&quot
Session.Contents.Remove("oRpt&quot
Session.Contents.Remove("oApp&quot

But... everytime we run a report, about 10MB of memory is taken on our application server. When the report is closed (and we remove the session objects), none of the memory is released. So... each time one report is run, out application server loses 10MB of memory that is never released.

Please help!

Any suggestions are appreciated!

 

[balves]

Are you also closing and destroying the ADO recordset?