====== Firebird Database Source ======

Connection to a Firebird database (*.fdb, *.gdb).

For general information about Firebird databases see: [[http://www.firebirdsql.org/index.php|http://www.firebirdsql.org/index.php]]

**Firebird Server** \\
Firebird is a client/server database and a firebird database server must be installed on the machine that contains the database file. Note: The firebird server does __ not __ handle database files on network drives. However, it is possible to connect to a database running on a remote machine from GeoScene3D if the database server i installed on the remote machine.

Download firebird server [[http://www.firebirdsql.org/en/downloads/|here]] (look for super server). GeoScene3D has been tested with version 2.5, but later versions will most likely also be compatible.

==== Source Configuration Dialog ====

Configure database connection

**Source ** \\
Shows the current source path

**Firebird Database Types ** \\
Unspecified (any Firebird Database)\\
[[:geoscene3d:project_content:dataformats:jupiter_database_format|]]\\
[[:geoscene3d:project_content:dataformats:gerda_database_format|Gerda Database Format]]\\
[[:geoscene3d:project_content:dataformats:model_database_format|]]

**Database Properties and Login ** \\
__Host Name:__ If the database file is located on the local machine type "localhost". If the database file is on a remote machine running a Firebird database server then type the host name or IP address of that machine.\\
__Database:__ Path to database file, e.g., "C:\Data\Test.fdb". If the database is on a remote machine then the past must be the path on that machine.\\
__User Name:__ Database user name. Default: "sysdba"\\
__Password:__ Database password. Default: "masterkey"

**Test Login… ** \\
Simply tests the connection

==== Example 1: Local database ====

The database file is located on the local machine running GeoScene3D. The local machine works as both database client and server. The Firebird server application must be installed on the local machine (see [[:geoscene3d:project_content:sources:installing_firebird_server|]] ).

{{:geoscene3d:project_content:sources:748f3602e8993e3378e59e8247ec0998.png}}

Example 1a: Local machine using path to database

{{:geoscene3d:project_content:sources:eda78889ed153639f4dc471fcce917a2.png}}

Example 1b: Local machine using alias "Jupiter" defined in the firebird server file "aliases.conf".

==== Example 2: Remote database ====

The database is located on a remote machine. The local machine works only as client. The Firebird server application must be installed on the remote machine (see [[:geoscene3d:project_content:sources:installing_firebird_server|]] ).

{{:geoscene3d:project_content:sources:175df2a3bbdd78befcec7d036a47f878.png}}

Example 1b: Remote database using host machine IP and the alias "Jupiter" for the database on the remote machine. The alias is defined in the file "aliases.conf" on the remote machine.

{{:geoscene3d:project_content:sources:11320b7f1618e4769f87cb4d5c7bbe97.png}}

Example 2a: Remote database using database host machine IP and the path to the database as seen from the remote machine.