I maintain a legacy ASP.Net Web application (using .Net 2.0 + SQL Server 2005 Enterprise + VSTS 2008 + C# + ADO.Net). Here is the connection string the legacy application is using (the legacy application is using SQL Server authentication mode):
"server=***;database=***;uid=***;pwd=***;pooling=false;max pool size=100"
I think the connection string is wrong because:
Is my understanding correct?
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.