ASP & Pooling of SQL connection?

An ASP page uses CreateObject() to instantiate a COM+ component, and then calls one of its methods.  This method uses an ADO Connection object with an ODBC connection string to connect to SQL Server in order to retrieve data.  Which product is performing the pooling of SQL connections? (SQL Server, ADO, COM+ or ODBC)

KirwincomAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MikeMillerCommented:
ODBC.

If you have 15 websites all using the same ODBC connection, they are all pooled and show up as 1 connection in SQL Server.

mike
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nickblah42Commented:
As long as the connection string is identical, and the connection is explicitly opened, I believe ADO will pool connections internally (before ODBC).  COM+ pooling is not involved by default.  SQL Server doesn't pool.

The ODBC driver may also do pooling (MS's does), but ADO happens first.

Important note: ADO will only pool as long as it is loaded.  For ASP, this is not an issue (IIS will keep it loaded automatically).

- Nick
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.