Firebird-kapcsolat

Megadja a Firebird külső adatbázisokhoz való kapcsolódás beállításait.

Új Firebird adatbázis fájl létrehozása

  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

Ez a név az új Firebird adatbázis fájl neve (*.fdb), nem pedig a LibreOffice Base (*.odb) fájl neve.


Csatlakozás egy meglévő Firebird adatbázis fájlhoz

  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.

Közvetlen csatlakozás egy Firebird szerverhez

A JDBC és ODBC kapcsolaton kívül a Firebird-kiszolgálóhoz a belső Firebird-illesztőprogramon keresztül is csatlakozhat:

  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.