SQL Server Native Client 的系统要求System Requirements for SQL Server Native Client

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

若要使用 SQL ServerSQL Server 的数据访问功能(如 MARS),必须安装以下软件:To use data access features of SQL ServerSQL Server such as MARS, you must have the following software installed:

  • 客户端上的 SQL ServerSQL Server Native Client。SQL ServerSQL Server Native Client on your client.

  • 服务器上的 SQL ServerSQL Server 实例。An instance of SQL ServerSQL Server on your server.

SQL ServerSQL Server Native Client 需要 3.1 Windows Installer。Native Client requires Windows Installer 3.1. Windows Installer 3.1 已安装在 MicrosoftMicrosoft Windows 操作系统上。Windows Installer 3.1 is already installed on MicrosoftMicrosoft Windows operating systems. 您需要将其显式安装到所有其他平台上。For all other platforms you need to explicitly install it. 有关详细信息,请参阅 Windows Installer 3.1 可再发行组件 (v2) For more information, see Windows Installer 3.1 Redistributable (v2).

备注

确保以管理员权限进行登录,然后再安装此软件。Make sure you log on with administrator privileges before installing this software.

操作系统要求Operating System Requirements

有关支持 Native Client 的操作系统的列表 SQL ServerSQL Server ,请参阅 SQL Server Native Client 的支持策略For a list of operating systems that support SQL ServerSQL Server Native Client, see Support Policies for SQL Server Native Client.

SQL Server 要求SQL Server Requirements

若要使用 SQL ServerSQL Server Native Client 访问 SQL ServerSQL Server 数据库中的数据,必须安装 SQL ServerSQL Server 实例。To use SQL ServerSQL Server Native Client to access data in SQL ServerSQL Server databases, you must have an instance of SQL ServerSQL Server installed.

SQL Server 2014 (12.x)SQL Server 2014 (12.x) 支持与 MDAC 的所有版本、Windows 数据访问组件以及 SQL ServerSQL Server Native Client 的所有版本的连接。supports connections from all versions of MDAC, Windows Data Access Components, and all versions of SQL ServerSQL Server Native Client. 如果客户端的较旧版本连接到 SQL ServerSQL Server,则该客户端未知的服务器数据类型将映射到与客户端版本相兼容的类型。When an older client version connects to SQL ServerSQL Server, server data types not known to the client are mapped to types that are compatible with the client version. 有关详细信息,请参阅本主题后面的“客户端版本的数据类型兼容性”。For more information, see Data Type Compatibility for Client Versions, later in this topic.

跨语言要求Cross-Language Requirements

支持的操作系统的所有本地化版本均支持英文版 SQL ServerSQL Server Native Client。The English-language version of SQL ServerSQL Server Native Client is supported on all localized versions of supported operating systems. 与本地化版本的 SQL ServerSQL Server Native Client 使用同一语言的本地化操作系统支持 SQL ServerSQL Server Native Client 的本地化版本。Localized versions of SQL ServerSQL Server Native Client are supported on localized operating systems that are the same language as the localized SQL ServerSQL Server Native Client version. 只要安装了匹配的语言设置,则支持的操作系统的英文版还支持 SQL ServerSQL Server Native Client 的本地化版本。Localized versions of SQL ServerSQL Server Native Client are also supported on English-language versions of supported operating systems as long as the matching language settings are installed.

对于升级:For upgrades:

  • SQL ServerSQL Server Native Client 的英文版可以升级到 SQL ServerSQL Server Native Client 的任一本地化版本。English-language versions of SQL ServerSQL Server Native Client can be upgraded to any localized version of SQL ServerSQL Server Native Client.

  • SQL ServerSQL Server Native Client 的本地化版本可以升级到同一语言的 SQL ServerSQL Server Native Client 本地化版本。Localized versions of SQL ServerSQL Server Native Client can be upgraded to localized versions of SQL ServerSQL Server Native Client of the same language.

  • SQL ServerSQL Server Native Client 的本地化版本可以升级到 SQL ServerSQL Server Native Client 的英文版。Localized version of SQL ServerSQL Server Native Client can be upgraded to the English-language version of SQL ServerSQL Server Native Client.

  • SQL ServerSQL Server Native Client 的本地化版本无法升级到不同本地化语言的 SQL ServerSQL Server Native Client 本地化版本。Localized versions of SQL ServerSQL Server Native Client cannot be upgraded to localized SQL ServerSQL Server Native Client versions of a different localized language.

客户端版本的数据类型兼容性Data Type Compatibility for Client Versions

SQL ServerSQL Server SQL ServerSQL Server Native Client 将新数据类型映射到与下级客户端相兼容的较旧的数据类型,如下表所示。and SQL ServerSQL Server Native Client map new data types to older datatypes that are compatible with down-level clients, as shown in the table below.

OLE DB 和 ADO 应用程序可以将 DataTypeCompatibility 连接字符串关键字与 SQL ServerSQL Server Native Client 一起使用,以使用较旧的数据类型。OLE DB and ADO applications can use the DataTypeCompatibility connection string keyword with SQL ServerSQL Server Native Client to operate with older data types. 如果 DataTypeCompatibility=80,OLE DB 客户端将使用 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 表格格式数据流 (TDS) 版本而不是 TDS 版本进行连接 。When DataTypeCompatibility=80, OLE DB clients will connect using the SQL Server 2005 (9.x)SQL Server 2005 (9.x) tabular data stream (TDS) version, rather than the TDS version. 也就是说,对于 SQL Server 2008SQL Server 2008 和较新的数据类型,将由服务器而不是 SQL ServerSQL Server Native Client 执行下级转换。This means that for SQL Server 2008SQL Server 2008 and later data types, down-level conversion will be performed by the server, rather than by SQL ServerSQL Server Native Client. 此外,这还意味着,连接中的可用功能将被限制为 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 功能集。It also means that the features available on the connection will be limited to the SQL Server 2005 (9.x)SQL Server 2005 (9.x) feature set. 尽可能早地对 API 调用中使用新数据类型或功能的尝试进行检测,将错误返回给调用应用程序,而不是尝试将无效的请求传递给服务器。Attempts to use new datatypes or features are detected as early as possible on API calls and errors are returned to the calling application, rather than attempting to pass invalid requests to the server.

没有适用于 ODBC 的 DataTypeCompatibility 控件。There is no DataTypeCompatibility control for ODBC.

IDBInfo::GetKeywords 将始终返回与连接中的服务器版本相对应的关键字列表,并且不受 DataTypeCompatibility 的影响。IDBInfo::GetKeywords will always return a keyword list that corresponds to the server version on the connection and is not affected by DataTypeCompatibility.

数据类型Data type SQL Server Native ClientSQL Server Native Client

SQL Server 2005SQL Server 2005
SQL Server Native Client 11.0SQL Server Native Client 11.0

SQL Server 2014 (12.x)SQL Server 2014 (12.x)
Windows 数据访问组件、MDAC 及Windows Data Access Components, MDAC, and

SQL Server Native Client OLE DB 应用程序(其中 DataTypeCompatibility=80)SQL Server Native Client OLE DB applications with DataTypeCompatibility=80
CLR UDT (<= 8Kb)CLR UDT (<= 8Kb) udtudt UdtUdt VarbinaryVarbinary
varbinary(max)varbinary(max) varbinaryvarbinary varbinaryvarbinary 映像Image
varchar(max)varchar(max) varcharvarchar varcharvarchar 文本Text
nvarchar(max)nvarchar(max) nvarcharnvarchar nvarcharnvarchar NtextNtext
xmlxml xmlxml xmlxml NtextNtext
CLR UDT ( # A0 8Kb) CLR UDT (> 8Kb) udtudt varbinaryvarbinary 映像Image
datedate datedate varcharvarchar VarcharVarchar
datetime2datetime2 datetime2datetime2 varcharvarchar VarcharVarchar
datetimeoffsetdatetimeoffset datetimeoffsetdatetimeoffset varcharvarchar VarcharVarchar
timetime timetime varcharvarchar VarcharVarchar

另请参阅See Also

SQL Server Native Client 编程 SQL Server Native Client Programming
安装 SQL Server Native ClientInstalling SQL Server Native Client