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