title: Connection pool setting of SQL Server connection string
body: <p>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):</p>
  
  <pre><code>"server=***;database=***;uid=***;pwd=***;pooling=false;max pool size=100"
  </code></pre>
  
  <p>I think the connection string is wrong because:</p>
  
  <ol>
  <li>Since the setting of pooling is false, but it also set pool size -- conflicting.</li>
  <li>Even if there are conflicting settings, I think pooling = false takes effect, I.e. connection pool is not used by the ADO.Net application.</li>
  </ol>
  
  <p>Is my understanding correct?</p>