1<?xml version="1.0" encoding="UTF-8"?> 2 3 4<!--*********************************************************************** 5 * 6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 7 * 8 * Copyright 2000, 2010 Oracle and/or its affiliates. 9 * 10 * OpenOffice.org - a multi-platform office productivity suite 11 * 12 * This file is part of OpenOffice.org. 13 * 14 * OpenOffice.org is free software: you can redistribute it and/or modify 15 * it under the terms of the GNU Lesser General Public License version 3 16 * only, as published by the Free Software Foundation. 17 * 18 * OpenOffice.org is distributed in the hope that it will be useful, 19 * but WITHOUT ANY WARRANTY; without even the implied warranty of 20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 21 * GNU Lesser General Public License version 3 for more details 22 * (a copy is included in the LICENSE file that accompanied this code). 23 * 24 * You should have received a copy of the GNU Lesser General Public License 25 * version 3 along with OpenOffice.org. If not, see 26 * <http://www.openoffice.org/license.html> 27 * for a copy of the LGPLv3 License. 28 * 29 ************************************************************************--> 30 31 32<helpdocument version="1.0"> 33<meta> 34<topic id="textsharedexplorerdatabasedabawiz02odbcxml" indexer="include" status="PUBLISH"> 35<title id="tit" xml-lang="en-US">ODBC Connection</title> 36<filename>/text/shared/explorer/database/dabawiz02odbc.xhp</filename> 37</topic> 38<history> 39<created date="2004-07-28T16:27:31">UFI: Database Wizard ODBC page</created> 40<lastedited date="2006-05-02T14:15:18">YJ: checked</lastedited> 41</history> 42</meta> 43<body> 44<bookmark xml-lang="en-US" branch="index" id="bm_id3149031"><bookmark_value>ODBC;database (Base)</bookmark_value> 45<bookmark_value>databases;ODBC (Base)</bookmark_value> 46</bookmark><comment>mw added "(Base)" to all entries</comment> 47<paragraph role="heading" id="par_idN1053D" xml-lang="en-US" level="1" l10n="NEW"><variable id="odbc"><link href="text/shared/explorer/database/dabawiz02odbc.xhp">ODBC Connection</link> 48</variable></paragraph> 49<paragraph role="paragraph" id="par_idN10541" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies the settings for <link href="text/shared/00/00000005.xhp#odbc" name="ODBC">ODBC</link> databases.</ahelp></paragraph> 50<paragraph role="paragraph" id="par_id8856776" xml-lang="en-US" l10n="NEW">To edit or add records to a database table in $[officename], the table must have a unique index field.</paragraph> 51<paragraph role="paragraph" id="par_id8034302" xml-lang="en-US" l10n="NEW">On Solaris and Linux platforms, try to use a JDBC driver instead of an ODBC driver. See http://www.unixodbc.org for an ODBC implementation on Solaris or Linux.</paragraph> 52<paragraph role="paragraph" id="par_id8560136" xml-lang="en-US" l10n="NEW">To connect to a Microsoft Access database on Windows, use the ADO or Access database interface, rather than ODBC.</paragraph> 53<paragraph role="note" id="par_id2082583" xml-lang="en-US" l10n="NEW">Drivers for ODBC are supplied and supported by the manufacturer of the database. $[officename] only supports the ODBC 3 standard.</paragraph> 54<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_ODBC_ET_NAMEOFODBCDATASOURCE" id="bm_id9201025" localize="false"/> 55<paragraph role="heading" id="par_idN10552" xml-lang="en-US" level="2" l10n="NEW">Name of the ODBC database</paragraph> 56<paragraph role="paragraph" id="par_idN10556" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the path to the database file.</ahelp></paragraph> 57<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_PAGE_DBWIZARD_ODBC_PB_NAMEOFODBCDATASOURCE" id="bm_id5588549" localize="false"/> 58<paragraph role="heading" id="par_idN10559" xml-lang="en-US" level="2" l10n="NEW">Browse</paragraph> 59<paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Click to open an ODBC data source selection dialog:</ahelp></paragraph> 60<paragraph role="heading" id="par_idN10560" xml-lang="en-US" level="3" l10n="NEW">Choose a data source</paragraph> 61<paragraph role="paragraph" id="par_idN10564" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select a data source to which you want to connect using ODBC. Then click <emph>OK</emph>.</ahelp></paragraph> 62<paragraph role="paragraph" id="par_idN10567" xml-lang="en-US" l10n="NEW"><link href="text/shared/explorer/database/dabawiz03auth.xhp">Authentication</link></paragraph> 63<paragraph role="paragraph" id="par_idN10576" xml-lang="en-US" l10n="NEW"><link href="text/shared/explorer/database/dabawiz00.xhp">Database Wizard</link></paragraph> 64</body> 65</helpdocument> 66