OLEDB API Calls

What is OLE DB? OLE DB is a specification. It is not a set of components or files. It defines the way that a consumer, the client who is retrieving the data, talks to a provider, the server who is supplying the data. The provider is a COM object which is created by calling CoCreateInstance()…

1

OLE DB Resource Pooling

OLE DB resource pooling, also known as OLE DB session pooling, is handled by the OLE DB core components. To take advantage of resource pooling, an OLE DB consumer must invoke the data provider by using either the IDataInitialize or the IDBPromptInitialize interface. (ADO will attempt to do this automatically.) OLE DB resource pooling can…

1

ADO Overview and Architecture

ADO is the most popular and well-known of Microsoft’s Data Access API’s. ADO is, like OLEDB, a COM object model for accessing, retrieving and updating data. Unlike OLE DB, however, ADO objects expose OLE Automation interfaces, allowing them to be accessed not only from C++, but also languages such as Visual Basic, and even from…

1

MSDASQL – OLEDB Provider for ODBC drivers

As mentioned before, a provider is needed for any data source that is to be exposed through OLE DB. Microsoft releases providers for several common data sources, including SQL Server, Oracle, and Jet. In addition, Microsoft ships a special provider called the “OLE DB Provider for ODBC Drivers”. This was the very first OLE DB…

0

OLE DB Programming Overview and Architecture

OLE DB is a COM based object model used for access to various relational data sources as well as structured, not relational data (such as folders in an email store, or a file system). This ability to access both relational and structured data is one of the major features that sets OLE DB apart from…

0