connection pool setting of SQL Server connection string

Question

Hello everyone,

I am using .Net 2.0 + SQL Server 2005 Enterprise + VSTS 2008 + C# + ADO.Net to maintain a legacy ASP.Net Web application. Here is the connection string the legacy application is using (the legacy application is using SQL Server authentication mode),

My question is, I think the connection string is wrong, 1. since the setting of pooling is false, but it also set pool size -- conflicting. 2. Even if there are conflicting settings, I think pooling = false takes effect, i.e. connection pool is not used by the ADO.Net application. My understanding correct?

"server=***;database=***;uid=***;pwd=***;pooling=false;max pool size=100"

thanks in advance, George

Answer 1

Yes. You are right. if pooling = false, the max pool size will not take effect. but the connection is not necessarily wrong. it is still valid.