ODBC Conformance

See Also

ODBC drivers conform to certain conformance levels. There are conformance levels for ODBC functions (API) and SQL grammar. USoft Production for ODBC requires the following minimum conformance levels from the ODBC driver:

Functions

SQL_ODBC_API_CONFORMANCE must be >= 0

Grammar & Data Types

SQL_ODBC_SQL_CONFORMANCE must be >= 1

The ODBC driver MUST support transaction processing (Commit and Rollback) and transaction isolation level: SQL_TXN_REPEATABLE_READ or higher (SQL_TXN_SERIALIZABLE or SQL_TXN_VERSIONING).

The ODBC driver must be capable of having two or more connections active:

SQL_ACTIVE_CONNECTIONS >= 2

(three when creating application tables from within USoft Developer) and must be capable of having two or more active statements per connection:

SQL_ACTIVE_STATEMENTS >= 2

A USoft ODBC application conforms to the ODBC version 1.0 specification. It can therefore be used with ODBC version 1.0 and 2.0 drivers and driver managers (ODBC.DLL).

SQL_ODBC_VER must be >= 1