Firebird server

Installation of a Firebird database server for use with esoffice

Requirements

Please note the following requirements for use of a Firebird server with esoffice:

Firebird server installation

The Firebird server can be installed as part of the esoffice installation routine.

 

Manual installation of the Firebird SQL server is not recommended. Please only use the esoffice installation program.

Also see Install esoffice

 

If a subsequent installation of the Firebird server is necessary (for example: due to a server migration), use the esoffice installation routine to install only the Firebird server without the esoffice files.

You can also install the Flamerobin database tool as part of the installation.

Install Firebird

  1. Open the esoffice_xxxx_EN directory in the esoffice installation files.

  2. Double click on setup.exe to start the installation program.

  3. If Windows user account manager is activated, a message may be displayed.

    Click on the Yes button to continue.

  4. The esweb setup wizard starts. Click on the Next button to continue.

  5. An installation directory for the esoffice program is suggested first.

    You can use the Search button to select a different folder.

     

    The default directory is C:\Program Files (x86)\es2000.

    Click on the Next button to continue to the next step.

  6. The selection of components to be installed is displayed next.

    Select the components that you want to install. In this case, this would be the Firebird server (32bit / 64bit).

    Firebird server (32bit)

    If you activate this option, the 32bit version of the Firebird server will be installed.

     

    The 32bit version of the Firebird server should only be installed on a 32bit operating system. The 64bit version of the Firebird server should be installed on a 64bit operating system.

    Firebird server (64bit)

    Installs the 64bit version of the Firebird server.

    This version should preferably be selected for installations on a 64bit operating system.

    esoffice files

    These files are necessary for installation of esoffice so this option is activated by default.

     

    If only the Firebird server is to be installed, deactivate the esoffice files option.

    Flamerobin Database Administration

    The Flamerobin auxiliary program for management of a Firebird SQL server and the corresponding databases can be installed using this option.

     

    Visual C++ Redistributable from Microsoft must be downloaded and installed during the subsequent steps to install the Flamerobin program. A corresponding option can be set for this at the Additional tasks stage.

    When you have selected the components, click on the Next button.

  7. Select a Start menu folder or use the default folder.

    Click on the Next button to proceed to the next step.

  8. In the next step, select the additional tasks that the installation program is to perform.

    Open link to Visual C++ Redistributable installation (for Flamerobin)

    This option is only displayed if Flamerobin Database Administration was selected in the component selection. When you activate this option, the Microsoft website for downloading Visual C++ Redistributable will open. These components are required for the installation of the Flamerobin program.

    Click on the Next button to proceed to the next step.

  9. A summary of the selected installation settings is displayed.

    Click on the Install button to start the actual installation.

    If you activated the Open link to Visual C++ Redistributable installation (for Flamerobin) option in the Additional tasks step, the Microsoft website for downloading Visual C++ Redistributable will open.

    1. Select the desired language and then click on the Download button.

    2. Select the correct version for your operating system (vc_redist.x64.exe for 64bit operating systems and vc_redist.x86.exe für 32bit systems).

      To download the selected file, click on the Next button.

    3. Run the downloaded file.

    4. Activate the option for agreement to the licence contract and click on the Install button.

    5. When installation has completed successfully, click on the Close button.

  10. When the Firebird server has been installed, you can carry out additional tasks.

    Set up database backup task in Windows Task Manager (daily at 23:59)

     

    This option is only intended for use with a Firebird SQL server.

    If you activate this option, a daily task to back up the Firebird databases will be created in the Windows Task Manager (to be performed at 23:59 every day). To execute the backup, the batch file backup.cmd is embedded in the task which is recorded for example in the \ES2000\Backup folder of the esoffice installation.

     

    You will need to adjust both the task in the task manager and the batch file backup.cmd to the individual system environment. If this is not done, the backup will not be performed.

    Configure firewall (Firebird and esoffice)

     

    This option is only intended for use with a Firebird SQL server.

    When you activate this option, settings necessary for operation of esoffice and the Firebird server will be made in the Windows firewall.

     

    If an external firewall is used, it may be necessary to manually enable the corresponding ports.

    Instal esdbm database manager

    Activate this option if the esdbm Database Manager is to be installed.

    The esdbm (esdatabase management) program performs various database operations.

    For example, you can use it to display the contents of databases, and transfer their contents as well as to align database contens by means of SQL queries.

    Installation of esdbm is described under esdbm installation.

    Click on the Next button when you have selected the tasks.

  11. This completes installation of the Firebird server.

    Click on the Complete button to close the setup wizard.