Connection Pooling With ASP.NET 1.1

Does ASP.NET with ADO connecting to MS SQL Server use connection pooling by
default if the connection string is always the same? If not, how does one
go about evoking connection pooling ?

Dave
Thu Aug 24 01:23:02 CDT 2006

Hi Robert,

Yes, the ADO.NET data provider for Sql Server pools connections automatically based on distict connection strings. You can disable
or adjust pooling using attributes in the connection string.

--
Dave Sexton

"Robert E. Flaherty" <Bobf@TimeVision.Com> wrote in message news:u5hLeSzxGHA.1788@TK2MSFTNGP05.phx.gbl...
> Does ASP.NET with ADO connecting to MS SQL Server use connection pooling by default if the connection string is always the same?
> If not, how does one go about evoking connection pooling ?
>

Paul
Thu Aug 24 08:47:56 CDT 2006

On Wed, 23 Aug 2006 23:22:23 -0500, "Robert E. Flaherty" <Bobf@TimeVision.Com> wrote:

¤ Does ASP.NET with ADO connecting to MS SQL Server use connection pooling by
¤ default if the connection string is always the same? If not, how does one
¤ go about evoking connection pooling ?
¤

Yes, but it's per application process or application pool.


Paul
~~~~
Microsoft MVP (Visual Basic)

Mary
Mon Sep 04 12:52:37 CDT 2006

Not only must the connection be the same, but also the security
context. In other words, if you are using impersonation with
integrated security, then you won't get pooled connections. For more
information, see "Using Connection Pooling with SQL Server"
http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx.

--Mary

On Wed, 23 Aug 2006 23:22:23 -0500, "Robert E. Flaherty"
<Bobf@TimeVision.Com> wrote:

>Does ASP.NET with ADO connecting to MS SQL Server use connection pooling by
>default if the connection string is always the same? If not, how does one
>go about evoking connection pooling ?
>