tidy connections left open

Discussion in 'ASP General' started by Shailesh Humbad, Jul 24, 2003.

  1. Many a page has ADO Connection objects that were opened but never
    closed. The Connection object allocates its own resources when it is
    opened. When the object goes out of scope without being explicitly
    closed, the resources ASP allocated for it are freed, but the resources
    it allocated on its own are not. These eventually clutter up the server
    and slow it down to a crawl. My question is, is there a way to track
    down these orphaned resources and forcibly free them from ASP, without
    restarting IIS or the server? Or does one have to wait for the unused
    Connections to time out and release themselves? I know that good coding
    practice is best, but is there a temporary fix to tidy up these
    connections left open?

    Shailesh
     
    Shailesh Humbad, Jul 24, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?TiBTIFM=?=

    Oracle Connections left open

    =?Utf-8?B?TiBTIFM=?=, Jun 9, 2005, in forum: ASP .Net
    Replies:
    5
    Views:
    3,105
    =?Utf-8?B?R0M=?=
    Aug 30, 2005
  2. =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?=

    Help on table align on left of page vs left hanging indent

    =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?=, Jul 10, 2007, in forum: XML
    Replies:
    2
    Views:
    1,054
    =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?=
    Jul 16, 2007
  3. jobs
    Replies:
    2
    Views:
    919
  4. pc
    Replies:
    2
    Views:
    1,397
    crisgoogle
    Jun 8, 2011
  5. lawrence
    Replies:
    13
    Views:
    347
    Thomas 'PointedEars' Lahn
    Sep 4, 2004
Loading...

Share This Page