Setting connection parameters
Use this step of the wizard to set the necessary connection parameters for the new host using the controls available in the Server and Client areas.
In this section you need to define connection parameters.
Type in, or use the drop-down list to specify the host name of the InterBase/Firebird server.
Use the drop-down list to select the communication protocol to be used for the connection. Possible values are: Local, TCP/IP, Novell SPX, NetBEUI, Embedded.
Use this field to specify a port or service to connect through. By default it is "gds_db" for InterBase and port 3050 for Firebird.
Afterwards you must specify valid authorization info to access the target InterBase/Firebird server: User name and Password.
The default superuser name is 'SYSDBA' with password 'masterkey'.
You can also define the user role in SQL role field.
Pressing the Get Server Preferences button allows the program to do the following actions automatically:
- get server version (when done the version will be displayed in the title of the section);
- define security database if possible (a few servers do not allow such an operation);
- detect client library according to the server version (also shows the version in the corresponding section title) from the following folders (from all successful results the program chooses the one that best corresponds to the server version):
the folder specified in the Client Library field;
the server home folder and subfolders (server must be local and home folder must be specified);
the root folder of SQL Manager;
the folders associated with the Path environment variable;
\Windows and \Windows\System32;
- set authentication type.
Authorized InterBase/Firebird users are stored in a security database. Each InterBase/Firebird server has its own security database, which means that a user definition is bound to the server where it is stored. The security database also stores an encrypted password for each user.
Type in or use the button to specify the path to the security database. The drop-down list contains the previously specified security databases.
In this section you can specify the client settings.
Client library provides the conduit between the API or object library an application uses to communicate with the DB server and the networking protocols used to exchange data with the network.
Type in or use the button to specify the path to the client library. For successful connection to the server it is crucial to use the appropriate client library - the one that is compatible with the server you are using: gds32.dll for InterBase and fbclient.dll for Firebird. Please note that the client library file must be located on your local machine (e.g. in the directory where the application is installed). The drop-down list contains the previously specified client libraries.
Hint: Automatic search for the library is performed upon pressing the Get Server Preferences button.
This group is only available in case you connect to Firebird 2.1 or higher. Specify the preferable type of server authentication to be used for the connection:
Normal (traditional IB/FB authentication with security database)
Win32 NTLM authentication (only FB 2.1 or above)
Use Secure Shell (SSH) tunneling
Select this option to establish connection to an intermediate SSH server and forward all InterBase/Firebird commands through the secure tunnel. The next step of the wizard allows you to define the corresponding parameters for SSH tunneling.
If this option is checked, you should set tunneling parameters at the SSH tunneling parameters step of the wizard.
If Embedded is selected in the Protocol drop-down list, you need to specify embedded server connection properties.
Type in, or use the drop-down list to specify the host name of the embedded server.
Type in or use the button to specify the path to the client library for the embedded server. The drop-down list contains the previously specified client libraries.
Embedded server root
Type in or use the button to specify the folder containing extra files for the embedded server.
Publish root into Path environment variable and server configuration file
Select this option to add the path specified in the Embedded server root field to the 'Path' environment variable and server configuration file.
If you want to use the local utilities (eg, gbak.exe) then you need to rename the library fbembed.dll to fbclient.dll, and place utilities into the folder where embedded server libraries are located.
Click the Next button to proceed to Setting specific options for the host being registered, or to the SSH tunneling parameters step of the wizard (if the Use Secure Shell (SSH) tunneling option is enabled for the host).