How to enable connection pooling with ADODB.Connection [Answered]RSS

3 replies

Last post Oct 05, 2008 05:43 PM by steve schofield

  • How to enable connection pooling with ADODB.Connection

    Oct 04, 2008 03:18 AM|rw97540|LINK

    Is there a way to enable connection pooling with ADODB.Connection? I have seen several things that say to call SqlSetEnvAttr which is impossible to do from Classic ASP (unless I'm missing something).

     I found the KB article 237844 which also says the same. This is IIS 6. Thanks

  • Re: How to enable connection pooling with ADODB.Connection

    Oct 04, 2008 11:33 PM|steve schofield|LINK

    See if this article helps.

    http://support.microsoft.com/kb/191572

    Steve Schofield
    Windows Server MVP - IIS
    http://iislogs.com/steveschofield
    http://www.IISLogs.com
    Log archival solution
    Install, Configure, Forget

  • Re: How to enable connection pooling with ADODB.Connection

    Oct 05, 2008 07:35 AM|rw97540|LINK

    Steve,

    Thanks. That's basically the answer. It appears that some of this code is trying to open a new recordset when one is already open and it is creating an implied connection which is not part of the connection pool.

    By using Performance monitor to watch logins/sec, and stepping through the code it's pretty quick and easy to issolate where these "bugs" are.

    Thanks again!

  • Re: How to enable connection pooling with ADODB.Connection

    Oct 05, 2008 05:43 PM|steve schofield|LINK

    I'm glad that was helpful.  What I did on a high volume site I used to run was create an application variable in the global.asa and refer to that instead of explicitly creating a new connection.  The cpu on the web server went from 30% to 40% to 10% to 12% when connection pooling was enabled.  This was a few years ago, but it made me a believer of connection pooling. :)

    Steve Schofield
    Windows Server MVP - IIS
    http://iislogs.com/steveschofield
    http://www.IISLogs.com
    Log archival solution
    Install, Configure, Forget