Re: How to close connection pool?

Simply open connections with pooling disabled--or as suggested when
performing maintenance, use single-user mode.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"pearsons_11114" <pearsons11114@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:96E7D38D-CEF8-4EED-AE7C-63B9FDC2A014@xxxxxxxxxxxxxxxx
Just seems like a major design hiccup not to be able to control that. The
scenarios are unlimited. In my case, I want to perform a restore on a
database from the application. If that database has ever been accessed
from
the application, then there will be effectively orphaned connections in
the
pool preventing it until the user exits the application. We dodged a
bullet
in that the action is normally only performed when the application is
first
started. However, some configuration information gets loaded from the DB
before that, so I need to set pooling to false for that action. So, I have
workarounds in my case, but still seems odd not to be able to control it.

"Miha Markic [MVP C#]" wrote:

The feature is added in .net 2 for oracle and sqlserver.
Why is this (an administrative) problem for you?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"pearsons_11114" <pearsons11114@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:DBC5128D-FEDF-4B83-B580-9FE54E6F3A16@xxxxxxxxxxxxxxxx
Let me say preemptively I've read up on this and searched postings here
and
haven't found an answer.

Connection pooling doesn't provide a way to close all connections in
the
pool, short of exiting the process. This seems to me to be a
designed-in
leak. I can think of a few scenarios where this creates an
administrative
problem, one of which I'm in.

Thanks.





.

Relevant Pages

  • Re: Question about Connection Pooling in ASP
    ... you almost have to deliberately turn off connection pooling in order ... As long as you are talking about storing a string in Application, ... pooling is used for all connections using that string. ... using connected recordsets, instead of utilizing GetString, GetRows ...
    (microsoft.public.inetserver.asp.db)
  • RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
    ... Here are a few options off the top of my head: ... Pooling via SQLRelay ... connections, just reduces the number of connections required. ... to take some load off of your database server. ...
    (perl.dbi.users)
  • Re: ADO - Bad when it is time to Optimize
    ... in COM-ATL and the data access is thru ADO to SQL. ... You cannot set the max pool size. ... There is no way to disable the pooling ... You cannot know whether non-pooled connections are happening ...
    (microsoft.public.data.ado)
  • Re: Disable .Net Connection Pooling thru SQLDMO
    ... -- -oj "Rob Kraft" wrote in message ... >I would like to disable the .Net connection Pooling. ... I have a conversion> pgm using SQLDMO and .Net that needs to kill its own connections, ...
    (microsoft.public.sqlserver.programming)
  • Re: Global data concurrent access ?
    ... No pooling 1000 iterations. ... Elapsed time: 00:00:12.9217096 ... affects pooled connections (makes sense; ...
    (microsoft.public.dotnet.framework)