Re: ODBC/OLE DB Connection Pool

From: Kevin Joseph (kejoseph_at_hotmail.com)
Date: 11/26/04 

Date: 26 Nov 2004 09:20:23 -0800

Hi Bob,

Reason I think the error is related to connection pooling is cos of
the article on MS support site
http://support.microsoft.com/default.aspx?scid=kb;en-us;328476

The web site I have servers 20,000+ users. Out of 100,000 hits to the
IIS server around 200 or at most 2000 fail with the "server not found"
error message. The above article clearly states that it is related to
Connection Pool (I have already completed the TCP/IP tasks without
success)

If connection pool is setup on the client, it is possible to monitor
the SQL server connections using perfmon - if the connections grow ;
it means that connection pooling is not working. And this is exactly
what is happening in my case. If you have some other way of proving
that connection pooling is fine ; I will gladly accept your point of
view.

Thanks for the reply Bob, appreciate it.

Kevin.

> If you read Stuart's post carefully, you will see that you do not have to do
> anything to turn Session pooling on. It's on by default. You have to do
> extra work to turn it off.
>
> Again, I think you need to look for some other cause for your symptoms. You
> seem to be wandering down a blind alley here. I know you are probably just
> trying to eliminate all possible problems, but I can say with almost
> absolute certainty that turning off pooling will not lead to "server not
> found" or "access denied" errors. I've never heard of a situation where this
> occurred. If you can point me at one, I would be happy to know about it.
>
> What prompted you to start investigate pooling as a potential cause for this
> in the first place? The errors you describe indicate problems with your
> network infrastructure, not pooling.
>
> Bob Barrows

Relevant Pages

  • Re: Random database connectivity failure
    ... We can’t find any problems with the pooling, that it uses to many resources. ... pointing to its not a pool problem. ... The server is only used for this web-application, ... white paper on handling the connection pool on my website. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ODBC/OLE DB Connection Pool
    ... > Connection Pool (I have already completed the TCP/IP tasks without ... turning off pooling is the errors you are seeing. ... problems are occurring with SQL Server; for example, ... ASP developers should open one connection per set of unique user ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > Connection Pool (I have already completed the TCP/IP tasks without ... turning off pooling is the errors you are seeing. ... problems are occurring with SQL Server; for example, ... ASP developers should open one connection per set of unique user ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > Connection Pool (I have already completed the TCP/IP tasks without ... turning off pooling is the errors you are seeing. ... problems are occurring with SQL Server; for example, ... ASP developers should open one connection per set of unique user ...
    (microsoft.public.data.oledb)
  • Re: ODBC/OLE DB Connection Pool
    ... the article on MS support site ... IIS server around 200 or at most 2000 fail with the "server not found" ... Connection Pool (I have already completed the TCP/IP tasks without ... it means that connection pooling is not working. ...
    (microsoft.public.inetserver.asp.db)