Firebird Connection

Specifies the options for connecting to Firebird external databases.

Creating a new Firebird database file

  1. Choose File - New - Database and select Connect to an existing database. Click Next.

  2. Click Create. The Save As dialog opens. Enter a suitable name and location for the database file, and click Save. The path of the new file is displayed in the wizard’s text box. Click Next.

  3. Optionally, enter your username and password. Click Next.

  4. Decide your preferred options about registered database and what to do with the database once saved, and click Finish. Proceed to enter a name for the new LibreOffice Base file.

note

In the second step, the name of the new Firebird database file (*.fdb) is entered, whereas in the last step, the LibreOffice Base (*.odb) file is saved.


Connect to an existing Firebird database file

  1. Choose File - New - Database and select Connect to an existing database. Click Next.

  2. Click Browse and select the Firebird file (*.fdb). Click the Open button; the full URL to the database file is displayed in the text box. Click Next.

  3. Optionally, enter your username and password. Click Next.

  4. Decide your preferred options about database registration and what to do with database once saved, and click Finish. Proceed to enter a name for the new LibreOffice Base file.

Connect directly to a Firebird server

In addition to connections via JDBC and ODBC, you can connect to a Firebird server via the internal Firebird driver:

  1. Choose File - New - Database and select Connect to an existing database. Click Next.

  2. Manually enter the database connection URL in the text box. The pattern is <servername>/<port>:<path_to_the_database>, for example:

    server1/3050:C:/data/mydatabase.fdb (note the “/” although it is a Windows path)

    server1:C:/data/mydatabase.fdb (default port, Windows path)

    localhost:/data/mydatabase.fdb (localhost server, default port, Linux path)

    server1:mydata (default port, registered database)

  3. Click Next.

  4. Provide a suitable username and password required for the server connection. Test the connection (recommended) and fix the issues, if any. Click Next.

  5. Decide whether you want to register the database and what to do with it once saved, and click Finish. Enter a name for the new LibreOffice Base file.

note

You can add some other options to the database URL, like the character set or role. See the Firebird documentation to find out about these options.


Please support us!