Contents Index The ADO.NET programming interface The Embedded SQL programming interface

ASA Programming Guide
  Programming Interface Overview

The OLE DB and ADO programming interface


OLE DB is a set of Component Object Model (COM) interfaces developed by Microsoft, which provide applications with uniform access to data stored in diverse information sources and which also provide the ability to implement additional database services. These interfaces support the amount of DBMS functionality appropriate to the data store, enabling it to share its data.

ADO is an object model for programmatically accessing, editing, and updating a wide variety of data sources through OLE DB system interfaces. ADO is also developed by Microsoft. Most developers using the OLE DB programming interface do so by writing to the ADO API rather than directly to the OLE DB API.

Adaptive Server Anywhere includes an OLE DB provider for OLE DB and ADO programmers.

The primary documentation for OLE DB and ADO programming is the Microsoft Developer Network. The current book provides some additional notes specific to Adaptive Server Anywhere for OLE DB and ADO developers.

The OLE DB provider is described in The OLE DB and ADO Programming Interfaces.

Do not confuse the ADO interface with ADO.NET. ADO.NET is a separate interface. For more information, see The ADO.NET programming interface.


Contents Index The ADO.NET programming interface The Embedded SQL programming interface