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)

Who is Participating?
MikeMillerConnect With a Mentor Commented:

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

nickblah42Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.