title: What provider should I choose for my VB6 ADODB connection to SQL Server 2014?
body: <p>I'm not sure how to interpret this quote from the MSDN documentation. Is the native client deprecated? </p>
  
  <blockquote>
    <p>There will be no more updates to the ODBC driver in SQL Server Native Client. The successor to the ODBC driver in SQL Server Native Client, which is called the Microsoft ODBC Driver 11 for SQL Server on Windows, is installed with SQL Server 2014.</p>
    
    <p>The OLE DB Provider in SQL Server Native Client was last updated in SQL Server 2012 Native Client. Developers who wish to use an OLE DB provider to connect to the latest version of SQL Server must use the OLE DB provider that shipped in SQL Server 2012 Native Client.</p>
  </blockquote>
  
  <p>I also found this statement on msdn. </p>
  
  <blockquote>
    <p>Microsoft has announced the deprecation of the SQL Server Native Client OLE DB provider, and that SQL Server 2012 is the last version of SQL Server to support the provider. This article provides guidance for converting SQL Server or SQL Azure applications that use OLE DB to the ODBC API.</p>
  </blockquote>
  
  <p>Connection string samples for the different suggestions is also helpful :)</p>