From 267c6f2ac71f92999e969232431ba04678e7437e Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 15 Apr 2024 07:54:39 +0200 Subject: Adding upstream version 4:24.2.0. Signed-off-by: Daniel Baumann --- .../source/text/sdatabase/dabawiz02firebird.xhp | 89 ++++++++++++++++++++++ 1 file changed, 89 insertions(+) create mode 100644 helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp (limited to 'helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp') diff --git a/helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp b/helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp new file mode 100644 index 0000000000..493e5b08ce --- /dev/null +++ b/helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp @@ -0,0 +1,89 @@ + + + + + + + Firebird Connection + /text/sdatabase/dabawiz02firebird.xhp + + + + +Firebird server;setup connection +Firebird connection +database connection;Firebird server + + +
+

Firebird Connection

+ Specifies the options for connecting to Firebird external databases. +
+ +

Creating a new Firebird database file

+ + + Choose File - New - Database and select Connect to an existing database. Click Next. + + + 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. + + + Optionally, enter your username and password. Click Next. + + + 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 %PRODUCTNAME Base file. + + + In the second step, the name of the new Firebird database file (*.fdb) is entered, whereas in the last step, the %PRODUCTNAME Base (*.odb) file is saved. +

Connect to an existing Firebird database file

+ + + Choose File - New - Database and select Connect to an existing database. Click Next. + + + 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. + + + Optionally, enter your username and password. Click Next. + + + 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 %PRODUCTNAME 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: + + + Choose File - New - Database and select Connect to an existing database. Click Next. + + + 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) + + + Click Next. + + + Provide a suitable username and password required for the server connection. Test the connection (recommended) and fix the issues, if any. Click Next. + + + 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 %PRODUCTNAME Base file. + + + 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. +
+ Firebird documentation +
+ + -- cgit v1.2.3