title: SQL Server Login works with DSN for ODBC driver 11 for SQL Server but unable to connect through connection string (Classic ASP Application)
body: <p>We have a Classic ASP application hosted on server Win 2008 R2, Database - SQL server 2008 R2. The application was working fine until we disabled TLS 1.0 and enabled TLS 1.2 in app server. TLS 1.2 is enabled on Database server. We have installed SSMS on app server and are able to connect to DB. Created a system DSN and tested using ODBC drivers which is only successful when tried &quot;ODBC driver 11 for SQL Server&quot; driver. Performed UDL test in app server and the test connection failed while using both DSN and connection string with errors &quot;Invalid Connection String Attribute&quot; and &quot;Data source name not found and no default driver specified&quot; respectively. Instead of OLEDB we have tried <code>SQLNCLI10</code> which also didn't work.</p>
  <p>Tried all the drivers and the respective connection-strings, though able to establish connection using &quot;ODBC driver 11 for SQL Server&quot;. Hence also tried the connection strings</p>
  <ol>
  <li><p>SQL Server Native Client</p>
  <p><code>Driver={SQL Server Native Client 11.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;</code></p>
  </li>
  <li><p>SQL Server for ODBC</p>
  <p><code>DRIVER={ODBC Driver 11 for SQL Server};SERVER=test;DATABASE=test;UID=user;PWD=password</code></p>
  </li>
  <li><p>DSN</p>
  <p><code>DSN=myDsn;Uid=myUsername;Pwd=;</code></p>
  </li>
  </ol>
  <p>But unable to establish connection to database. Please suggest.</p>