- Oracle Database (versions 9i, 10g, 11g, 12c, 18c, 19c)
Note: We recommend applying available patches of Oracle client as well as Oracle ODBC driver - older versions of Oracle client/driver suffered from various errors (handle leaks, instability etc.).
- Microsoft SQL Server (versions 2000 - 2005)
- Microsoft Access (versions 2000 - XP)
- PostgreSQL (versions 9.x and above). D2000 Dbmanager supports a startup parameter /NQ to better support PostgreSQL (case sensitivity in table and column names).
Note: in the configuration of ODBC drivers for PostgreSQL, we recommend setting the "Level of rollback on errors" parameter to Statement (or Transaction), not to Nop. Setting Nop makes the database connection unusable after any error.
- Sybase Anywhere (versions 6 - 12)
- Informix (driver version 4.10.00.16554, check a Scrollable Cursors option on Advanced tab and set Cursor Behavior to value "1 - Preserve" on Environment tab)
- Firebird (version 2.0.4, native ODBC driver or driver from GM - Software)
Note 1: Native ODBC driver (version 22.214.171.124) doesn't enable editing in paged mode (browser in HI, actions PG*). Seemingly editing works but no data are modified in the database.
Note 2: ODBC driver from GM - Software supports editing and inserting rows in paged mode, but it displays only the first row of the table.