This section describes the general functionality supported by the driver.

  • ODBC compliance: The driver is compliant with the Open Database Connectivity (ODBC) 3.52 specification. The driver is ODBC core compliant and supports some Level 1 and Level 2 features.

    Refer to ODBC API and scalar functions in the Progress DataDirect for ODBC Drivers Reference for a list of supported API functions.

    The driver supports only the following Level 2 functions:

    • SQLColumnPrivileges
    • SQLDescribeParam
    • SQLForeignKeys
    • SQLPrimaryKeys
    • SQLProcedures
    • SQLTablePrivileges
  • Unicode support: The driver is fully Unicode enabled. On Linux platforms, the driver supports both UTF-8 and UTF-16. On Windows platforms, the driver supports UCS-2/UTF-16 only.

    Refer to Internationalization, localization, and Unicode in the Progress DataDirect for ODBC Drivers Reference for details.

  • Isolation and lock levels: Because transactions are not supported, the driver supports only the isolation level 0 (read uncommitted).

    Refer to Locking and isolation levels in the Progress DataDirect for ODBC Drivers Reference for details.

  • Connections and statements supported: The driver supports multiple connections and multiple statements per connection.