Windows Dev Center

Level 1 Interface Conformance

 

The Level 1 interface conformance level includes the Core interface conformance level functionality plus additional features, such as transactions, that are usually available in an OLTP relational DBMS. A Level 1 interface–conformant driver lets the application do the following, in addition to the features in the Core interface conformance level:

101

Specify the schema of database tables and views (using two-part naming). (For more information, see the three-part naming feature 201 in Level 2 Interface Conformance.)

102

Invoke true asynchronous execution of ODBC functions, where applicable ODBC functions are all synchronous or all asynchronous on a given connection.

103

Use scrollable cursors, and thereby achieve access to a result set in methods other than forward-only, by calling SQLFetchScroll with the FetchOrientation argument other than SQL_FETCH_NEXT. (The SQL_FETCH_BOOKMARK FetchOrientation is in feature 204 in Level 2 Interface Conformance.)

104

Obtain primary keys of tables, by calling SQLPrimaryKeys.

105

Use stored procedures, through the ODBC escape sequence for procedure calls, and query the data dictionary regarding stored procedures, by calling SQLProcedureColumns and SQLProcedures. (The process by which procedures are created and stored on the data source is outside the scope of this document.)

106

Connect to a data source by interactively browsing the available servers, by calling SQLBrowseConnect.

107

Use ODBC functions instead of SQL statements to perform certain database operations: SQLSetPos with SQL_POSITION and SQL_REFRESH.

108

Gain access to the contents of multiple result sets generated by batches and stored procedures, by calling SQLMoreResults.

109

Delimit transactions spanning several ODBC functions, with true atomicity and the ability to specify SQL_ROLLBACK in SQLEndTran.

Show:
© 2015 Microsoft