OLE DB Programmer's Guide

The OLE DB Programmer's Guide is divided into the following parts:

  • Introduction to OLE DB provides conceptual material.

  • OLE DB Core provides a discussion of OLE DB services and OLE DB core components.

  • OLE DB for OLAP provides conceptual material relating to OLE DB for OLAP.

  • OLE DB Reference describes all of the OLE DB interfaces, including Core, OLE DB, and OLAP.

  • Appendixes provides detailed information about topics such as data types and properties. Appendix F is a listing of the code for the sample OLE DB consumer application that is used for examples throughout the programmer's reference.

The OLE DB Glossary defines terms you will need to understand to work with OLE DB.

Links to related information are included for easier navigation, as well as new interfaces, data types, schema rowsets, and properties.

Working with the OLE DB Documentation

This documentation assumes the following:

  • A working knowledge of the C or C++ programming language

  • Knowledge of COM

In addition, a general knowledge of databases and SQL is helpful.

The code examples in this documentation are designed for illustration purposes only. Because they are written primarily to demonstrate OLE DB principles, efficiency has sometimes been set aside in the interest of clarity. In addition, whole sections of code have sometimes been omitted for clarity. These include the definitions of non?OLE DB functions and most error handling.

The following table explains the typographic conventions used in this documentation.


Used for


Uppercase letters indicate certain values, property names, SQL statements, and macro names.

#include <oledb.h>

Monospace font is used for sample command lines and program code.


Italicized words indicate programmatic arguments, information that the user or the application must provide, or word emphasis.


Bold type indicates that syntax must be typed exactly as shown, including interface and method names.

See Also

Other Resources

Microsoft OLE DB