| title | Support Policies for SQL Server Native Client | Microsoft Docs |
|---|---|
| ms.date | 03/14/2017 |
| ms.prod | sql |
| ms.reviewer | |
| ms.custom | |
| ms.technology | native-client |
| ms.topic | reference |
| ms.assetid | 09c80cf4-23e6-4027-a24f-cdb9c87af811 |
| author | markingmyname |
| ms.author | maghan |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
This topic discusses how various data-access components can be used with [!INCLUDEssNoVersion] Native Client.
[!INCLUDEssNoVersion] Native Client 11.0 supports connections to, [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], [!INCLUDEssSQL11], [!INCLUDEssSQL14], and [!INCLUDEssSDSfull].
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 ([!INCLUDEssKatmai]) | 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 ([!INCLUDEssKilimanjaro]) | 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 [!INCLUDEssKatmai], 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.