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 >= 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
NOTE: MS SQL Server via ODBC reports 1 active statement, but this ODBC driver functions extremely well with USoft Developer.