title: SQL connection string to AG Listener from Always ON
body: <p>We're trying to connect to SQL / Always on from CLASSIC ASP, but we have a problem:</p>
  
  <blockquote>
    <p>Data source name not found and no default driver specified</p>
  </blockquote>
  
  <p>Our connection string:</p>
  
  <pre><code>Server=tcp:LISTENERNAME,1433;Database=DATABASENAME;Uid=USERNAME;Pwd=PASSWORD;
  </code></pre>
  
  <p>However, our old (OLEDB) connection string (without Always ON), works just fine:</p>
  
  <p>Old connection string:</p>
  
  <pre><code>Provider=SQLOLEDB;Data Source=IP address,1433;Network Library=DBMSSOCN;Database=DATABASENAME;Uid=USERNAME;Pwd=PASSWORD;
  </code></pre>
  
  <p>Any ideas?</p>