什么是ADO,ADO和OLE DB、ODBC到底是什么关系,本人在查找MSDN时找到本文,内容虽然比较简单,但比较清晰,第一次翻译,错误之处请大家多多指正。
The Role of ADO in Microsoft Data Access
ADO在MICROSOFT DATA ACCESS 中的角色
The Microsoft Data Access Components (MDAC) provide data access that is independent of data stores, tools, and languages. It provides a high-level, easy-to-use interface, and a low-level, high-performance interface to practically any data store available. You can use this flexibility to integrate diverse data stores and use your choice of tools, applications, and platform services to create the right solutions for your needs. These technologies provide the basic framework for general-purpose data access in Microsoft? Windows? operating systems.
MDAC提供独立于数据源、工具和语言的数据访问。它提供了一个高级、简单的接口和一个低级但高效的接口来访问几乎所有可用的数据源。你可以用它提供的灵活性来整合不同的数据源并结合你选择的工具、应用程序和平台服务来为你的需求建立正确的解决方案。这些技术提供了一个基于WINDOWS操作系统的面向多用途的数据访问框架。
There are three primary technologies in MDAC. ActiveX Data Objects (ADO) is a high-level, easy-to-use interface to OLE DB.OLE DB is a low-level, high-performance interface to a variety of data stores. ADO and OLE DB both can work with relational(tabular) and nonrelational (hierarchical or stream) data. Finally, Open Database Connectivity (ODBC) is another low-level, high-performance interface that is designed specifically for relational data stores.
在MDAC中主要有三种技术,ADO提供了面向OLE DB的高级,简单的接口。OLE DB提供了面向不同数据源的低级但高效的接口。ADO和OLE DB都可以访问关系型(如表)和非关系型(层次或流)的数据。最后,ODBC是另一种被设计成专门面向关系型数据的低级但高效的接口。
ADO provides a layer of abstraction between your client or middle-tier application and the low-level OLE DB interfaces. ADOuses a small set of Automation objects to provide a simple and efficient interface to OLE DB. This interface makes ADO the perfect choice for developers in higher level languages, such as Visual Basic and even VBScript, who want to access datawithout having to learn the intricacies of COM and OLE DB.
ADO 在你的客户端或中间层应用程序和低级的OLE DB 接口之间提供了一个抽象层。ADO 利用一个小的自动化对象集来提供一个简单而有效的访问OLE DB的接口。这个接口使ADO成为高级语言使用者的首选,例如VISUAL BASIC和VBSCRIPT,使用者不需要通过学习复杂的COM和OLE DB知识来访问数据。