ODBC API restrictions and unsupported functions
The way in which some functions are implemented in the IBM® i Access ODBC Driver does not meet the specifications in the Microsoft ODBC Software Development Kit Programmer's Reference.
The table below describes some global restrictions and unsupported functions. See ODBC 3.x API notes for a list of individual APIs and their associated considerations.
| Function | Description |
|---|---|
| Global considerations | No asynchronous processes are supported. However,
SQLCancel can be called, from a different thread (in a multi-threaded
application), to cancel a long running query. Translation DLLs are only called when converting data from buffers. |
| SQLSetScrollOptions (2x API) | SQL_CONCUR_ROWVER, SQL_CONCUR_VALUES
are unsupported options for Concurrency parameter. The SQL_SCROLL_KEYSET_DRIVEN is mapped to SQL_SCROLL_DYNAMIC by the driver. |