title: PromptDataSource and password
body: <p>I use <code>PromptDataSource</code> to allow users to setup a database connection. </p>
  
  <pre><code>connectionString := ADOdb.PromptDataSource(0, '');
  </code></pre>
  
  <p>However I can't get it to work with <em>"Allow saving password"</em> when using the <strong>SQL Server Native Client 10.0</strong> provider:</p>
  
  <p><img src="https://i.stack.imgur.com/tEsPe.png" alt="enter image description here"></p>
  
  <p><code>PromptDataSource</code> return a string with <code>Persist Security Info=False</code>, and the password is omitted, when using that provider:</p>
  
  <blockquote>
    <p>Provider=SQNCLI10.1;Integrated Security="";Persist Security Info=<strong>False</strong>;User ID=MGH;Initial Catalog="";Data Source=stackoverflow.com;Initial File Name="";Server SPN=""</p>
  </blockquote>
  
  <p>Other providers that I've tried worked, what can I do to fix this?</p>
  
  <p><strong>Note</strong>: I believe the provider is installed with MS SQL Server 2008 R2. </p>