title: What is the difference between these two SQL Server connection strings
body: <p>When I use the following connection strings, the first one is working and the second is not working on my system. May I know the difference between these two connections strings?</p>
  
  <pre><code>DSN=ABCD;DATABASE=db1;UID=userid;PWD=passwd
  </code></pre>
  
  <p>and the second one</p>
  
  <pre><code>Data Source=ABCD;DATABASE=db1;UID=userid;PWD=passwd
  </code></pre>
  
  <p>Error thrown by second string</p>
  
  <blockquote>
    <p>[unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnect)</p>
  </blockquote>
  
  <p>I am new to using SQL Server, so confused the difference between DSN and Data Source</p>