OLE DB Templates, Attributes, and Other Implementations


The new home for Visual Studio documentation is Visual Studio 2017 Documentation on docs.microsoft.com.

The latest version of this topic can be found at OLE DB Templates, Attributes, and Other Implementations.

ATL OLE DB Templates
The OLE DB Templates, which are part of ATL (Active Template Library), make the high-performance OLE DB database technology easier to use by providing classes that implement many of the commonly used OLE DB interfaces. Along with this template library comes wizard support for creating OLE DB starter applications.

This template library contains two parts:

  • OLE DB Consumer Templates Used to implement an OLE DB client (consumer) application.

  • OLE DB Provider Templates Used to implement an OLE DB server (provider) application.

To use the OLE DB Templates, you should be familiar with C++ templates, COM, and the OLE DB interfaces. If you are not familiar with OLE DB, see OLE DB Programmer's Reference.

For more information, you can:

The OLE DB consumer attributes provide a convenient way to create OLE DB consumers. The OLE DB attributes inject code based on the OLE DB consumer templates to create working OLE DB consumers and providers. If you need to specify functionality not supported by the attributes, you can use the OLE DB Templates in conjunction with attributes in your code.

The MFC library has one class, COleDBRecordView, that displays database records in controls. The view is a form view directly connected to a CRowset object and displays the fields of the CRowset object in the dialog template's controls. It also supplies a default implementation for moving to the first, next, previous, or last record and an interface for updating the record currently on view. For more information, see COleDBRecordView.

In the cases where the OLE DB Templates do not support OLE DB functionality, you need to use the OLE DB interfaces themselves. For more information, see OLE DB Programmer's Reference in the Windows SDK.

OLE DB Programming
OLE DB Programming Overview