The OLE DB API consists of a set of interfaces. The following table describes the support for each interface in the ASE 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. |
NA |
IColumnsRowset |
Get information about optional metadata columns in a rowset, and get a rowset of column metadata. |
NA |
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. |
NA |
ICommandProperties |
Set Rowset properties for rowsets created by a command. Most commonly used to specify the interfaces the rowset should support. |
NA |
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 |
NA |
|
IDBCreateCommand |
Create commands from a session. |
NA |
IDBCreateSession |
Create a session from a data source object. |
NA |
IDBInfo |
Find information about keywords unique to this provider (that is, find non-standard SQL keywords). Also, find information about literals, special characters used in text matching queries, and other literal information. |
NA |
IDBInitialize |
Initialize data source objects and enumerators. |
NA |
IDBProperties |
Manage properties on a data source object or enumerator. |
NA |
IDBSchemaRowset |
Get information about system tables, in a standard form (a rowset). |
NA |
IErrorLookup IErrorRecords |
Support ActiveX error object. |
NA |
IGetDataSource |
Return an interface pointer to the session's data source object. |
NA |
IMultipleResults |
Retrieve multiple results (rowsets or row counts) from a command. |
NA |
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. |
NA |
IRowsetIdentity |
Compare row handles. |
NA |
ISequentialStream |
Retrieve a blob column. |
Supported for reading only. No support for SetData with this interface. |
ISessionProperties |
Get session property information. |
NA |
ISourcesRowset |
Get a rowset of data source objects and enumerators. |
NA |
ITableDefinition |
Create, drop, and alter tables, with constraints. |
NA |
ITransaction |
Commit or abort transactions. |
Not all the flags are supported. |
