Solved

ASP & Pooling of SQL connection?

Posted on 2003-11-17
4
201 Views
Last Modified: 2010-08-05
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
Comment
Question by:Kirwincom
4 Comments
 
LVL 3

Accepted Solution

by:
MikeMiller earned 25 total points
ID: 9988647
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
 

Assisted Solution

by:nickblah42
nickblah42 earned 25 total points
ID: 10031648
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
New Website 15 31
how to gather data from news site 6 44
Extracting data from Salesforce visualforce page 1 219
Text Transformation using ActionScript 3 5 151
When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question