1 <?xml version=
"1.0" encoding=
"UTF-8"?>
4 <!--***********************************************************************
6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 * Copyright 2008 by Sun Microsystems, Inc.
10 * OpenOffice.org - a multi-platform office productivity suite
12 * $RCSfile: dabawiz02odbc.xhp,v $
15 * This file is part of OpenOffice.org.
17 * OpenOffice.org is free software: you can redistribute it and/or modify
18 * it under the terms of the GNU Lesser General Public License version 3
19 * only, as published by the Free Software Foundation.
21 * OpenOffice.org is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Lesser General Public License version 3 for more details
25 * (a copy is included in the LICENSE file that accompanied this code).
27 * You should have received a copy of the GNU Lesser General Public License
28 * version 3 along with OpenOffice.org. If not, see
29 * <http://www.openoffice.org/license.html>
30 * for a copy of the LGPLv3 License.
32 ************************************************************************-->
35 <helpdocument version=
"1.0">
37 <topic id=
"textsharedexplorerdatabasedabawiz02odbcxml" indexer=
"include" status=
"PUBLISH">
38 <title id=
"tit" xml-lang=
"en-US">ODBC Connection
</title>
39 <filename>/text/shared/explorer/database/dabawiz02odbc.xhp
</filename>
42 <created date=
"2004-07-28T16:27:31">UFI: Database Wizard ODBC page
</created>
43 <lastedited date=
"2006-05-02T14:15:18">YJ: checked
</lastedited>
47 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3149031"><bookmark_value>ODBC;database (Base)
</bookmark_value>
48 <bookmark_value>databases;ODBC (Base)
</bookmark_value>
49 </bookmark><comment>mw added
"(Base)" to all entries
</comment>
50 <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>
51 </variable></paragraph>
52 <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>
53 <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>
54 <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>
55 <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>
56 <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>
57 <bookmark xml-lang=
"en-US" branch=
"hid/HID_PAGE_DBWIZARD_ODBC_ET_NAMEOFODBCDATASOURCE" id=
"bm_id9201025" localize=
"false"/>
58 <paragraph role=
"heading" id=
"par_idN10552" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Name of the ODBC database
</paragraph>
59 <paragraph role=
"paragraph" id=
"par_idN10556" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Enter the path to the database file.
</ahelp></paragraph>
60 <bookmark xml-lang=
"en-US" branch=
"hid/HID_PAGE_DBWIZARD_ODBC_PB_NAMEOFODBCDATASOURCE" id=
"bm_id5588549" localize=
"false"/>
61 <paragraph role=
"heading" id=
"par_idN10559" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Browse
</paragraph>
62 <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>
63 <paragraph role=
"heading" id=
"par_idN10560" xml-lang=
"en-US" level=
"3" l10n=
"NEW">Choose a data source
</paragraph>
64 <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>
65 <paragraph role=
"paragraph" id=
"par_idN10567" xml-lang=
"en-US" l10n=
"NEW"><link href=
"text/shared/explorer/database/dabawiz03auth.xhp">Authentication
</link></paragraph>
66 <paragraph role=
"paragraph" id=
"par_idN10576" xml-lang=
"en-US" l10n=
"NEW"><link href=
"text/shared/explorer/database/dabawiz00.xhp">Database Wizard
</link></paragraph>