| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Support Policies |
Learn about SQL Server Native Client supported SQL Server versions, operating systems, and support policies for ADO, BCP, ODBC, and OLE DB. |
markingmyname |
maghan |
09/06/2022 |
sql |
native-client |
reference |
[!INCLUDE SQL Server]
Important
[!INCLUDEsnac-removed-oledb-and-odbc]
This topic discusses how various data-access components can be used with [!INCLUDEssNoVersion] Native Client (SNAC).
[!INCLUDEssNoVersion] Native Client 11.0 supports connections to, [!INCLUDEsql2008-md], [!INCLUDEsql2008r2], [!INCLUDEssSQL11], [!INCLUDEssSQL14], and [!INCLUDE ssazure-sqldb].
The following table lists which operating systems support [!INCLUDEssNoVersion] Native Client.
| SQL Server Native Client version | Supported operating systems |
|---|---|
| SQL Server Native Client (SQL Server 2005) | Microsoft Windows 2000 Service Pack 4 or later Microsoft Windows Server 2003 or later Microsoft Windows XP Service Pack 1 or later Microsoft Windows Vista (requires [!INCLUDEssNoVersion] Service Pack 2, or later) Microsoft Windows Server 2008 R2 (requires [!INCLUDEssNoVersion] Service Pack 2, or later) |
| SQL Server Native Client 10.0 ([!INCLUDEsql2008-md]) | Microsoft Windows Server 2003 Service Pack 2, or later Microsoft Windows XP Service Pack 2, or later Microsoft Windows Vista Microsoft Windows Server 2008 R2 |
| SQL Server Native Client 10.5 ([!INCLUDEsql2008r2]) | Microsoft Windows Server 2003 Service Pack 2, or later Microsoft Windows XP Service Pack 2 or later Microsoft Windows Vista Microsoft Windows Server 2008 R2 Microsoft Windows 7 |
| SQL Server Native Client 11.0 ([!INCLUDEssSQL11] and [!INCLUDEssSQL14]) | Microsoft Windows Vista Microsoft Windows Server 2008 R2 Microsoft Windows 7 Microsoft Windows 8 Microsoft Windows Server 2012 |
ADO applications can use the SQLOLEDB OLE DB provider that is included with Windows if they do not require any of the features of [!INCLUDEssVersion2005] or later.
ADO applications can use the version of [!INCLUDEssNoVersion] Native Client included in [!INCLUDEssVersion2005]. ADO applications can also use [!INCLUDEssNoVersion] Native Client 11.0 (included in [!INCLUDEssSQL14]), but if they do so they must specify DataTypeCompatibility=80 in the connection strings. Only features from [!INCLUDEssVersion2005] are available when DataTypeCompatibility=80 is present in the connection strings.
Beginning in [!INCLUDEsql2008-md], bcp.exe supports data files that are no more than three [!INCLUDEssNoVersion] versions older than the version of [!INCLUDEssNoVersion] in which bcp.exe shipped.
Applications should use the [!INCLUDEssNoVersion] ODBC driver included with the Windows operating system. You can use the [!INCLUDEssNoVersion] Native Client ODBC driver if the application is certified it for use with a specific version of [!INCLUDEssNoVersion] Native Client.
Applications should use the [!INCLUDEssNoVersion] OLE DB provider included with the Windows operating system. You can use the [!INCLUDEssNoVersion] Native Client OLE DB provider if the application is certified for use with a specific version of [!INCLUDEssNoVersion] Native Client.
OLE DB applications that have not been certified for use with [!INCLUDEssNoVersion] Native Client can use [!INCLUDEssNoVersion] Native client if they specify DataTypeCompatibility=80 in their connection strings.
OLE DB applications that use OLE DB Service Components can only use [!INCLUDEssNoVersion] Native client if they specify DataTypeCompatibility=80 in their connection strings. However, no features added after [!INCLUDEssVersion2005] will be available in this case.
SQL Server Native Client support lifecycle can be found on the SNAC lifecycle explained blog. This lifecycle applies to building database applications using SQL Server Native Client.
Limited support is provided for the SQL Native Client 11.0 that gets installed by SQL Server 2012 through 2019 until the SQL Server respective end-of-support lifecycles. This support exception only applies to the SNAC 11 driver that is installed and used by SQL Server components (e.g. SQL Server Engine Linked Servers). This means the driver is supported on Windows versions where SQL Server 2012 through SQL Server 2019 are supported. Do not remove the SQL Native Client provider that gets installed by SQL Server on the system. The support exception only covers critical security fixes and does not include enhancements or fixes to SQL Native Client 11.0.
This support exception does not cover using SQL Native Client 11.0 as a driver for database applications to connect to SQL Server. Any applications using SNAC 11.0 must be updated to use newer versions (see Download ODBC Driver for SQL Server - ODBC Driver for SQL Server and Download Microsoft OLE DB Driver for SQL Server - OLE DB Driver for SQL Server).