Object Linking and Embedding Database (OLE DB) is a group of APIs used to facilitate and abtract access to application data of different file formats, including spreadsheets, structured query language (SQL)-based database management systems (DBMS), indexed-sequential files, and personal databases.
OLE DB is based on the Component Object Model (COM) and is part of the Microsoft Data Access Components (MDAC) software package, which is used to read and write data.
The OLE DB object model components are data source objects (DSO), command objects, rowset objects and session objects. OLE DB uses abstraction sets to segregate stored application data, because different programs require access to different DSO types.
OLE DB classifications are:
- Consumers: Applications requiring data access
- Providers: Software components that supply consumer data by using OLE DB APIs
When requesting OLE DB data, an application follows this sequence:
- Initialize the OLE.
- Establish a connection to the data’s source.
- Use a command to request access.
- Process the application query to acquire request results.
- Provide the requested DSO.