Problems closing connections when using ADOMD in ASP.NET -
08-29-2003
, 05:42 AM
I am experiencing problems closing my ADODB connections when using ADOMD.
My ASP.NET application uses a new connection for each call to the
Analysis Server. Perhaps this is a ineffective approach?
The problem seems to be that the connections isn't closed until .NET
garbage collects them even though I issue the close command. This
Garbage collection appears to be run when the user no longer is browsing
the page that has the connection.
This is a problem for me since I have a page that gets "post backed"
frequently and therefore a new connection is made each time but none is
closed so after a while I have a whole bunch of established connections.
Any advice on how to solve my problem?
Thanks
Dinnan |