Partners
Firebird Code Factory online Help
| Prev | Return to chapter overview | Next |
Setting connection properties
The first wizard step allows you to specify the database connection properties that will be used on further connections.
Firebird Code Factory allows you to connect to Firebird servers directly or via Secure SHell (SSH) tunnel.
| • | Direct connection is the most preferable connection mode. |
| • | 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. |
More about SSH tunnel connection
To establish connection to intermediate SSH server and forward all Firebird commands through the secure tunnel, you need to:
Host name Specify the host name or IP of your site.
Port number Enter the port number for the SSH server. Enter valid User name for the remote server, select the authentication type: by password or by private key and set the Password or the path to the Private key file with the corresponding Passphrase to log in to the remote server.
Note: Firebird host name always should be set relatively to the SSH server. For example, if both of Firebird and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.
|
Irrespectively of a connection mode you should specify common credentials as follows:
Protocol (Standard server, Embedded server)
Select the type of server you are connecting to.
Host
The host name of the Firebird server.
Port number
The TCP/IP port to use if server is not localhost.
Firebird Code Factory allows you to use Windows authentication (Firebird 2.1 or higher). 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.
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.
Note: The user must have previously been granted membership in the role to gain the privileges of that role.
Note: In Firebird a user can adopt at most one role per connection, and cannot switch roles except by reconnecting.
Check the Create a single profile option to set the database name manually and create a single profile for this database.
Hide already registered databases
Check the box to shorten the databases list on the next wizard step.