Re: ODBC/OLE DB Connection Pool

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

  • Next message: cjk: "Re: Accessing an open OLE DB data source via ADO" 
    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"
  • Next message: cjk: "Re: Accessing an open OLE DB data source via ADO"

    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.ado)