What is ADO ?
ActiveX Data Objects (ADO) enables you to write an application to access and manipulate data in a database server through an OLE DB provider. ADO s primary benefits are high speed, ease of use, low memory overhead, and a small disk footprint. ADO supports key features for building client/server and web-based applications, including the following: • Independently-created objects. Unlike Data Access Objects (DAO) or Remote Data Objects (RDO), you no longer have to navigate through a hierarchy to create objects because most ADO objects can be independently created. This allows you to create and track only the objects you need, and also results in fewer ADO objects and thus a smaller working set. • Batch updating helps improve performance by locally caching changes to data, then writing them all to the server in a single update. • Support for stored procedures with in/out parameters and return values. • Different cursor types, including the potential for support of back-end specific cursor
