It also means that the features available on the connection will be limited to the SQL Server 2005 (9.x) feature set. This means that for SQL Server 2008 and later data types, down-level conversion will be performed by the server, rather than by SQL Server Native Client. When DataTypeCompatibility=80, OLE DB clients will connect using the SQL Server 2005 (9.x) tabular data stream (TDS) version, rather than the TDS version.
OLE DB and ADO applications can use the DataTypeCompatibility connection string keyword with SQL Server Native Client to operate with older data types. SQL Server and SQL Server Native Client map new data types to older datatypes that are compatible with down-level clients, as shown in the table below. Localized versions of SQL Server Native Client cannot be upgraded to localized SQL Server Native Client versions of a different localized language.ĭata Type Compatibility for Client Versions Localized version of SQL Server Native Client can be upgraded to the English-language version of SQL Server Native Client. Localized versions of SQL Server Native Client can be upgraded to localized versions of SQL Server Native Client of the same language. Localized versions of SQL Server Native Client are also supported on English-language versions of supported operating systems as long as the matching language settings are installed.Įnglish-language versions of SQL Server Native Client can be upgraded to any localized version of SQL Server Native Client. Localized versions of SQL Server Native Client are supported on localized operating systems that are the same language as the localized SQL Server Native Client version.
The English-language version of SQL Server Native Client is supported on all localized versions of supported operating systems. For more information, see Data Type Compatibility for Client Versions, later in this topic. When an older client version connects to SQL Server, server data types not known to the client are mapped to types that are compatible with the client version. SQL Server 2014 (12.x) supports connections from all versions of MDAC, Windows Data Access Components, and all versions of SQL Server Native Client. To use SQL Server Native Client to access data in SQL Server databases, you must have an instance of SQL Server installed. Operating System Requirementsįor a list of operating systems that support SQL Server Native Client, see Support Policies for SQL Server Native Client. Make sure you log on with administrator privileges before installing this software.
0 kommentar(er)
