Solved

ASP & Pooling of SQL connection?

Posted on 2003-11-17
4
200 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
I need a solution to a Webpage for Wholesale Availability. 11 48
Problem to master page 11 69
Web Designer 5 174
Text Transformation using ActionScript 3 5 133
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

816 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now