1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4cdf0e10cSrcweir 5*226a8927SAndrew Rist<!--*********************************************************** 6cdf0e10cSrcweir * 7*226a8927SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 8*226a8927SAndrew Rist * or more contributor license agreements. See the NOTICE file 9*226a8927SAndrew Rist * distributed with this work for additional information 10*226a8927SAndrew Rist * regarding copyright ownership. The ASF licenses this file 11*226a8927SAndrew Rist * to you under the Apache License, Version 2.0 (the 12*226a8927SAndrew Rist * "License"); you may not use this file except in compliance 13*226a8927SAndrew Rist * with the License. You may obtain a copy of the License at 14cdf0e10cSrcweir * 15*226a8927SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 16cdf0e10cSrcweir * 17*226a8927SAndrew Rist * Unless required by applicable law or agreed to in writing, 18*226a8927SAndrew Rist * software distributed under the License is distributed on an 19*226a8927SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*226a8927SAndrew Rist * KIND, either express or implied. See the License for the 21*226a8927SAndrew Rist * specific language governing permissions and limitations 22*226a8927SAndrew Rist * under the License. 23cdf0e10cSrcweir * 24*226a8927SAndrew Rist ***********************************************************--> 25*226a8927SAndrew Rist 26*226a8927SAndrew Rist 27cdf0e10cSrcweir 28cdf0e10cSrcweir 29cdf0e10cSrcweir <helpdocument version="1.0"> 30cdf0e10cSrcweir<meta> 31cdf0e10cSrcweir<topic id="textsharedexplorerdatabasedabapropgenxml" indexer="include" status="PUBLISH"> 32cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Advanced Properties</title> 33cdf0e10cSrcweir<filename>/text/shared/explorer/database/dabapropgen.xhp</filename> 34cdf0e10cSrcweir</topic> 35cdf0e10cSrcweir</meta> 36cdf0e10cSrcweir<body> 37cdf0e10cSrcweir<section id="dabapropgen"> 38cdf0e10cSrcweir<paragraph role="heading" id="par_idN1054D" xml-lang="en-US" level="1" l10n="CHG"><link href="text/shared/explorer/database/dabapropgen.xhp">Advanced Properties</link></paragraph> 39cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US" l10n="CHG">Specifies some options for a database.</paragraph> 40cdf0e10cSrcweir</section> 41cdf0e10cSrcweir<section id="howtoget"> 42cdf0e10cSrcweir<paragraph role="paragraph" id="par_id4513992" xml-lang="en-US" l10n="NEW">In a database window, choose <emph>Edit - Database - Properties</emph>, click <emph>Advanced Properties</emph> tab</paragraph> 43cdf0e10cSrcweir</section> 44cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10572" xml-lang="en-US" l10n="NEW">The availability of the following controls depends on the type of database:</paragraph> 45cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_DBASE_PATH" id="bm_id4886623" localize="false"/><paragraph role="heading" id="par_idN10575" xml-lang="en-US" level="2" l10n="NEW">Path to dBASE files<comment>UFI: found for dBase</comment></paragraph> 46cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10579" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the path to the directory that contains the dBASE files.</ahelp></paragraph> 47cdf0e10cSrcweir<paragraph role="warning" id="par_idN1057C" xml-lang="en-US" l10n="NEW">Ensure that the *.dbf file name extension of the dBASE files is lowercase.<comment>moved from shared\explorer\database\11030000.xhp</comment></paragraph> 48cdf0e10cSrcweir<paragraph role="heading" id="par_idN10591" xml-lang="en-US" level="2" l10n="NEW">Browse<comment>UFI: found for dBase</comment></paragraph> 49cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10595" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Opens a dialog where you can select a file or a directory.</ahelp><comment>which one? or depends?</comment></paragraph> 50cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/dbaccess:PushButton:PAGE_CONNECTION:PB_TESTCONNECTION" id="bm_id7854243" localize="false"/><paragraph role="heading" id="par_idN105AA" xml-lang="en-US" level="2" l10n="NEW">Test Connection<comment>UFI: found for dBase</comment><comment>and for Calc doc</comment></paragraph> 51cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105AE" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Tests the database connection with the current settings.</ahelp></paragraph> 52cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_FLAT_PATH" id="bm_id4529251" localize="false"/><paragraph role="heading" id="par_idN105B1" xml-lang="en-US" level="2" l10n="NEW">Path to the text files<comment>UFI: found for text file folder</comment></paragraph> 53cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105B5" xml-lang="en-US" l10n="CHG"><ahelp hid=".">Enter the path to the folder of the text files.</ahelp></paragraph> 54cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_CALC_PATH" id="bm_id8492385" localize="false"/><paragraph role="heading" id="par_idN105B8" xml-lang="en-US" level="2" l10n="NEW">Path to the spreadsheet document<comment>UFI: found for a Calc doc</comment></paragraph> 55cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105BC" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the path to the spreadsheet document that you want to use as a database.</ahelp></paragraph> 56cdf0e10cSrcweir<paragraph role="heading" id="par_idN105BF" xml-lang="en-US" level="2" l10n="NEW">Name of the ODBC data source on your system</paragraph> 57cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105C3" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the ODBC data source.</ahelp></paragraph> 58cdf0e10cSrcweir<paragraph role="heading" id="par_idN105C6" xml-lang="en-US" level="2" l10n="NEW">User name</paragraph> 59cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105CA" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the user name that is required to access the database.</ahelp></paragraph> 60cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/dbaccess:CheckBox:PAGE_CONNECTION:CB_PASSWORD_REQUIRED" id="bm_id4072084" localize="false"/><paragraph role="heading" id="par_idN105CD" xml-lang="en-US" level="2" l10n="NEW">Password required<comment>UFI: found for Calc doc</comment></paragraph> 61cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105D1" xml-lang="en-US" l10n="NEW"><ahelp hid=".">If checked, the user will be asked to enter the password that is required to access the database.</ahelp></paragraph> 62cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_JDBC_ET_MYSQLDBNAME" id="bm_id7675099" localize="false"/><paragraph role="heading" id="hd_id7806329" xml-lang="en-US" level="2" l10n="NEW">Name of the database<comment>UFI: found for JDBC</comment></paragraph> 63cdf0e10cSrcweir<paragraph role="paragraph" id="par_id5589159" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the database.</ahelp></paragraph> 64cdf0e10cSrcweir<paragraph role="heading" id="par_idN105D4" xml-lang="en-US" level="2" l10n="NEW">Name of the MySQL database</paragraph> 65cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105D8" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the MySQL database that you want to use as a data source.</ahelp></paragraph> 66cdf0e10cSrcweir<paragraph role="heading" id="par_idN105DB" xml-lang="en-US" level="2" l10n="NEW">Name of the Oracle database</paragraph> 67cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105DF" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the Oracle database that you want to use as a data source.</ahelp></paragraph> 68cdf0e10cSrcweir<paragraph role="heading" id="par_idN105E9" xml-lang="en-US" level="2" l10n="NEW">Microsoft Access database file</paragraph> 69cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105ED" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the Microsoft Access database file that you want to use as a data source.</ahelp></paragraph> 70cdf0e10cSrcweir<paragraph role="heading" id="par_idN105F0" xml-lang="en-US" level="2" l10n="NEW">Host name</paragraph> 71cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105F4" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the host name for the LDAP data source.</ahelp></paragraph> 72cdf0e10cSrcweir<paragraph role="heading" id="par_idN105F7" xml-lang="en-US" level="2" l10n="NEW">Data source URL</paragraph> 73cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105FB" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the location of the JDBC data source as a URL.</ahelp></paragraph> 74cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_JDBC_ET_MYSQLCLASS" id="bm_id9936216" localize="false"/> 75cdf0e10cSrcweir<!-- removed HID 39110 --><paragraph role="heading" id="par_idN105FE" xml-lang="en-US" level="2" l10n="NEW">JDBC driver class</paragraph> 76cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10602" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the JDBC driver class that connects to the data source.</ahelp></paragraph> 77cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_JDBC_PB_TESTMYSQLCLASS" id="bm_id7953123" localize="false"/> 78cdf0e10cSrcweir<!-- removed HID 39111 --><paragraph role="heading" id="par_idN10605" xml-lang="en-US" level="2" l10n="NEW">Test Class<comment>UFI: found for JDBC</comment></paragraph> 79cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10609" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Tests the database connection through the JDBC driver class.</ahelp></paragraph> 80cdf0e10cSrcweir<paragraph role="heading" id="par_idN10613" xml-lang="en-US" level="3" l10n="NEW">Choose a database</paragraph> 81cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10617" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select a database from the list or click <emph>Create</emph> to create a new database.</ahelp></paragraph> 82cdf0e10cSrcweir</body> 83cdf0e10cSrcweir</helpdocument> 84