Connection Pooling With ASP.NET 1.1

[Robert E. Flaherty]

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 Sexton]

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.

 

[Paul Clement]

¤ 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 Chipman [MSFT]]

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