Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

DB2 Data Sync online Help

Prev Return to chapter overview Next

Firebird

Specify the following credentials to connect to Firebird.

 

Direct connection

Direct connection is the most preferable connection mode.

 

SSH tunnel connection

If your Firebird server does not allow direct connections from remote workstations, you can establish connection to intermediate SSH server and forward all Firebird commands through the Secure SHell (SSH) tunnel.

 

Irrespectively of a connection mode you should specify common credentials as follows:

 

Protocol

Select "Standard server" to connect to a standalone Firebird server or "Embedded server" to use the embedded Firebird server that comes with the software (currently it is Firebird 2.5).

 

Host

The name of machine the Firebird server and database file resides on. It is usually possible to specify TCP/IP address instead of name (like 192.168.12.34), however this functionality is not built into Firebird, instead, it is provided by underlying network layer (e.g. WinSock2), and for some implementations/configurations it can be much slower than using name. In case the server is not localhost, specify the TCP/IP port as Port number.

 

Login information

Since version 2.1, Windows authentication has been used for configuring the server authentication mode along with the traditional login info, requiring users to log in using a user name and password defined in the security database. To use Windows authentication, check the corresponding box. Under the right conditions, this may be the most secure way to authenticate on Windows. Otherwise, set the following server security options:

 

User name

The username used to connect to Firebird. User names are case insensitive on the server.

Password

The password for the user account on server. The server checks the user name and password against the security database. Case sensitivity is retained for the comparison. Only first 8 characters of Password are verified.

Role

Specify the role that the user adopts on connection to the database or leave it blank. Regardless of role memberships granted, the user has the privileges of a role at connect time only if a Role clause is specified in the connection. The user must have previously been granted membership in the role to gain the privileges of that role.

 

Database name

This is either a full name of the database file (as seen from the server), or an alias defined in the server's aliases.conf file.

 

 More about SSH tunnel connection



Prev Return to chapter overview Next