TABLE 1: OLE DB Interfaces, Properties, and Schemas DTS Uses
DataSource required property
IDBInitialize required interface
IDBProperties required interface
IDBCreateSession required interface
ISessionProperties required interface
IDBCreateCommand optional interface, used to create tables, queries, etc.
IDBInfo required interface
IOpenRowset required interface
ICommandText optional interface, used to create tables, queries, etc.
ICommandPrepare optional interface, used to create tables, queries, etc.
IColumnsInfo required interface
IRowset required interface
IAccessor required interface
ICommandWithParameters optional, used for Data Driven Queries
IDBSchemaRowset required interface
DBSCHEMA_PROVIDER_TYPES required schema
DBSCHEMA_TABLES optional schema
DBSCHEMA_CATALOGS optional schema
DBSCHEMA_PRIMARY_KEYS optional schema
DBSCHEMA_FOREIGN optional schema
DBSCHEMA_INDEXES optional schema
DBSCHEMA_TABLE_CONSTRAINTS optional schema
DBSCHEMA_CHECK_CONSTRAINTS optional schema