title: Connect FireDAC to SQL Server through ODBC Driver 17 instead of SQL Server Native Client
body: <p>I want to connect my FireDAC application using the latest Microsoft ODBC Driver for SQL Server 17, but my connection always uses the SQL Server Native Client 11 driver.</p>
  <p>This is the code I tried to indicate the desired driver:</p>
  <pre><code>FireDriverLink := TFDPhysMSSQLDriverLink.Create(nil);
  FireDriverLink.ODBCDriver := 'ODBC Driver 17 for SQL Server';
  FDConnection.DriverName := FireDriverLink.BaseDriverId;
  </code></pre>
  <p>To check the driver used, I raise an exception and read the error message:</p>
  <pre><code>FDConnection.ExecSQL('select convert(integer, ''X'')');
  </code></pre>
  <p>[FireDAC][Phys][ODBC][Microsoft]<code>[SQL Server Native Client 11.0]</code>[SQL Server]Error de conversión al convertir el valor varchar 'X' al tipo de datos int.</p>
  <p>How is the correct way to tell FireDAC to use the ODBC Driver for SQL Server 17 ?. Also, could I also tell FireDAC to use the latest ODBC Driver at design time instead of the native client ?.</p>
  <p>Thank you.</p>