diff options
Diffstat (limited to 'source/text/sdatabase/dabawiz02firebird.xhp')
| -rw-r--r-- | source/text/sdatabase/dabawiz02firebird.xhp | 89 |
1 files changed, 89 insertions, 0 deletions
diff --git a/source/text/sdatabase/dabawiz02firebird.xhp b/source/text/sdatabase/dabawiz02firebird.xhp new file mode 100644 index 0000000000..b2206ef395 --- /dev/null +++ b/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 on Next.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id301677867908874" role="listitem">Click on Create. The Save as dialog opens. Enter a suitable name and location for the database file, and click on Save. The path of the new file is displayed in the wizard text box. Click Next.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id161677867944534" role="listitem">Optionally, enter your username and password. Click on Next.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id151677867957065" role="listitem">Decide your preferred options about registered database and what to do with database once saved, and click Finish. Proceed entering a name to the new %PRODUCTNAME Base file.</paragraph> + </listitem> +</list> + <note id="par_id401677867921758">This name is the name of the new Firebird database file (*.fdb), not the name of the %PRODUCTNAME Base (*.odb) file.</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 on Next</paragraph> + </listitem> + <listitem> + <paragraph id="par_id911677870523239" role="listitem">Click on Browse and navigate to select the Firebird file (*.fdb). Click on Open button, the complete URL to the database file is displayed in the text box. Click on Next.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id761677868087380" role="listitem">Optionally, enter your username and password. Click on Next.</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 Finish. Proceed entering a name to 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 on Next</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 on Next.</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 Next.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id601677868371635" role="listitem">Decide about registered database and what to do with database once saved, and click Finish. Proceed entering a name to the new %PRODUCTNAME Base file.</paragraph> + </listitem> +</list> + <note id="par_id11677868344526">You can add some other options to the database URL, like charset or role. See Firebird documentation to know about</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> |