dbTalk Databases Forums  

Problems closing connections when using ADOMD in ASP.NET

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problems closing connections when using ADOMD in ASP.NET in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dinnan
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.