Supported OLE DB Interfaces

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, write a fully functional OLE DB provider using the native OLE DB interfaces.

Data Source Object

Interface	Description
IConnectionPointContainer	When implemented on an object, makes the object connectable and expresses the existence of outgoing interfaces on the object. Through this interface a client can either locate a specific connection point for one IID or enumerate the connection points that exist. This is a COM interface, not an OLE DB interface. For more information, refer to the OLE DB Programmer's Reference.
IDBAsynchStatus	Polls for status or cancels the asynchronous operation on the object being initialized, generated, or populated.
IDBCreateSession	Used by consumers to create a new session on a data source object.
IDBInitialize	Initializes a data source object or enumerator.
IDBProperties	Sets and gets the values of properties on the data source object or enumerator and gets all information about all properties supported by the provider.
IPersist	An interface that is implemented by object applications and used by container applications to get the CLSID associated with an object.
ISupportErrorInfo	Indicates whether a specific interface can return COM and OLE DB error objects.

Session Object

Interface	Description and Notes
IGetDataSource	Mandatory interface on the session for obtaining a data source object.
IOpenRowset	Enables consumers to open and work directly with individual tables or indexes in a data source. When using IOpenRowset::OpenRowset against an OLE DB provider written with the OSP Toolkit, you can issue OpenRowset only once for each OSP. The second call will fail with a status code of E_FAIL. If no data member is specified on IOpenRowset::OpenRowset ? because no registration settings have been entered, or because no data source initialization property has been set ? Msdaosp.dll returns the error DB_E_NOTABLE, which indicates that the table does not exist in the current data source.
ISessionProperties	Performs row updates, deletes, and inserts.
ISupportErrorInfo	Indicates whether a specific interface can return Automation and OLE DB error objects.

Rowset Object

Interface	Description
IAccessor	Provides methods for accessor management.
IColumnsInfo	Exposes information about columns of a rowset. (See Note below.)
IConnectionPointContainer	When implemented on an object, makes the object connectable and expresses the existence of outgoing interfaces on the object. Through this interface a client can either locate a specific connection point for one IID or enumerate the connection points that exist. This is a COM interface, not an OLE DB interface. For more information, refer to the OLE DB Programmer's Reference.
IConvertType	Provides information about the availability of type conversions on a rowset.
IDBAsynchStatus	Polls for status or cancels the asynchronous operation on the object being initialized, generated, or populated.
IRowset	Provides methods for fetching rows sequentially, getting the data from those rows, and managing the rows.
IRowsetChange	Performs row updates, deletes, and inserts.
IRowsetFind	Allows consumers to find a row within the rowset matching a specified value.
IRowsetIdentity	Indicates that row instance identity is implemented on the rowset and enables testing for row identity.
IRowsetInfo	Provides information about a rowset.
IRowsetLocate	Fetches arbitrary rows of a rowset.
IRowsetScroll	Enables consumers to fetch rows at approximate positions in the rowset.
ISupportErrorInfo	Indicates whether a specific interface can return Automation and OLE DB error objects.

Note

The OSP implementation of the IColumnsInfo::GetColumnInfo method initializes DBCOLUMNSINFO structures as follows.

For the bookmark column:

Column ID (DBID) ? As described in the section Bookmarks, where DBID.eKind is set to DBKIND_GUID_PROPID

wType ? DBTYPE_I4 for a 32-bit OS, or DBTYPE_I8 for a 64-bit OS

uColumnSize ? DBBKMARK, which is 4 for a 32-bit OS, or 8 for a 64-bit OS

bPrecision ? 10

bScale ? ~0 (all ones; no scale)

dwFlags ? DBCOLUMNFLAGS_ISBOOKMARK | DBCOLUMNFLAGS_ISFIXEDLENGTH | DBCOLUMNFLAGS_MAYDEFER

For all other columns:

iOrdinal ? A number starting from 1

DBID.eKind ? DBKIND_PROPID

DBID.uName.ulPropid ? A number equal to 100+iOrdinal

wType ? DBTYPE_VARIANT

ulColumnSize ? The size of a VARIANT (16)

bPrecision ? ~0 (all ones; no precision)

bScale ? ~0 (all ones; no scale)

dwFlags ? DBCOLUMNFLAGS_ISFIXEDLENGTH | DBCOLUMNFLAGS_MAYDEFER | DBCOLUMNFLAGS_MAYBENULL | DBCOLUMNFLAGS_ISNULLABLE

If the OSP getRWStatus method reports the column is not OSPRW_READONLY, dwFlags is also marked DBCOLUMNFLAGS_WRITE.

If the column is a chapter column, wType is set to DBTYPE_HCHAPTER, dwFlags is marked DBCOLUMNFLAGS_ISCHAPTER, and ulColumnSize is set to the size of a pointer to IUnknown.

The column name is stored in **ppStringsBuffer.

Notification Interfaces for Rowset Object

Interface	Description
IDBAsynchNotify	The callback interface that a consumer must support to be notified of the progress of asynchronous operations such as initializing a data source object or opening or populating a rowset.
IRowsetNotify	The callback interface that a consumer must support to connect to local notifications provided by a rowset.