helpcontent2/source/text/sdatabase/dabapropgen.xhp


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

<?xml version="1.0" encoding="UTF-8"?>
<!--
 * This file is part of the LibreOffice 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/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   Licensed to the Apache Software Foundation (ASF) under one or more
 *   contributor license agreements. See the NOTICE file distributed
 *   with this work for additional information regarding copyright
 *   ownership. The ASF licenses this file to you under the Apache
 *   License, Version 2.0 (the "License"); you may not use this file
 *   except in compliance with the License. You may obtain a copy of
 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
 -->
<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabasedabapropgenxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Advanced Properties</title>
<filename>/text/sdatabase/dabapropgen.xhp</filename>
</topic>
</meta>
<body>
<section id="dabapropgen">
<h1 id="par_idN1054D"><link href="text/sdatabase/dabapropgen.xhp">Advanced Properties</link></h1>
<paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US">Specifies some options for a database.</paragraph>
</section>
<section id="howtoget">
<paragraph role="paragraph" id="par_id4513992" xml-lang="en-US">In a database window, choose <emph>Edit - Database - Properties</emph>, click <emph>Advanced Properties</emph> tab</paragraph>
</section>
<paragraph role="paragraph" id="par_idN10572" xml-lang="en-US">The availability of the following controls depends on the type of database:</paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_DBASE_PATH" id="bm_id4886623" localize="false"/><h2 id="par_idN10575">Path to dBASE files<comment>UFI: found for dBase</comment></h2>
<paragraph role="paragraph" id="par_idN10579" xml-lang="en-US"><ahelp hid=".">Enter the path to the directory that contains the dBASE files.</ahelp></paragraph>
<warning id="par_idN1057C">Ensure that the *.dbf file name extension of the dBASE files is lowercase.<comment>moved from shared\explorer\database\11030000.xhp</comment></warning>
<h2 id="par_idN10591">Browse<comment>UFI: found for dBase</comment></h2>
<paragraph role="paragraph" id="par_idN10595" xml-lang="en-US"><ahelp hid=".">Opens a dialog where you can select a file or a directory.</ahelp><comment>which one? or depends?</comment></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/connectionpage/connectionButton" id="bm_id7854243" localize="false"/><h2 id="par_idN105AA">Test Connection<comment>UFI: found for dBase</comment><comment>and for Calc doc</comment></h2>
<paragraph role="paragraph" id="par_idN105AE" xml-lang="en-US"><ahelp hid=".">Tests the database connection with the current settings.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_FLAT_PATH" id="bm_id4529251" localize="false"/><h2 id="par_idN105B1">Path to the text files<comment>UFI: found for text file folder</comment></h2>
<paragraph role="paragraph" id="par_idN105B5" xml-lang="en-US"><ahelp hid=".">Enter the path to the folder of the text files.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_CALC_PATH" id="bm_id8492385" localize="false"/><h2 id="par_idN105B8">Path to the spreadsheet document<comment>UFI: found for a Calc doc</comment></h2>
<paragraph role="paragraph" id="par_idN105BC" xml-lang="en-US"><ahelp hid=".">Enter the path to the spreadsheet document that you want to use as a database.</ahelp></paragraph>
<h2 id="par_idN105BF">Name of the ODBC data source on your system</h2>
<paragraph role="paragraph" id="par_idN105C3" xml-lang="en-US"><ahelp hid=".">Enter the name of the ODBC data source.</ahelp></paragraph>
<h2 id="par_idN105C6">User name</h2>
<paragraph role="paragraph" id="par_idN105CA" xml-lang="en-US"><ahelp hid=".">Enter the user name that is required to access the database.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/connectionpage/passCheckbutton" id="bm_id4072084" localize="false"/><h2 id="par_idN105CD">Password required<comment>UFI: found for Calc doc</comment></h2>
<paragraph role="paragraph" id="par_idN105D1" xml-lang="en-US"><ahelp hid=".">If checked, the user will be asked to enter the password that is required to access the database.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_JDBC_ET_MYSQLDBNAME" id="bm_id7675099" localize="false"/><h2 id="hd_id7806329">Name of the database<comment>UFI: found for JDBC</comment></h2>
<paragraph role="paragraph" id="par_id5589159" xml-lang="en-US"><ahelp hid=".">Enter the name of the database.</ahelp></paragraph>
<h2 id="par_idN105D4">Name of the MySQL database</h2>
<paragraph role="paragraph" id="par_idN105D8" xml-lang="en-US"><ahelp hid=".">Enter the name of the MySQL database that you want to use as a data source.</ahelp></paragraph>
<h2 id="par_idN105DB">Name of the Oracle database</h2>
<paragraph role="paragraph" id="par_idN105DF" xml-lang="en-US"><ahelp hid=".">Enter the name of the Oracle database that you want to use as a data source.</ahelp></paragraph>
<h2 id="par_idN105E9">Microsoft Access database file</h2>
<paragraph role="paragraph" id="par_idN105ED" xml-lang="en-US"><ahelp hid=".">Enter the name of the Microsoft Access database file that you want to use as a data source.</ahelp></paragraph>
<h2 id="par_idN105F0">Host name</h2>
<paragraph role="paragraph" id="par_idN105F4" xml-lang="en-US"><ahelp hid=".">Enter the host name for the LDAP data source.</ahelp></paragraph>
<h2 id="par_idN105F7">Data source URL</h2>
<paragraph role="paragraph" id="par_idN105FB" xml-lang="en-US"><ahelp hid=".">Enter the location of the JDBC data source as a URL.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_JDBC_ET_MYSQLCLASS" id="bm_id9936216" localize="false"/>
<!-- removed HID 39110 --><h2 id="par_idN105FE">JDBC driver class</h2>
<paragraph role="paragraph" id="par_idN10602" xml-lang="en-US"><ahelp hid=".">Enter the name of the JDBC driver class that connects to the data source.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_JDBC_PB_TESTMYSQLCLASS" id="bm_id7953123" localize="false"/>
<!-- removed HID 39111 --><h2 id="par_idN10605">Test Class<comment>UFI: found for JDBC</comment></h2>
<paragraph role="paragraph" id="par_idN10609" xml-lang="en-US"><ahelp hid=".">Tests the database connection through the JDBC driver class.</ahelp></paragraph>
<h3 id="par_idN10613">Choose a database</h3>
<paragraph role="paragraph" id="par_idN10617" xml-lang="en-US"><ahelp hid=".">Select a database from the list or click <emph>Create</emph> to create a new database.</ahelp></paragraph>
</body>
</helpdocument>