Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

OLE-DB Data Providers

Architecture Diagram


What is OLE-DB?

OLE-DB is a set of COM-based interfaces that expose data from a variety of sources. OLE-DB interfaces provide applications with uniform access to data stored in diverse information sources, or data stores. These interfaces support the amount of DBMS functionality appropriate to the data store, enabling the data store to share its data.

Why use OLE-DB?

To take advantage of the benefits of database technology, such as declarative queries, transactions, and security, businesses have traditionally had to move the data from its original containing system into some type of database management system (DBMS). This process is expensive and redundant. Furthermore, businesses need to be able to exploit the advantages of database technology not only when accessing data within a DBMS but also when accessing data from any other type of information container. To address this need, Microsoft created OLE-DB.