1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
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>
|
