title: VB6 and Sql server 2016 Express connection string
body: <p>In one of our old vb6 app connection string is as follows:</p>
  
  <pre><code>nk = "Provider=SQLOLEDB;"
  nk = nk + "Integrated Security=SSPI;"
  nk = nk + "Persist Security Info=False;"
  nk = nk + "User ID=sa;"
  nk = nk + "Password=******;"
  nk = nk + "Initial Catalog=" &amp; db &amp; ";"
  nk = nk + "Data Source=" &amp; hn
  kon.ConnectionString = nk
  kon.Open
  </code></pre>
  
  <p>If I try to connect with these options it wont work, so I'm interested why these two options:</p>
  
  <pre><code>nk = nk + "Integrated Security=SSPI;"
  nk = nk + "Persist Security Info=False;"
  </code></pre>
  
  <p>are not ignored?</p>
  
  <p>Just to mention that application is connecting to Sql Server 2016 Express on Windows Server 2016 Standard over local network.</p>