Firebird Connection

Specifies the options for connecting to Firebird external databases.

Crear un ficheru de base datos de Firebird

  1. Escueyi Ficheru - Nuevu - Base datos y esbilla Conectar a una base datos esistente. Calca Siguiente.

  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. Escueyi Ficheru - Nuevu - Base datos y esbilla Conectar a una base datos esistente. Calca Siguiente.

  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. Escueyi Ficheru - Nuevu - Base datos y esbilla Conectar a una base datos esistente. Calca Siguiente.

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

    sirvidor1/3050:C:/datos/lamiobasedatos.fdb (observa la «/» anque sía un camín Windows)

    sirvidor1:C:/datos/lamiobasedatos.fdb (puertu predetermináu, camín Windows)

    localhost:/datos/lamiobasedatos.fdb (sirvidor localhost, puertu predetermináu, camín Linux)

    sirvidor1:losmiosdatos (puertu predetermináu, base datos rexistrada)

  3. Calca Siguiente.

  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!