The OLE DB API consists of a set of interfaces. Table 1-1 describes the support for each interface in the Adaptive Server OLE DB Provider.
Interface |
Purpose |
Limitations |
|---|---|---|
IAccessor |
Define bindings between client memory and data store values. |
DBACCESSOR_PASSBYREF not supported. DBACCESSOR_OPTIMIZED not supported. |
IColumnsInfo |
Get simple information about the columns of a rowset. |
N/A. |
IColumnsRowset |
Get information about optional metadata columns in a rowset, and get a rowset of column metadata. |
N/A. |
ICommand |
Execute SQL commands. |
To find properties that could not have been set, it does not support calling ICommandProperties: GetProperties with DBPROPSET_PROPERTIESINERROR. |
ICommandPrepare |
Prepare commands. |
N/A. |
ICommandProperties |
Set Rowset properties for rowsets created by a command. Most commonly used to specify the interfaces the rowset should support. |
N/A. |
ICommandText |
Set the SQL command text for ICommand. |
Only the DBGUID_DEFAULT SQL dialect is supported. |
ICommandWithParameters |
Set or get parameter information for a command. |
No support for parameters stored as vectors of scalar values. |
IConvertType |
N/A. |
|
IDBCreateCommand |
Create commands from a session. |
N/A. |
IDBCreateSession |
Create a session from a data source object. |
N/A. |
IDBInfo |
Find information about keywords unique to this provider (that is, find nonstandard SQL keywords). Also, find information about literals, special characters used in text matching queries, and other literal information. |
N/A. |
IDBInitialize |
Initialize data source objects and enumerators. |
N/A. |
IDBProperties |
Manage properties on a data source object or enumerator. |
N/A. |
IDBSchemaRowset |
Get information about system tables, in a standard form (a rowset). |
N/A. |
IErrorLookup IErrorRecords |
Support ActiveX error object. |
N/A. |
IGetDataSource |
Return an interface pointer to the session's data source object. |
N/A. |
IMultipleResults |
Retrieve multiple results (rowsets or row counts) from a command. |
N/A. |
IOpenRowset |
Access a database table by its name, in a non-SQL way. |
Opening a table by its name is supported, not by a GUID. |
IRowset |
Access rowsets. |
N/A. |
IRowsetChange, IRowsetUpdate |
Allow changes to rowset data, reflected back to the data store. InsertRow/SetData for blobs not yet implemented. |
N/A. |
IRowsetIdentity |
Compare row handles. |
N/A. |
ISequentialStream |
Retrieve a blob column. |
Supported for reading only. No support for SetData with this interface. |
ISessionProperties |
Get session property information. |
N/A. |
ISourcesRowset |
Get a rowset of data source objects and enumerators. |
N/A. |
ITableDefinition |
Create, drop, and alter tables, with constraints. |
N/A. |
ITransaction |
Commit or abort transactions. |
Not all the flags are supported. |
ITransactionLocal |
Handle transactions on a session. Not all the flags are supported. |
N/A. |
