Microsoft SQL Server 的驱动程序历史记录Driver history for Microsoft SQL Server

本页面介绍 Microsoft 用于连接到 SQL Server 的历史数据连接技术。This page describes Microsoft's historical data connection technologies for connecting to SQL Server.

ODBCODBC

有三代不同的 Microsoft ODBC Driver for SQL Server。There are three distinct generations of Microsoft ODBC drivers for SQL Server. 第一代“SQL Server”ODBC 驱动程序仍作为 Windows 数据访问组件的一部分提供。The first "SQL Server" ODBC driver still ships as part of Windows Data Access Components. 对于新开发,不建议使用此驱动程序。This driver isn't recommended for new development. 从 SQL Server 2005 开始,SQL Server Native Client 包含一个 ODBC 接口,并且它是 SQL Server 2005 至 SQL Server 2012 中随附的 ODBC 驱动程序。Starting in SQL Server 2005, the SQL Server Native Client includes an ODBC interface and is the ODBC driver that shipped with SQL Server 2005 through SQL Server 2012. 对于新开发,也不建议使用此驱动程序。This driver also isn't recommended for new development. 在 SQL Server 2012 之后,Microsoft ODBC Driver for SQL Server 驱动程序随最新的服务器功能进行更新。After SQL Server 2012, the Microsoft ODBC Driver for SQL Server is the driver that is updated with the most recent server features going forward.

SQL Server Native ClientSQL Server Native Client

SQL Server Native Client 是一个用于 OLE DB 和 ODBC 的独立库。SQL Server Native Client is a stand-alone library that is used for both OLE DB and ODBC. SQL Server 2005 至 SQL Server 2012 中已包含 SQL Server Native Client(通常缩写为 SNAC)。SQL Server Native Client (often abbreviated SNAC) was included in SQL Server 2005 through 2012. SQL Server Native Client 可用于需要利用 SQL Server 2005 至 SQL Server 2012 中引入的新功能的应用程序。SQL Server Native Client can be used for applications that need to take advantage of new features introduced in SQL Server 2005 through SQL Server 2012. (对于 SQL Server 中的这些新功能,不会更新 Microsoft/Windows 数据访问组件。)对于 SQL Server 2012 之后的新功能,将不会更新 SQL Server Native Client。(Microsoft/Windows Data Access Components aren't updated for these new features in SQL Server.) For new features beyond SQL Server 2012, SQL Server Native Client won't be updated. 如果要继续使用新的 SQL Server 功能,请切换到 Microsoft ODBC Driver for SQL Server 或 Microsoft OLE DB Driver for SQL Server。Switch to the Microsoft ODBC Driver for SQL Server or the Microsoft OLE DB Driver for SQL Server if you want to take advantage of new SQL Server features going forward.

有关 SQL Server Native Client 的完整文档,请参阅 SQL Server Native Client 文档For complete documentation of the SQL Server Native Client, see the SQL Server Native Client documentation.

Microsoft ODBC Driver for SQL ServerMicrosoft ODBC Driver for SQL Server

在 SQL Server 2012 之后,已经开发了主要的 ODBC Driver for SQL Server,并作为 Microsoft ODBC Driver for SQL Server 发布。After SQL Server 2012, the primary ODBC driver for SQL Server has been developed and released as the Microsoft ODBC Driver for SQL Server. 有关详细信息,请参阅 Microsoft ODBC Driver for SQL Server 文档For more information, see the Microsoft ODBC Driver for SQL Server documentation.

OLE DBOLE DB

有三个不同代的 Microsoft OLE DB Provider for SQL Server。There are three distinct generations of Microsoft OLE DB providers for SQL Server. 第一代“Microsoft OLE DB Provider for SQL Server”(SQLOLEDB) 仍作为 Windows 数据访问组件的一部分提供。The first "Microsoft OLE DB Provider for SQL Server" (SQLOLEDB) still ships as part of Windows Data Access Components. 将不会对此提供程序更新新功能,因此不建议将该驱动程序用于新开发。This provider won't be updated with new features and it isn't recommended to use this driver for new development. 从 SQL Server 2005 开始,SQL Server Native Client 将包含一个 OLE DB 提供程序接口 (SQLNCLI),并且它是 SQL Server 2005 至 SQL Server 2017 中随附的 OLE DB 提供程序。Starting in SQL Server 2005, the SQL Server Native Client includes an OLE DB provider interface (SQLNCLI) and is the OLE DB provider that shipped with SQL Server 2005 through SQL Server 2017. 于 2011 年宣布弃用,且不建议在新开发中使用此驱动程序。It was announced as deprecated in 2011 and it isn't recommended to use this driver for new development. 在 2017 年,OLE DB 数据访问技术随后被取消弃用,并宣布发布 2018 年新版的计划In 2017, OLE DB data access technology was later undeprecated and a new planned release was announced for 2018. 新的 OLE DB 提供程序被称为“Microsoft OLE DB Driver for SQL Server”(MSOLEDBSQL),目前对其提供维护和支持。The new OLE DB provider is called the "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL) and is currently maintained and supported.

ADO.NETADO.NET

ADO.NET 是一组类,用于定义用于访问任何类型的数据源(关系数据源和非关系数据源)的接口。ADO.NET is a set of classes that defines an interface for accessing any kind of data source, both relational and non-relational. ADO.NET 是随 Microsoft .NET Framework 引入的,并将在 .NET 中继续进行改进和维护。ADO.NET was introduced with the Microsoft .NET Framework and continues to be improved and maintained in .NET. SqlClient 库是一个 ADO.NET 数据提供程序,它提供与 SQL Server 和 Azure SQL 数据源的连接。The SqlClient library is an ADO.NET data provider that provides connectivity to SQL Server and Azure SQL data sources.

System.Data.SqlClientSystem.Data.SqlClient

System.Data.SqlClient 包含在 .NET Framework 和 .NET Core 中。System.Data.SqlClient is included as part of .NET Framework and .NET Core. 直到 2019 年,它都会接收定期功能更新。Up until 2019, it was receiving regular feature updates. 随着宣布将来的 .NET Core、.NET Framework常规 .NET,SqlClient 的开发需要移动到 .NET 以外的包。With the announcements of the future of .NET Core, .NET Framework, and .NET in general, development of SqlClient needed to shift to a package outside of .NET. System.Data.SqlClient 仍受支持,但不接收功能更新,因此不建议用于新开发。System.Data.SqlClient is still supported but isn't receiving feature updates and isn't recommended for new development.

Microsoft.Data.SqlClientMicrosoft.Data.SqlClient

于 2019 年引入的 Microsoft SqlClient Data Provider for SQL Server 是一个 ADO.NET 数据提供程序,支持面向 .NET Framework、.NET Core 和 .NET Standard 的应用程序。Introduced in 2019, the Microsoft SqlClient Data Provider for SQL Server is an ADO.NET data provider supporting applications that target .NET Framework, .NET Core, and .NET Standard. 有关 Microsoft.Data.SqlClient 命名空间的详细信息,请参阅用于 SQL Server 的 Microsoft ADO.NETFor more information about the Microsoft.Data.SqlClient namespace, see Microsoft ADO.NET for SQL Server.

JDBCJDBC

Microsoft JDBC Driver for SQL ServerMicrosoft JDBC Driver for SQL Server

Microsoft JDBC Driver for SQL Server 于 2000 年引入,将继续对其进行改进和维护。Introduced in 2000, the Microsoft JDBC Driver for SQL Server continues to be improved and maintained. 它在 2016 年已开放源代码。It was open-sourced in 2016. 有关最新信息(包括如何下载驱动程序),请参阅 JDBC 驱动程序概述For the latest information, including how to download the driver, see Overview of the JDBC Driver.

PHPPHP

Microsoft Drivers for PHP for SQL ServerMicrosoft Drivers for PHP for SQL Server

Microsoft Drivers for PHP for SQL Server 在 2009 年作为一个开源项目引入,将继续对其进行改进和维护。Introduced in 2009 as an open-source project, the Microsoft Drivers for PHP for SQL Server continue to be improved and maintained. 有关最新信息(包括如何下载 PHP 驱动程序),请参阅 Microsoft Drivers for PHP for SQL ServerFor the latest information, including how to download the PHP driver, see Microsoft Drivers for PHP for SQL Server.

Node.jsNode.js

适用于 SQL Server 的 Microsoft Node.JS 驱动程序Microsoft Driver for Node.js for SQL Server

Microsoft Driver for Node.js for SQL Server 允许 Microsoft Windows 和 Microsoft Azure 上的 Node.js 应用程序访问 Microsoft SQL Server 和 Microsoft Azure SQL 数据库。The Microsoft Driver for Node.js for SQL Server allows Node.js applications on Microsoft Windows and Microsoft Azure to access Microsoft SQL Server and Microsoft Azure SQL Database. 开发工作不再专注于此驱动程序。Development efforts are no longer being focused on this driver. 不建议使用 Microsoft Driver for Node.js for SQL Server 创建新应用程序。It isn't recommended to create new applications using the Microsoft Driver for Node.js for SQL Server.

有关 Microsoft Driver for Node.js for SQL Server 的详细信息,请参阅 WindowsAzure / node-sqlserverFor more information about the Microsoft Driver for Node.js for SQL Server, see WindowsAzure / node-sqlserver.

TediousTedious

Microsoft 目前致力于开发 Node.js 中的开源 Tedious 模块并提供支持,以便使用 JavaScript 连接到 SQL Server。Microsoft currently contributes to and supports the open-source tedious module in Node.js for connectivity to SQL Server using JavaScript. 有关详细信息,请参阅 Node.js Driver for SQL ServerFor more information, see Node.js Driver for SQL Server.

Microsoft 或 Windows 数据访问组件Microsoft or Windows Data Access Components

Microsoft/Windows 数据访问组件 (MDAC/WDAC) 随 Windows 一起提供并受其支持,以实现应用程序向后兼容性,它们不属于当前 SQL Server 技术堆栈。Microsoft/Windows Data Access Components (MDAC/WDAC) are shipped with and supported by Windows for application backwards compatibility and aren't part of the current SQL Server technology stack. 不会向 MDAC/WDAC 中的组件添加任何新功能,不建议将它们用于新的应用程序开发。No new features will be added to components in MDAC/WDAC and it isn't recommended to use them for new application development.

就本文档而言,可以根据技术和产品将 MDAC/WDAC 堆栈划分为以下组件:For the purposes of this document, you can divide the MDAC/WDAC stack into the following components, based on technology and products:

  • ADO(包括 ADOMD 和 ADOX)ADO (including ADOMD and ADOX)
  • OLE DB(包括 OLE DB 核心服务、SQL Server OLE DB 提供程序、Oracle OLE DB 提供程序、ODBC 驱动程序的 OLE DB 提供程序、数据形状提供程序以及远程数据提供程序)OLE DB (including OLE DB Core Services, SQL Server OLE DB Provider, Oracle OLE DB Provider, OLE DB Provider for ODBC Drivers, Data Shape Provider, and Remote Data Provider)
  • ODBC(包括 ODBC 驱动程序管理器、SQL ODBC 驱动程序和 Oracle ODBC 驱动程序)ODBC (including ODBC Driver Manager, SQL ODBC Driver, and Oracle ODBC Driver)

MDAC/WDAC 组件MDAC/WDAC components

MDAC/WDAC 包含以下组件:MDAC/WDAC includes these components:

  • ODBC: Microsoft 开放式数据库连接 (ODBC) 接口是一种 C 编程语言接口,它允许应用程序访问来自不同类型的数据库管理系统 (DBMS) 的数据。ODBC: The Microsoft Open Database Connectivity (ODBC) interface is a C programming-language interface that allows applications to access data from different kinds of Database Management Systems (DBMS). 使用此 API 的应用程序只能访问关系数据源。Applications that use this API are limited to accessing relational data sources only.
  • OLE DB: OLE DB 是一组 COM 接口,用于访问不同类型的数据存储中的数据。OLE DB: OLE DB is a set of COM interfaces for accessing data in different kinds of data stores. OLE DB 提供程序用于访问数据库、文件系统、消息存储、目录服务、工作流和文档存储中的数据。OLE DB providers exist for accessing data in databases, file systems, message stores, directory services, workflow, and document stores.
  • ADO: ActiveX 数据对象 (ADO) 提供了一个高级编程模型。ADO: ActiveX Data Objects (ADO) provides a high-level programming model. 尽管与直接编码到 OLE DB 或 ODBC 相比,ADO 的性能稍差,但它非常易于学习和使用。Although a little less performant than coding to OLE DB or ODBC directly, ADO is straightforward to learn and use. 可以从脚本语言(如 Microsoft Visual Basic Scripting Edition (VBScript) 或 Microsoft JScript)中使用它。It can be used from script languages, such as Microsoft Visual Basic Scripting Edition (VBScript) or Microsoft JScript.
  • ADOMD: ADO Multi-Dimensional (ADOMD) 将与多维数据提供程序(如 Microsoft OLAP 提供程序,也称为 Microsoft Analysis Services 提供程序)一起使用。ADOMD: ADO Multi-Dimensional (ADOMD) is to be used with multidimensional data providers such as Microsoft OLAP Provider, also known as Microsoft Analysis Services Provider. 自 MDAC 2.0 开始,未对其主要功能进行增强。No major feature enhancements have been made to it since MDAC 2.0.
  • ADOX: 使用 ADO Extensions for DDL and Security (ADOX),可以创建和修改数据库、表、索引或存储过程的定义。ADOX: ADO Extensions for DDL and Security (ADOX) enable the creation and modification of definitions of a database, table, index, or stored procedure. 可以将 ADOX 与任何提供程序一起使用。You can use ADOX with any provider. Microsoft Jet OLE DB Provider 完全支持 ADOX,而 Microsoft SQL Server OLE DB Provider 则提供有限的支持。The Microsoft Jet OLE DB Provider provides full support for ADOX, while the Microsoft SQL Server OLE DB Provider provides limited support.
  • Microsoft SQL Server 网络库: SQL Server 网络库允许 SQLOLEDB 和 SQLODBC 与 SQL Server 数据库通信。Microsoft SQL Server Network Libraries: The SQL Server Network Libraries allow SQLOLEDB and SQLODBC to communicate with the SQL Server database. 以下 SQL Server 网络库在 MDAC/WDAC 版本中已弃用:Banyan Vines、AppleTalk、ServerNet、IPX/SPX、Giganet 和 RPC。The following SQL Server Network Libraries have been deprecated in MDAC/WDAC releases: Banyan Vines, AppleTalk, ServerNet, IPX/SPX, Giganet, and RPC. TCP/IP 和命名管道将继续受支持,并且在 64 位 Windows 操作系统上可用。TCP/IP and Named Pipes will continue to be supported and are available on the 64-bit Windows operating system.
  • MSDASQL: Microsoft OLE DB Provider for ODBC (MSDASQL) 允许基于 OLE DB 和 ADO(在内部使用 OLEDB)生成的应用程序通过 ODBC 驱动程序访问数据源。MSDASQL: The Microsoft OLE DB Provider for ODBC (MSDASQL) allows applications that are built on OLE DB and ADO (which uses OLEDB internally) to access data sources through an ODBC driver. MSDASQL 是一个 OLEDB 提供程序,它连接到 ODBC 而不是数据库。MSDASQL is an OLEDB provider that connects to ODBC, instead of a database. 在没有直接的 OLE DB 提供程序用于数据源时,它将作为 OLE DB 与 ODBC 驱动程序之间的桥梁。It is meant as a bridge from OLE DB to an ODBC driver when no direct OLE DB provider exists for a data source. MSDASQL 随 Windows 操作系统一起提供,Windows Server 2008 和 Vista SP1 是首批包含该技术的 64 位版本的 Windows 版本。MSDASQL ships with the Windows operating system, and Windows Server 2008 and Vista SP1 were the first Windows releases to include a 64-bit version of the technology.

已弃用的 MDAC/WDAC 组件Deprecated MDAC/WDAC Components

MDAC/WDAC 的当前版本仍支持这些组件,但在将来的版本中可能会将其删除。These components are still supported in the current release of MDAC/WDAC, but they might be removed in future releases. 在开发新应用程序时,Microsoft 建议避免使用这些组件。When developing new applications, Microsoft recommends that you avoid using these components. 此外,在升级或修改现有应用程序时,请删除这些组件的任何依赖项。Additionally, when you upgrade or modify existing applications, remove any dependency on these components.

  • SQLOLEDB: 已弃用 Microsoft OLE DB Provider for SQL Server (SQLOLEDB),它支持对 Microsoft SQL Server 的访问。SQLOLEDB: The Microsoft OLE DB Provider for SQL Server (SQLOLEDB), which supports access to Microsoft SQL Server, has been deprecated. 可能不支持它与将来版本的 SQL Server 建立连接。Its connectivity to future versions of SQL Server may not be supported. 在 Windows 7 之后,将从操作系统中删除连接到 SQL Server 7 之前版本的功能。The ability to connect to versions earlier than SQL Server 7 will be removed from the operating system after Windows 7. 新应用程序应使用 Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL),该驱动程序支持新的 SQL Server 功能。New applications should use the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), which supports new SQL Server features. 现有应用程序也应迁移到 Microsoft OLE DB Driver for SQL Server,以提高性能、可靠性和可支持性。Existing applications should migrate to the Microsoft OLE DB Driver for SQL Server as well for better performance, reliability, and supportability. 有关详细信息,请参阅将应用程序从 MDAC 更新到 OLE DB Driver for SQL ServerFor more information, see Updating an Application to OLE DB Driver for SQL Server from MDAC.

  • SQLODBC: 已弃用 Microsoft SQL Server ODBC Driver (SQLODBC),它支持对 Microsoft SQL Server 的访问。SQLODBC: The Microsoft SQL Server ODBC Driver (SQLODBC), which supports access to Microsoft SQL Server, has been deprecated. 可能不支持它与将来版本的 SQL Server 建立连接。Its connectivity to future versions of SQL Server may not be supported. 在 Windows 7 之后,将从操作系统中删除连接到 SQL Server 7 之前版本的功能。The ability to connect to versions earlier than SQL Server 7 will be removed from the operating system after Windows 7. 新应用程序应使用 Windows 上的 Microsoft ODBC Driver for SQL Server,它支持新的 SQL Server 功能。New applications should use the Microsoft ODBC Driver for SQL Server on Windows, which supports new SQL Server features. 现有应用程序也应迁移到 Microsoft ODBC Driver for SQL Server,以提高性能、可靠性和可支持性。Existing applications should migrate to the Microsoft ODBC Driver for SQL Server as well for better performance, reliability, and supportability. 若要了解相关信息,请参阅将应用程序从 MDAC 更新到 SQL Server Native ClientFor relevant information, see Updating an Application to SQL Server Native Client from MDAC.

  • Microsoft Jet 数据库引擎 4.0: 从版本 2.6 开始,MDAC 不再包含 Jet 组件。Microsoft Jet Database Engine 4.0: Starting with version 2.6, MDAC no longer contains Jet components. 换句话说,MDAC 2.6、2.7 和 2.8 不包含 Microsoft Jet、Microsoft Jet OLE DB 提供程序、ODBC 桌面数据库驱动程序或 Jet 数据访问对象 (DAO)。In other words, MDAC 2.6, 2.7, and 2.8 don't contain Microsoft Jet, the Microsoft Jet OLE DB Provider, the ODBC Desktop Database Drivers, or Jet Data Access Objects (DAO).

    不提供 64 位版本的 Jet 数据库引擎、Jet OLEDB 驱动程序、Jet ODBC 驱动程序或 Jet DAO。There's no 64-bit version of the Jet Database Engine, the Jet OLEDB Driver, the Jet ODBC Drivers, or Jet DAO available. 有关详细信息,请参阅知识库文章 957570For more information, see KB article 957570. 在 64 位版本的 Windows 上,32 位 Jet 在 Windows WOW64 子系统下运行。On 64-bit versions of Windows, 32-bit Jet runs under the Windows WOW64 subsystem. 有关 WOW64 的详细信息,请参阅 MSDN WOW64 文档For more information on WOW64, see the MSDN WOW64 documentation. 本机 64 位应用程序不能与在 WOW64 中运行的 32 位 Jet 驱动程序通信。Native 64-bit applications cannot communicate with the 32-bit Jet drivers running in WOW64.

    在开发需要关系数据存储的新的非 Microsoft Access 应用程序时,Microsoft 建议使用 Microsoft SQL Server Express Edition 来替代 Microsoft Jet。Instead of Microsoft Jet, Microsoft recommends using Microsoft SQL Server Express Edition when developing new, non-Microsoft Access applications requiring a relational data store. 这些新的或转换后的 Jet 应用程序可以继续使用 Jet,目的是将 Microsoft Office 2003 文件及更低版本的文件(.mdb 和 .xls)用于非主要数据存储。These new or converted Jet applications can continue to use Jet with the intention of using Microsoft Office 2003 and earlier files (.mdb and .xls) for non-primary data storage. 但是,对于这些应用程序,应计划从 Jet 迁移到 Microsoft Access 数据库引擎。However, for these applications, you should plan to migrate from Jet to the Microsoft Access Database Engine. 可以下载 Microsoft Access 数据库引擎,它可便于对已有 Office 2003(.mdb 和.xls)或 Office 2007(.accdb、.xlsm、*.xlsx 和 *.xlsb)文件执行读取和写入操作。You can download the Microsoft Access Database Engine, which allows you to read from and write to pre-existing files in either Office 2003 (.mdb and .xls) or the Office 2007 (*.accdb, *.xlsm, *.xlsx and *.xlsb) file formats.

    重要

    请阅读“2007 Office System 最终用户许可协议”,了解具体的使用限制。Please read the 2007 Office System End User License Agreement for specific usage limitations.

    备注

    通过 2007 Office System 驱动程序,SQL Server 应用程序还可以访问来自 SQL Server 异类数据连接和 Integration Services 功能的 2007 Office System 以及更早版本的文件。SQL Server applications can also access the 2007 Office System, and earlier, files from SQL Server heterogeneous data connectivity and Integrations Services capabilities as well, via the 2007 Office System Driver. 另外,通过在 64 位 Windows 上使用 32 位 SQL Server Integration Services (SSIS),64 位 SQL Server 应用程序可以访问 32 位 Jet 和 2007 Office System 文件。Additionally, 64-bit SQL Server applications can access to 32-bit Jet and 2007 Office System files by using 32-bit SQL Server Integration Services (SSIS) on 64-bit Windows.

  • Microsoft OLE DB Provider for Data Shaping (MSDADS): 使用 MSDADS,可以在应用程序中的键、字段或行集之间创建层次结构关系。Microsoft OLE DB Provider for Data Shaping (MSDADS): With MSDADS, you can create hierarchical relationships between keys, fields, or rowsets in an application. 自 MDAC 2.1 开始,未对主要功能进行增强。No major feature enhancements have been made since MDAC 2.1. 已弃用此提供程序。This Provider has been deprecated. Microsoft 建议使用 XML 替代 MSDADS。Microsoft recommends that you use XML, instead of MSDADS.

  • Oracle ODBC 和 Oracle OLE DB: Microsoft Oracle ODBC 驱动程序 (Oracle ODBC) 和 Oracle 的 Microsoft OLE DB 提供程序 (Oracle OLE DB) 提供对 Oracle 数据库服务器的访问。Oracle ODBC and Oracle OLE DB: The Microsoft Oracle ODBC Driver (Oracle ODBC) and Microsoft OLE DB Provider for Oracle (Oracle OLE DB) provide access to Oracle database servers. 它们是使用 Oracle Call Interface (OCI) 版本 7 生成的,并为 Oracle 7 提供完全支持。They're built by using Oracle Call Interface (OCI) version 7 and provide full support for Oracle 7. 此外,它还使用 Oracle 7 仿真为 Oracle 8 数据库提供有限的支持。Also, it uses Oracle 7 emulation to provide limited support for Oracle 8 databases. Oracle 不再支持使用 OCI 版本 7 调用的应用程序。Oracle no longer supports applications that use OCI version 7 calls. 这些技术已弃用。These technologies are deprecated. 如果你使用的是 Oracle 数据源,应迁移到 Oracle 提供的驱动程序和提供程序。If you're using Oracle data sources, you should migrate to Oracle-supplied driver and provider.

  • 远程数据服务 (RDS): RDS 是一种 Microsoft 专有机制,用于通过 Internet 或 Intranet 访问远程 ADO 记录集对象。Remote Data Services (RDS): RDS is a proprietary Microsoft mechanism for accessing remote ADO Recordset objects across the Internet or an Intranet. RDS 已弃用;自 MDAC 2.1 开始,未对 RDS 的主要功能进行增强。RDS is deprecated; no major feature enhancements have been made to RDS since MDAC 2.1. Microsoft 已发布 .NET Framework,它具有广泛的 SOAP 功能并替换了 RDS 组件。Microsoft has released the .NET Framework, which has extensive SOAP capabilities and replaces RDS components. 在 Windows 7 之后,所有 RDS 服务器组件都将从操作系统中删除。All RDS server components will be removed from the operating system after Windows 7.

  • Jet 复制对象 (JRO): JRO 已弃用。Jet Replication Objects (JRO): JRO is deprecated. JRO 在 ADO 中与 Jet ( .mdb) 数据库结合使用,创建和压缩 Jet 数据库 (.mdb) 并执行 Jet 复制管理。MDAC 2.7 将是它的最后一个版本。JRO 在 64 位 Windows 操作系统上不可用。Microsoft Access 2007 文件格式 ( .accdb) 不支持 JRO。JRO is used within ADO with Jet (.mdb) databases to create and compress Jet Databases (.mdb's) and perform Jet Replication Management. MDAC 2.7 will be its last release. JRO won't be available on the 64-bit Windows operating system. JRO isn't supported in the Microsoft Access 2007 file format (.accdb).

  • 16 位 ODBC 支持: 如果你使用的是 16 位应用程序,应迁移到 32 位应用程序。16-bit ODBC Support: If you're using 16-bit applications, you should migrate to a 32-bit application. 16 位功能已弃用,将从 64 位操作系统中删除。16-bit functionality is deprecated and is being removed from 64-bit operating systems. 有关详细信息,请参阅知识库文章 896458For more information, see Knowledge base article 896458.

  • OLEDB 简单提供程序 (MSDAOSP): OLEDB 简单提供程序提供了一个框架,用于基于简单数据快速生成 OLE DB 提供程序。OLEDB Simple Provider (MSDAOSP): OLEDB Simple Provider offers a framework for quickly building OLE DB providers over simple data. MSDAOSP 已弃用。MSDAOSP is deprecated.

  • ODBC 游标库: ODBC 游标库 (ODBCCR32.dll) 提供有限的客户端数据游标。ODBC Cursor Library: ODBC Cursor Library (ODBCCR32.dll) provides limited client-side data cursors. ODBC 游标库已弃用;应用程序可以使用服务器端游标实现作为替代方法。ODBC Cursor Library has been deprecated; your application can use server-side cursor implementations as a replacement.

  • OLE DB 进程外接口远程处理: OLEDB 接口远程处理 (msdaps.dll) 用于尝试允许 OLE DB 提供程序在进程外运行。OLE DB Out-of-Process Interface Remoting: OLEDB Interface remoting (msdaps.dll) was an attempt to allow OLE DB providers to run out of process. OLEDB 进程外接口远程处理已弃用。OLEDB Out-of-Process Interface remoting is deprecated.

  • AppleTalk 和 Banyan Vines SQL 网络库: Banyan Vines、AppleTalk、ServerNet、IPX/SPX、Giganet 和 RPC SQL 网络库已弃用。AppleTalk and Banyan Vines SQL Network Libraries: The Banyan Vines, AppleTalk, ServerNet, IPX/SPX, Giganet, and RPC SQL network libraries are deprecated. 如果你正在使用其中任何一项技术,应修改应用程序,使其使用其他网络库,如 TCP/IP 和命名管道。If you're using any of these technologies, you should modify your applications to use one of the other network libraries, such as TCP/IP and Named Pipe.

MDAC/WDAC 版本MDAC/WDAC Releases

下面是过去 MDAC/WDAC 版本的可支持性方案列表,从最早版本开始。Here's a list of the supportability scenarios of past MDAC/WDAC releases, starting with the earliest.

  • MDAC 1.5、MDAC 2.0 和 MDAC 2.1: 这些版本的 MDAC 为独立版本,通过 Microsoft Windows NT 可选包、Microsoft Windows 平台 SDK 或 MDAC 网站发布。MDAC 1.5, MDAC 2.0, and MDAC 2.1: These versions of MDAC were independent releases that were released through the Microsoft Windows NT Option Pack, the Microsoft Windows Platform SDK, or the MDAC Web site. 不再支持这些 MDAC 版本。These versions of MDAC are no longer supported.

  • MDAC 2.5: 此版本的 MDAC 随 Windows 2000 操作系统一起提供。MDAC 2.5: This version of MDAC was included with the Windows 2000 operating system. MDAC 2.5 的服务包随相应的 Windows 2000 服务包一起提供。Service packs of MDAC 2.5 were included with corresponding Windows 2000 service packs.

  • MDAC 2.6: MDAC 2.6 RTM、SP1 和 SP2 分别随 Microsoft SQL Server 2000 RTM、SP1 和 SP2 一起提供。MDAC 2.6: MDAC 2.6 RTM, SP1, and SP2 were included with Microsoft SQL Server 2000 RTM, SP1, and SP2, respectively. 此外,这些 MDAC 服务包已按照 Microsoft SQL Server 2000 服务包发布计划发布到 MDAC 网站。Additionally, these MDAC service packs were released to the MDAC Web site following the Microsoft SQL Server 2000 service-pack release schedule. 可以在 Windows 2000、Windows Millennium Edition、Windows NT、Windows 95 和 Windows 98 平台上安装此版本的 MDAC 及其服务包。You can install this version of MDAC and its service packs on Windows 2000, Windows Millennium Edition, Windows NT, Windows 95, and Windows 98 platforms. 不再支持此版本的 MDAC。This version of MDAC no longer is supported.

  • MDAC 2.7: 此版本的 MDAC 随 Microsoft Windows XP RTM 和 SP1 操作系统一起提供。MDAC 2.7: This version of MDAC was included with the Microsoft Windows XP RTM and SP1 operating systems. 可以在 Windows 2000、Windows Millennium、Windows NT 和 Windows 98 平台上安装此版本的 MDAC 及其服务包。You can install this version of MDAC and its service packs on Windows 2000, Windows Millennium, Windows NT, and Windows 98 platforms. 只能通过操作系统或其服务包在 Windows XP 平台上安装此版本。You can install this version on the Windows XP platform only through the operating system or its services packs. 不再支持此版本的 MDAC。This version of MDAC no longer is supported.

  • MDAC 2.8: 此版本的 MDAC 随 Windows Server 2003 和 Windows XP SP2 及更高版本一起提供。MDAC 2.8: This version of MDAC was included with Windows Server 2003 and Windows XP SP2 and later. 也可以在 Windows 2000 上安装此版本的 MDAC 及其服务包。You also can install this version of MDAC and its service packs on Windows 2000.

    • 向客户发布 Windows Server 2003 的同时,也会在 MDAC 网站上发布 32 位版本的 MDAC 2.8。The 32-bit version of MDAC 2.8 also was released to the MDAC Web site at the same time that Windows Server 2003 was released to the customer.
    • 64 位版本的 MDAC 2.8 随 64 位版本的 Windows Server 2003 和 Windows XP 一起发布。The 64-bit version of MDAC 2.8 was released with the 64-bit version of Windows Server 2003 and Windows XP.
  • Windows 数据访问组件 (WDAC): 从 Windows Vista 和 Windows Server 2008 开始,MDAC 将其名称更改为 WDAC -“Windows 数据访问组件”。Windows Data Access Components (WDAC): MDAC changed its name to WDAC - "Windows Data Access Components" starting with Windows Vista and Windows Server 2008. WDAC 是操作系统的一部分,不能单独用于重新分发。WDAC is included as part of the operating system and isn't available separately for redistribution. WDAC 的可维护性取决于操作系统的生命周期。Serviceability for WDAC is subject to the life cycle of the operating system.

    32 位和 64 位版本的 WDAC 分别随 32 位和 64 位版本的 Windows 操作系统一起发布。32-bit and 64-bit versions of WDAC are released with the 32-bit and 64-bit versions of the Windows operating systems, respectively.

过时的数据访问技术Obsolete data access technologies

过时的技术是指一些产品版本中未进行增强或更新的那些技术,这些技术将不包含在以后的产品版本中。Obsolete technologies are technologies that have not been enhanced or updated in several product releases and that will be excluded from future product releases. 编写新应用程序时,请勿使用这些技术。Don't use these technologies when you write new applications. 修改使用这些技术编写的现有应用程序时,请考虑将这些应用程序迁移到 ADO.NET 或其他当前技术。When you modify existing applications that are written by using these technologies, consider migrating those applications to ADO.NET or another current technology.

以下组件被认为过时组件:The following components are considered obsolete:

  • DB-Library: DB-Library 是一种特定于 SQL Server 的编程模型,其中包含 C API。DB-Library: DB-Library is a SQL Server-specific programming model that includes C APIs. 自 SQL Server 6.5 起,未增强 DB-LIBRARY 的任何功能。There have been no feature enhancements to the DB-Library since SQL Server 6.5. 它的最终版本是与 SQL Server 2000 一起发布的,不会将其移植到 64 位 Windows 操作系统。Its final release was with SQL Server 2000, and it won't be ported to the 64-bit Windows operating system.
  • 嵌入式 SQL (E-SQL): E-SQL 是一种特定于 SQL Server 的编程模型,使用它可以在 Visual C 代码中嵌入 Transact-SQL 语句。Embedded SQL (E-SQL): E-SQL is a SQL Server-specific programming model that enables Transact-SQL statements to be embedded in Visual C code. 自 SQL Server 6.5 起,未增强 E-SQL 的任何功能。No feature enhancements have been made to the E-SQL since SQL Server 6.5. 它的最终版本是与 SQL Server 2000 一起发布的,不会将其移植到 64 位 Windows 操作系统。Its final release was with SQL Server 2000, and it won't be ported to the 64-bit Windows operating system.
  • 数据访问对象 (DAO): DAO 提供对 JET (Access) 数据库的访问。Data Access Objects (DAO): DAO provides access to JET (Access) databases. 可以从 Microsoft Visual Basic、Microsoft Visual C++ 和脚本语言中使用此 API。This API can be used from Microsoft Visual Basic, Microsoft Visual C++, and scripting languages. 它随 Microsoft Office 2000 和 Office XP 一起提供。It was included with Microsoft Office 2000 and Office XP. DAO 3.6 是此技术的最后一个版本。DAO 3.6 is the final version of this technology. 它在 64 位 Windows 操作系统上不可用。It won't be available on the 64-bit Windows operating system.
  • 远程数据对象 (RDO): RDO 专门用于访问远程 ODBC 关系数据源,无需复杂的应用程序代码即可更轻松使用 ODBC。Remote Data Objects (RDO): RDO was designed specifically to access remote ODBC relational data sources, and made it easier to use ODBC without complex application code. 它随 Microsoft Visual Basic 版本 4、5 和 6 一起提供。It was included with Microsoft Visual Basic versions 4, 5, and 6. RDO 版本 2.0 是此技术的最后一个版本。RDO version 2.0 was the final version of this technology.

获取帮助

参与编辑 SQL 文档

你是否知道你可以自己编辑内容?Did you know that you could edit the content yourself? 这样做不仅可以改进我们的文档,还可以获得页面贡献者的殊荣。If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.