ODBC conformance

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.

SQL_ODBC_API_CONFORMANCE must be set to a non-negative value (zero or higher).

SQL_ODBC_SQL_CONFORMANCE must be set to 1 or higher than 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 must be set to 2 or higher. It must be set to 3 or higher when creating application tables from within USoft Developer).

The ODBC driver must be capable of having two or more active statements per connection: SQL_ACTIVE_STATEMENTS must be set to 2 or higher. MS SQL Server via ODBC reports 1 active statement, but still functions correctly with USoft Developer.