> # Mapping ADO Methods and Properties

> This section maps the methods, properties, and collections of ADO objects to the OLE DB methods supported by the ADO data provider.

> Some ADO methods do not have a comparable OLE DB method. When more than one OLE DB method can be used, ADO uses the method that requires the least amount of system resources. For example, if an ADO method can use either ICommand or IOpenRowset, it uses the less performance-intensive IOpenRowset.

> ### ADO Command Object

> The Command object can be used to specify a database query in the language native to the database server. For a relational data provider, this is usually a SQL statement.

> The Execute method for the ADO Command object maps to the OLE DB method, ICommand::Execute.

> Table 4-10 lists the dynamic properties that are supported by the ADO data provider for the Command object.

> Table 4-10. Dynamic Properties Used for the ADO Command Object
> ADO Property | Default Value and Description
> --- | ---
> Access Order | VALUE=2. Columns can be accessed in any order.
> Blocking Storage Objects | VALUE=False. Instantiated storage objects do not prevent the use of other methods.
> Change Inserted Rows | VALUE=False. The value can only be set to True if the rowset is using a keyset-driven cursor.
> Column Privileges | Specifies whether access rights are restricted on a column-by-column basis. VALUE=True. Access rights are restricted on a column-by-column basis. VALUE=False. Access rights are not restricted on a column-by-column basis. If the rowset exposes IRowsetChange, SetData can be called for any column in the rowset.
> Fetch Backwards | VALUE=False. cRows must be non-negative.
> Hold Rows | VALUE=True. Access rights are restricted on a column-by-column basis.
> IAccessor | VALUE=True
> IColumnsInfo | VALUE=True
> IColumnsRowset | VALUE=True
> IConvertType | VALUE=True
> IRowset | VALUE=True
> IRowsetChange | VALUE=False
> IRowsetInfo | VALUE=True
> Literal Row Identity | VALUE=False. The consumer must call IRowsetIdentity::IsSameRow to determine whether two row handles point to the same row.
> Lock Mode | VALUE=1. The data provider is not required to lock rows at any time to ensure successful updates.
> Maximum Open Rows | Specifies the maximum number of rows that can be active at the same time. VALUE=4096
> Maximum Pending Rows | VALUE=0. There is no limit on the number of rows that can have pending changes at the same time.
> Maximum Rows | VALUE=0. There is no limit on the number of rows that can be returned in a rowset.
> Memory Usage | VALUE=0. There is no limit on the amount of memory that can be used by the rowset.
> Objects Transacted | VALUE=True. Any object created on the specified column is transacted.
> Others' Changes Visible | VALUE=False. The rowset cannot see updates and deletes made by others.
> Others' Inserts Visible | VALUE=False. The rowset cannot see inserts made by others.
> Own Changes Visible | VALUE=False. The rowset cannot see updates and deletes made by consumers of the rowset unless the command is executed again.
> Own Inserts Visible | VALUE=False. The rowset can see the rows inserted by consumers only after the command is run again.
> Preserve on Abort | The value depends on the SequeLink service that you are using.
> Preserve on Commit | The value depends on the SequeLink service that you are using.
> Quick Restart | VALUE=True. IRowset::RestartPosition is relatively quick to execute. It does not again execute the command that created the rowset.
> Remove Deleted Rows | VALUE=False. Static cursors do not remove deleted rows.
> Report Multiple Changes | VALUE=False. An update or delete always affects a single row or the data provider cannot detect whether it affects multiple rows.
> Return Pending Inserts | VALUE=False. The methods that fetch rows cannot return pending insert rows.
> Row Privileges | VALUE=False. The data provider does not set access restrictions for rows.
> Row Threading Model | VALUE=1. The ADO data provider uses the free-threaded model.
> Scroll Backward | VALUE=False. IRowsOffset must be non-negative.
> Server Cursor | VALUE=False. The data provider determines where to locate the cursor.
> Strong Row Identity | VALUE=False. There is no guarantee that the handles of newly inserted rows can be compared successfully.
> Unique Rows | VALUE=False. Rows in the rowset may or may not be uniquely identified by their column values.
> Updatability | Specifies the supported methods on IRowsetChange. VALUE=0
> Use Bookmarks | VALUE=False. The rowset does not support bookmarks.

> ### Connection Object

> The ADO Connection object represents a single session with an OLE DB data source. It defines a physical connection to the data source for a data provider.

> Table 4-11 lists the supported ADO methods for the Connection object and maps them to the corresponding OLE DB methods.

> Table 4-11. Mapping Methods Supported by the ADO Connection Object
> ADO Method | OLE DB Method
> --- | ---
> BeginTrans | ITransactionLocal::StartTransaction
> CommitTrans | ITransactionLocal::Commit
> Execute | ICommand::Execute or IOpenRowset::OpenRowset
> Open | IDBInitialize::Initialize IDBCreateSession::Create Session
> RollBackTrans | ITransactionLocal::Abort
> OpenSchema | IDBSchemaRowset::GetRowset

> Table 4-12 lists the dynamic properties supported for the ADO Connection object.

> Table 4-12. Dynamic Properties Supported for the ADO Connection Object
> ADO Property | Default Value and Description
> --- | ---
> Active Sessions | VALUE=0. There is no limit to the maximum number of sessions that can exist at one time.
> Asynchable Abort | VALUE=False. The data provider cannot abort transactions asynchronously.
> Asynchable Commit | VALUE=False. The data provider cannot commit transactions asynchronously.
> Autocommit Isolation Levels | Specifies the transaction isolation level while in auto-commit mode. A combination of zero or one or more of the following: VALUE=DBPROPVAL_TI_BROWSE VALUE=DBPROPVAL_TI_CURSORSTABILITY VALUE=DBPROPVAL_TI_ISOLATED VALUE=DBPROPVAL_TI_READCOMMITTED VALUE=DBPROPVAL_TI_READUNCOMMITTED VALUE=DBPROPVAL_TI_REPEATABLEREAD VALUE=DBPROPVAL_TI_SERIALIZABLE
> Catalog Location | The value depends on the SequeLink service you are using. Possible values are: VALUE=1. The catalog name is at the start of the fully qualified name. VALUE=2. The catalog name is at the end of the fully qualified name.
> Catalog Term | Specifies the name the data source uses for a catalog. VALUE=Database
> Catalog Usage | Specifies how catalog names can be used in text commands. A combination of zero or one or more of the following: VALUE=1. Catalog names are supported in all Data Manipulation Language statements. VALUE=2. Catalog names are supported in all table definition statements. VALUE=4. Catalog names are supported in all index definition statements. VALUE=8. Catalog names are supported in all privilege definition statements.
> Column Definition | VALUE=1. Columns can be created non-nullable.
> COM Object Support | VALUE=1. The data providers support access to BLOBs as structured storage objects. A data consumer determines which interfaces are supported through the Structured Storage property.
> Connection Status | VALUE=1. The data source is in an initialized state and able to communicate with the data store.
> Current Catalog | Specifies the name of the current catalog. The data consumer can use the CATALOGS rowset to enumerate catalogs. If not set, the data provider uses the default catalog.
> Data Source | Specifies the name of the data source or enumerator to which to connect.
> Data Source Name | Specifies the name of the data source (server) used during the connection process.
> Data Source Object Threading Model | VALUE=1. The data provider uses the free-threading model.
> DBMS Name | Specifies the name of the product accessed by the ADO data provider.
> DBMS Version | Specifies the version of the product that the data provider is currently accessing.
> Extended Properties | A provider-specific string that contains extra initialization information. Consumers should use this property only for provider-specific connection information. See "Connecting with a Provider String" for information on using the provider string with the ADO data provider.
> GROUP BY Support | This value depends on the SequeLink service you are using. VALUE=1. The GROUP BY clause is not supported. VALUE=2. The GROUP BY clause must contain all nonaggregated columns in the select list. It cannot contain any other columns. VALUE=4. The GROUP BY clause must contain all nonaggregated columns in the select list. It can contain columns that are not in the select list. VALUE=8. The columns in the GROUP BY clause and the select list are not related. The meaning of nongrouped, nonaggregated columns in the select list is data source-dependent.
> Heterogeneous Table Support | VALUE=0. The data provider cannot join tables from different catalogs or providers.
> Identifier Case Sensitivity | This value depends on the SequeLink service you are using. VALUE=1. Identifiers in SQL are case-sensitive and are stored in upper case in the system catalog. VALUE=2. Identifiers in SQL are case-insensitive and are stored in lower case in the system catalog. VALUE=4. Identifiers in SQL are case-sensitive and are stored in mixed case in the system catalog. VALUE=8. Identifiers in SQL are case-insensitive and are stored in mixed case in the system catalog.
> Initial Catalog | Specifies the name of the initial, or default, catalog to use when connecting to the data source.
> Isolation Levels | This value depends on the SequeLink service you are using. Zero, or a combination of one or more of the following: VALUE=DBPROPVAL_TI_BROWSE VALUE=DBPROPVAL_TI_CHAOS VALUE=DBPROPVAL_TI_CURSORSTABILITY VALUE=DBPROPVAL_TI_ISOLATED VALUE=DBPROPVAL_TI_READCOMMITTED VALUE=DBPROPVAL_TI_READUNCOMMITTED VALUE=DBPROPVAL_TI_REPEATABLEREAD VALUE=DBPROPVAL_TI_SERIALIZABLE
> Isolation Retention | VALUE=0. The data provider supports no transaction isolation retention levels.
> Locale Identifier | Specifies the preferred locale ID for the consumer.
> Maximum Index Size | VALUE=0. There is no limit on the index size.
> Maximum Open Chapters | VALUE=0. There is no limit on the maximum number of chapters that can be open at any time.
> Maximum Row Size | VALUE=0. There is no limit on the maximum length of a single row in a table.
> Maximum Row Size Includes BLOB | VALUE=False. The maximum row size does not include the length of all BLOB data.
> Maximum Tables in SELECT | VALUE=0. There is no limit on the number of tables in a Select statement.
> Mode | VALUE=3. The default access is read-write.
> Multi-Table Update | VALUE=False. The data provider cannot update rowsets derived from multiple tables.
> Multiple Connections | VALUE=True. The data provider must spawn multiple connections to support concurrent command, session, and rowset objects.
> Multiple Parameter Sets | VALUE=True. The data provider supports multiple parameter sets at the same time.
> Multiple Results | VALUE=1. The data provider supports multiple results objects.
> Multiple Storage Objects | VALUE=True. The data provider supports more than one open storage object at a time.
> NULL Collation Order | The value depends on the SequeLink service you are using.
> NULL Concatenation Behavior | The value depends on the SequeLink service you are using.
> OLE DB Services | VALUE=0. The data provider does not enable the OLE DB services.
> OLE DB Version | Specifies the version of OLE DB supported by the data provider. Refer to the README for the supported version.
> Open Rowset Support | VALUE=0. All data providers support opening tables through IOpenRowset.
> ORDER BY Columns In Select List | This value depends on the SequeLink service you are using.
> Output Parameter Availability | VALUE=4. If a command returns a single result that is a rowset, output parameter data is available at the time the rowset is completely released.
> Pass By Ref Accessors | VALUE=False. The data provider does not support the DBACCESSOR_PASSBYREF flag.
> Password | Specifies the password to be used for connecting to the data source or enumerator.
> Prepare Abort Behavior | The value depends on the SequeLink service you are using.
> Prepare Commit Behavior | The value depends on the SequeLink service you are using.
> Procedure Term | Specifies a character string that contains the data source vendor's name for a procedure.
> Prompt | Specifies whether to prompt the user for additional information during initialization.
> Provider Friendly Name | Specifies the name of the data provider, DataDirect SequeLink for ADO Provider.
> Provider Name | VALUE=slslknn.DLL, where nn is the release level of the data provider.
> Provider Version | Specifies the version of the DataDirect data provider. Refer to the README for the version number.
> Quoted Identifier Sensitivity | This value depends on the SequeLink service you are using. VALUE=1. Quoted identifiers in SQL are case-sensitive and are stored in upper case in the system catalog. VALUE=2. Quoted identifiers in SQL are case-insensitive and are stored in lower case in the system catalog. VALUE=4. Quoted identifiers in SQL are case-sensitive and are stored in mixed case in the system catalog. VALUE=8. Quoted identifiers in SQL are case-insensitive and are stored in mixed case.
> Read Only Data Source | VALUE=0. The data source can be updated.
> Rowset Conversions on Command | VALUE=True. Callers can inquire on a command about conversions supported on rowsets generated by the command.
> Schema Term | Specifies the name the data source uses for a schema.
> Schema Usage | This value depends on the SequeLink service you are using. A combination of the following: VALUE=DBPROPVAL_SU_DML_STATEMENTS. Schema names are supported in all Data Manipulation Language statements. VALUE=DBPROPVAL_SU_TABLE_DEFINITION. Schema names are supported in all table definition statements. VALUE=DBPROPVAL_SU_INDEX_DEFINITION. Schema names are supported in all index definition statements. VALUE=DBPROPVAL_SU_PRIVILEGE_DEFINITION. Schema names are supported in all privilege definition statements.
> Server Name | Specifies the name of the server. This can be the same as the Data Source property if the server name is used to define the user's data source. Alternatively, if the data provider connects through the data provider's "friendly" data source names, this can be the actual name of the server.
> SQL Support | Specifies the level of SQL grammar that the data provider supports. The effects are cumulative. A combination of zero or one or more of the following: VALUE=DBPROPVAL_SQL_NONE VALUE=DBPROPVAL_SQL_ODBC_CORE VALUE=DBPROPVAL_SQL_ODBC_MINIMUM VALUE=DBPROPVAL_SQL_ODBC_EXTENDED VALUE=DBPROPVAL_SQL_ESCAPECLAUSES VALUE=DBPROPVAL_SQL_ANSI92_ENTRY VALUE=DBPROPVAL_SQL_ANSI92_ENTRY VALUE=DBPROPVAL_SQL_FIPS_TRANSITIONAL VALUE=DBPROPVAL_SQL_ANSI92_INTERMEDIATE VALUE=DBPROPVAL_SQL_ANSI92_FULL VALUE=DBPROPVAL_SQL_ANSI89_IEF VALUE=DBPROPVAL_SQL_SUBMINIMUM
> Structured Storage | VALUE=1. The data provider supports DBPROPVAL_SS_ISEQUENTIALSTREAM.
> Subquery Support | Specifies the predicates in text commands that support subqueries. The value can be zero, or one or more of the following: VALUE=DBPROPVAL_SQ_CORRELATEDSUBQUERIES VALUE=DBPROPVAL_SQ_COMPARISON VALUE=DBPROPVAL_SQ_EXISTS VALUE=DBPROPVAL_SQ_IN VALUE=DBPROPVAL_SQ_QUANTIFIED
> Table Term | Specifies the name the data source uses for a table.
> Transaction DDL | This value depends on the SequeLink service you are using.
> User Name | Specifies a character string with the name used in a particular database. This can be different from the login name.
> Window Handle | Specifies the window handle to use if the data source object or enumerator needs to prompt for additional information.

> ### Recordset Object

> The Recordset object is the set of records resulting from a query against a database and a cursor, which is the interface to the records. If you create a Connection object before you open a Recordset object, multiple Recordset objects can be opened on the same connection.

> Table 4-13 maps the methods of the Recordset object to the OLE DB methods supported by the ADO data provider.

> Table 4-13. Mapping Methods Supported by the Recordset Object
> ADO Method | OLE DB Method
> --- | ---
> AddNew | IRowsetChange::InsertRow
> CancelBatch | IRowsetUpdate::Undo
> Clone | IRowsetLocate
> Close | IAccessor::ReleaseAccessor IRowset::ReleaseRows
> Delete | IRowsetChange::DeleteRows
> GetRows | IAccessor::CreateAccessor IRowsetLocate::GetRowsAt IRowset::GetNextRows IRowset::GetData
> Move | IRowsetLocate::GetRowsAt IRowset::GetNextRows
> MoveFirst | IRowsetLocate::GetRowsAt IRowset::RestartPosition
> MoveLast | IRowsetLocate::GetRowsAt
> MoveNext | IRowsetLocate::GetRowsAt IRowset::GetNextRows
> MovePrevious | IRowsetLocate::GetRowsAt IRowset::GetNextRows
> NextRecordSet | IMultipleResults::GetResult
> Open | IOpenRowset::OpenRowset ICommand::Execute
> Requery | IOpenRowset::OpenRowset ICommand::Execute
> Supports | IRowsetInfo::GetProperties
> Update | IRowsetChange::SetData IRowsetUpdate::Update
> UpdateBatch | IRowsetUpdate::Update

> Table 4-14 lists the dynamic properties supported by the ADO data provider for the Recordset object.

> Table 4-14. Dynamic Properties Used for the Recordset Object
> ADO Property | Default Value and Description
> --- | ---
> Access Order | VALUE=2. Columns can be accessed in any order.
> Blocking Storage Objects | VALUE=False. Instantiated storage objects do not prevent the use of other methods.
> Bookmark Information | Specifies additional information about bookmarks over the rowset.
> Bookmark Type | VALUE=1. The bookmark type is numeric.
> Change Inserted Rows | VALUE=False. DeleteRows returns a status of DBROWSTATUS_E_NEWLYINSERTED for the newly inserted row and SetData returns DB_E_NEWLYINSERTED.
> Column Privileges | Specifies whether access rights are restricted on a column-by-column basis. VALUE=True. Access rights are restricted on a column-by-column basis. VALUE=False. Access rights are not restricted on a column-by-column basis. If the rowset exposes IRowsetChange, SetData can be called for any column in the rowset.
> Delay Storage Object Updates | VALUE=False. Storage objects are used in immediate update mode.
> Fetch Backwards | VALUE=False. cRows must be non-negative.
> Hold Rows | VALUE=False. The rowset might require pending changes to be transmitted to the data store before fetching additional rows.
> IAccessor | VALUE=True.
> IColumnsInfo | VALUE=True.
> IColumnsRowset | VALUE=True.
> IConvertType | VALUE=True.
> IRowset | VALUE=True.
> IRowsetChange | VALUE=False.
> IRowsetInfo | VALUE=True.
> IRowsetLocate | VALUE=False.
> Immobile Rows | VALUE=True`.` The rowset will not reorder inserted or updated rows.
> Literal Bookmarks | VALUE=False. Bookmarks can only be compared with IRowsetLocate::Compare.
> Literal Row Identity | VALUE=False. The consumer must call IRowsetIdentity::IsSameRow to determine whether two row handles point to the same row.
> Lock Mode | VALUE=1. The data provider is not required to lock rows to ensure successful updates.
> Maximum Open Rows | Specifies the maximum number of rows that can be active at the same time. VALUE=4096
> Maximum Pending Rows | VALUE=0. There is no limit to the maximum number of rows that can have pending changes at the same time.
> Maximum Rows | VALUE=0. There is no limit to the number of rows that can be returned in a rowset.
> Memory Usage | VALUE=0. There is no limit to the amount of memory that the rowset can use.
> Objects Transacted | VALUE=True. Any object created on the specified column is transacted.
> Others' Changes Visible | VALUE=False. The rowset cannot see updates and deletes made by others.
> Others' Inserts Visible | VALUE=False. The rowset cannot see the rows inserted by others.
> Own Changes Visible | VALUE=False. The rowset cannot see updates and deletes made by consumers of the rowset unless the command is executed again.
> Own Inserts Visible | VALUE=False. The rowset can see the rows inserted by consumers only after the command is run again.
> Preserve on Abort | The value is specific to the SequeLink Server you are using.
> Preserve on Commit | The value is specific to the SequeLink Server you are using.
> Quick Restart | VALUE=True. IRowset::RestartPosition is not expensive to execute and does not execute the command that created the rowset again.
> Remove Deleted Rows | VALUE=False. Static cursors do not remove deleted rows.
> Report Multiple Changes | VALUE=False. An update or delete always affects a single row or the data provider cannot detect whether it affects multiple rows.
> Return Pending Inserts | VALUE=False. The methods that fetch rows cannot return pending insert rows.
> Row Privileges | VALUE=False. Access rights are not restricted on a row-by-row basis.
> Row Threading Model | VALUE=1. The data provider supports the free-threaded model.
> Scroll Backward | VALUE=False. IRowsOffset must be non-negative.
> Server Cursor | VALUE=False. The data provider determines where to locate the cursor.
> Skip Deleted Bookmarks | VALUE=False. GetRowsAt, GetApproximatePosition, or FindNextRow returns DB_E_BADBOOKMARK.
> Strong Row Identity | VALUE=False. There is no guarantee that the handles of newly inserted rows can be compared successfully.
> Unique Rows | VALUE=False. Rows in the rowset may or may not be uniquely identified by their column values.
> Updatability | Specifies the supported methods on IRowsetChange. VALUE=0
> Use Bookmarks | VALUE=False. The rowset does not support bookmarks.