• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

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)

0
Kirwincom
Asked:
Kirwincom
2 Solutions
 
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
 
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now