Conection Pooling with multiple applications

[ind_123]

Can connection pooling be implemented for multiple applications? How
is it done?

[Alvin Bruney [ASP.NET MVP]]

what environment are we talking? windows? web? web connection pooling is on
by default. windows, you need to turn it on through the connection string
property.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

"ind_123" <dhul...@gmail.com> wrote in message
news:92dd9be3-6728-4f54...@f63g2000hsf.googlegroups.com...

[Marc Gravell]

Are you sure about that? I haven't tested it, but most references I've
seen simply state "enabled by default on SQL Server" (or some-such),
without qualifying web vs windows - for example:

http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx

Marc

[Arne Vajhøj]

ind_123 wrote:
> Can connection pooling be implemented for multiple applications? How
> is it done?

[I will assume database connections]

Each application has its own pool.

Note that the database will get the sum of all the apps
connections, so consider number of apps when deciding
on pool size.

Arne

[Arne Vajhøj]

It is easy to verify that pooling works for a simple
console app by specifying Min Pool Size and call
sp_who.

Arne

[parez]

On Apr 21, 5:42 pm, ind_123 <dhulap...@gmail.com> wrote:
> Can connection pooling be implemented for multiple applications? How
> is it done?

I think connection pools are connection string specific.. you will end
up having connection pool for each application(ConnString)