ADO.NET Connection Pooling Explained
Subject:   Kill your connection?
Date:   2004-03-14 17:52:37
From:   joshross
How do you kill your connection when the user does not have access to the t-sql kill command?
Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • Kill your connection?
    2005-02-01 22:39:55 [View]

    How can i kill the connection, in Oracle.

    i am using Oracle 9i with ASP.NET & C#, so connection pooling peoblem occur,
    how can i resolve it.
    • Kill your connection?
      2006-03-16 10:03:31  solutionsahead [View]

      Hi Sanjit,

      Just got to see the problem faced by you? Did you solve the same? If so plz mail me back asap...

      I have developed an E-business web application in Visual Studio.NET1.0 with ASP.NET, C# and Oracle9i as the database. The application is hosted on a windows Terminal Server with 2 GB RAM and 80 GB HDD resource.

      There is a lot of inactive sessions. The connections don't seem to be released from the pool whether I call dispose(), close(), or both, and this keeps building-up as users connect to the portal. We have used .NET 1.1 frame work with service pack 1 on the server. Can someone provide me with a solution recommendation asap?

      Thanks in anticipation?

    • Kill your connection?
      2005-04-25 10:30:41  camesvoliaj [View]

      Hi Sanjit,

      I am facing the same problem that you have mentioned in your email. Did you find a possible solution to the problem when Oracle is runnign at the back end..or did u get hold of the implementation that the author is talking of in the article. I am a novice in this field and will appreciate any help that I get.