...
- Oracle Database (versions 9i, 10g, 11g, 12c)
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.). - Microsof SQL Server (versions 2000 - 2005)
- Microsoft Access (versions 2000 - XP)
- PostgreSQL (versions 9.x and above). D2000 Dbmanager supports the startup parameter /NQ to better support PostgreSQL (case sensitivity in table and column names).
- 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 2.0.0.148) doesn't enable editing in paged mode (browser in HI, actions PG*). Seemingly editing works but no data are modified in 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.
Note 3: Starting with D2000 version 11.2.57, patches from Januray 14, 2019 and later, a parameter /DBD was implemented to enable support for long strings (> 4000 characters).
From the version D2000 v7.0, along with the "standard" process D2000 DBManager, a variant that only works with Oracle databases (dbmanager_ora.exe) is implemented. This variant does not use the ODBC interface, but accesses the database via the OCI (Oracle Client Interface). It is available on Windows platforms as well as on OpenVMS. When using the dbmanager_ora.exe, the configuration dialog box of an object of Database type contains TNS (Transparent Network Substrate) in the parameter DSN (see the description of the file tnsnames.ora in the Oracle documentation).
...