EMS logo

Products Navigation

SQL Query for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for InterBase/FireBird

On-line Documentation

Setting connection properties


Enter the necessary settings to establish connection to InterBase/Firebird server.

 

hs3221 - Specifying the host

 

 

First of all you should specify the database location: RadioButton Database is located on already registered host or RadioButton Database is located on a new host.

 

Host name

Type in, or use the drop-down list to specify the host name of the InterBase/Firebird server.

 

hs3221 - Setting connection properties

 

 

If the database is located on a new host you need to specify connection settings.

 

Host name

Type in, or use the drop-down list to specify the host name of the InterBase/Firebird server.

 

Network protocol.

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.

 

Afterwards you should specify authorization settings: User name and Password. The default superuser name is 'SYSDBA' and the default password is 'masterkey'.

 

You can also define the user role in Role field.

 

You also need to specify the path to the Library in the corresponding field. 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 utility is installed).

 

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.

 

Click the Next button to proceed to the Setting registration options step of the wizard.