diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
commit | 267c6f2ac71f92999e969232431ba04678e7437e (patch) | |
tree | 358c9467650e1d0a1d7227a21dac2e3d08b622b2 /helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp | |
parent | Initial commit. (diff) | |
download | libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.tar.xz libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.zip |
Adding upstream version 4:24.2.0.upstream/4%24.2.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp')
-rw-r--r-- | helpcontent2/source/text/sdatabase/dabawiz02firebird.xhp | 89 |
1 files changed, 89 insertions, 0 deletions
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 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the %PRODUCTNAME project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> + <topic id="textsdatabasedabawiz02firebirdxhp" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Firebird Connection</title> + <filename>/text/sdatabase/dabawiz02firebird.xhp</filename> + </topic> +</meta> +<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id641677867638107"> +<bookmark_value>Firebird server;setup connection</bookmark_value> +<bookmark_value>Firebird connection</bookmark_value> +<bookmark_value>database connection;Firebird server</bookmark_value> +</bookmark> + +<section id="firebirdconnection"> + <h1 id="hd_id51677867293715"><variable id="h1"><link href="text/sdatabase/dabawiz02firebird.xhp">Firebird Connection</link></variable></h1> + <paragraph id="par_id401677867293719" role="paragraph" xml-lang="en-US">Specifies the options for connecting to Firebird external databases.</paragraph> +</section> + +<h2 id="hd_id251677867849494">Creating a new Firebird database file</h2> +<list type="ordered"> + <listitem> + <paragraph id="par_id101697868070614" role="listitem">Choose <menuitem>File - New - Database</menuitem> and select <emph>Connect to an existing database</emph>. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id301677867908874" role="listitem">Click <widget>Create</widget>. The <emph>Save As</emph> dialog opens. Enter a suitable name and location for the database file, and click <widget>Save</widget>. The path of the new file is displayed in the wizard’s text box. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id161677867944534" role="listitem">Optionally, enter your username and password. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id151677867957065" role="listitem">Decide your preferred options about registered database and what to do with the database once saved, and click <widget>Finish</widget>. Proceed to enter a name for the new %PRODUCTNAME Base file.</paragraph> + </listitem> +</list> + <note id="par_id401677867921758">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.</note> +<h2 id="hd_id361677867976296">Connect to an existing Firebird database file</h2> +<list type="ordered"> + <listitem> + <paragraph id="par_id101677868070614" role="listitem">Choose <menuitem>File - New - Database</menuitem> and select <emph>Connect to an existing database</emph>. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id911677870523239" role="listitem">Click <widget>Browse</widget> and select the Firebird file (*.fdb). Click the <widget>Open</widget> button; the full URL to the database file is displayed in the text box. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id761677868087380" role="listitem">Optionally, enter your username and password. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id781677868096809" role="listitem">Decide your preferred options about database registration and what to do with database once saved, and click <widget>Finish</widget>. Proceed to enter a name for the new %PRODUCTNAME Base file.</paragraph> + </listitem> +</list> +<h2 id="hd_id101677868045879">Connect directly to a Firebird server</h2> +<paragraph role="paragraph" id="par_id691677869556047">In addition to connections via JDBC and ODBC, you can connect to a Firebird server via the internal Firebird driver:</paragraph> +<list type="ordered"> + <listitem> + <paragraph id="par_id105677868070614" role="listitem">Choose <menuitem>File - New - Database</menuitem> and select <emph>Connect to an existing database</emph>. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id411677868640685" role="listitem">Manually enter the database connection URL in the text box. The pattern is <literal><servername>/<port>:<path_to_the_database></literal>, for example:</paragraph> + <paragraph id="par_id401677868302585" role="listitem"><literal>server1/3050:C:/data/mydatabase.fdb</literal> (note the “/” although it is a Windows path)</paragraph> + <paragraph id="par_id11677868316366" role="listitem"><literal>server1:C:/data/mydatabase.fdb</literal> (default port, Windows path)</paragraph> + <paragraph id="par_id381677868323697" role="listitem"><literal>localhost:/data/mydatabase.fdb</literal> (localhost server, default port, Linux path)</paragraph> + <paragraph id="par_id481677868332818" role="listitem"><literal>server1:mydata</literal> (default port, registered database)</paragraph> + </listitem> + <listitem> + <paragraph id="par_id481677868353090" role="listitem">Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id351677868361836" role="listitem">Provide a suitable username and password required for the server connection. Test the connection (recommended) and fix the issues, if any. Click <widget>Next</widget>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id601677868371635" role="listitem">Decide whether you want to register the database and what to do with it once saved, and click <widget>Finish</widget>. Enter a name for the new %PRODUCTNAME Base file.</paragraph> + </listitem> +</list> + <note id="par_id11677868344526">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.</note> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id301677871783123"><link href="https://www.firebirdsql.org/en/documentation/">Firebird documentation</link></paragraph> +</section> +</body> +</helpdocument> |