...
- Via ODBC interface to any database for which an ODBC driver is installed in the system and an ODBC DSN (Data Source Name) is created. We routinely work with PostgreSQL, MySql, MariaDB, Sybase SQL Anywhere, Microsoft SQL Server, Informix, Firebird, and other
- Via OCI interface (Oracle Client Interface) to the Oracle database. In the past, the Oracle database was widely used in large D2000 applications, and therefore a specialized version of the DBManager process using advanced OCI features was created.
It depends on the used binary (in the *.DBM process configuration), which version of the DBManager is started:
- The dbmanager.exe binary (dbmanager on Linux/RPI) implements access via the ODBC interface.
- The dbmanager_ora.exe binary (dbmanager_ora on Linux/RPI) implements access via the OCI interface.
| Info | ||
|---|---|---|
| ||
You can read the following blogs about DBManager: |
Within the DODM model, the DBManager process is the parent of objects of type Database, and these are the parents of objects of type Table.
Database object
...
The D2000 DBManager process is optimized for the parallel work of several users with a Database type object. Therefore, it is able to can create multiple connections with to one SQL database. Each such connection is serviced by its own task and can work in transactional mode (reserved for the specific ESL script that created the transaction) or in non-transactional mode (shared by several scripts or D2000 HI processes, with a COMMIT automatically performed after each operation, so we call such a connection also automatic). In the configuration dialog of the Database object, you can set the number of predefined connections (they are created after the start of the DBManager process), limit the maximum number of connections, the maximum number of non-transactional (automatic) connections, and even reserve automatic connections for the Browser displayer.
...