Re: ODBC/OLE DB Connection Pool

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 08:03:36 -0500

Kevin Joseph wrote:
> Stuart,
>
> You are correct about the perfmon counters part - what I meant was
> that even when I had the connection string set for ODBC I could not
> see those counters rise - which is why I then switched to OLE DB.
>
> Anyway, I have read quite a bit about the latter section in your
> e-mail (about IDataInititalize etc) but am not sure how to do that.
> Pardon my lack of knowledge in this are but can I have a simple .exe
> file running in the background performing this function.
>
> Thanks a lot again for your reply ; really appreciate it.
>
> PS: I have verified basic things like the reg entry etc and they are
> good.
>
> 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 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: ODBC/OLE DB Connection Pool
    ... Kevin Joseph wrote: ... > You are correct about the perfmon counters part - what I meant was ... anything to turn Session pooling on. ... This email account is my spam trap so I don't check it very often. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... Kevin Joseph wrote: ... > You are correct about the perfmon counters part - what I meant was ... anything to turn Session pooling on. ... This email account is my spam trap so I don't check it very often. ...
    (microsoft.public.data.oledb)