Firebird Connection
Note: Using this connection, you can also work with the RedDB database, which is based on Firebird.
It is used for connection to the Firebird database and its operation.
Connection Parameters
The following parameters are set during the connection setup:
- Caption contains the connection name set by a user.
- Connection string is set in a separate window that can be called by clicking on
button. Two connection types are supported.- Local: connection without the use of the Firebird server; only a path to the DB is specified.
- Remote: connection with the use of the Firebird server.
- Server: the Firebird server host.
- Protocol: the protocol that is used by the server for interaction with a client.
- Test: test of the specified connection settings.
- Username: login of the DB user. If the login is not specified, the domain authorization is used.
- Password: password of the DB user.
- Show system tables: when selecting this checkbox in the import wizard that uses this connection, the system DB tables available to a user become visible.
- Quote names: if the database objects names (for example, names of tables, fields) contain spaces or reserved characters, it is required to use framing characters fixing the name start and end.
- Configure quotes represents the information field that enables to define which framing characters are used for connection to this DB. Double quotes are used for Firebird.
- Codepage provides encoding of characters according to which the server data will be interpreted.
- Do not use DBMS client: it is not possible to change this parameter for Firebird.
- Clear pool when deactivated enables to clear the pool of the Megaladata Integrator packages frequently used in the batch processing saved for the quick call upon the node deactivation. This parameter is disabled by default.
- Comment: it is possible to provide any reference connection data in this form.
Note: To provide connection to the database, it is required to install the client library files (DLL) with the same bitness as the Megaladata application/server bitness.
In the case of the multiple user access to the DB, it is recommended to use the Firebird server to avoid access lock.
Important: The domain authorization process is implemented as user under whose name the Megaladata server has been started.
Compatibility
Starting from Firebird 2.5 and higher.
See also: