Microsoft Windows Architecture for Developers Training Kit
ADO Summary
There are advantages and disadvantages to using ADO.
Advantages
The advantages of using ADO include:
- A unified standard
The ADO model strives to expose everything that the underlying data provider can do, while still adding value by providing shortcuts for common operations.
- Extensibility
In the future, ADO will become a superset of RDO.
- COM interface
Because ADO is a COM-based component, any application or language capable of working with COM objects can use itincluding Visual Basic. At this time there is no licensing restriction for ADO.
- Active Server Pages
ADO scripts are written with Microsoft Visual Basic Scripting edition.
Disadvantages
The disadvantages of using ADO include:
- Not yet fully developed.
- It is a higher level interface than OLE DB