1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 30ba1032bSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 50ba1032bSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 60ba1032bSAndrew Rist * or more contributor license agreements. See the NOTICE file 70ba1032bSAndrew Rist * distributed with this work for additional information 80ba1032bSAndrew Rist * regarding copyright ownership. The ASF licenses this file 90ba1032bSAndrew Rist * to you under the Apache License, Version 2.0 (the 100ba1032bSAndrew Rist * "License"); you may not use this file except in compliance 110ba1032bSAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 130ba1032bSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 150ba1032bSAndrew Rist * Unless required by applicable law or agreed to in writing, 160ba1032bSAndrew Rist * software distributed under the License is distributed on an 170ba1032bSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 180ba1032bSAndrew Rist * KIND, either express or implied. See the License for the 190ba1032bSAndrew Rist * specific language governing permissions and limitations 200ba1032bSAndrew Rist * under the License. 21cdf0e10cSrcweir * 220ba1032bSAndrew Rist ***********************************************************--> 230ba1032bSAndrew Rist 24cdf0e10cSrcweir<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textsharedexplorerdatabase11020000xml" indexer="exclude" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">ODBC</title> 28cdf0e10cSrcweir<filename>/text/shared/explorer/database/11020000.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32cdf0e10cSrcweir<section id="odbc"> 33*33101c50Smseidel<paragraph role="heading" id="hd_id3149031" xml-lang="en-US" level="1" l10n="U"><link href="text/shared/explorer/database/11020000.xhp" name="ODBC">ODBC</link><comment>still some Help IDs in this file. Else it can be removed</comment></paragraph> 34*33101c50Smseidel<paragraph role="paragraph" id="par_id3150499" xml-lang="en-US" l10n="U"><ahelp hid="">Specifies the settings for <link href="text/shared/00/00000005.xhp#odbc" name="ODBC">ODBC</link> databases. This includes your user access data, driver settings, and font definitions.</ahelp></paragraph> 35cdf0e10cSrcweir</section> 36cdf0e10cSrcweir<section id="benutzername"> 37*33101c50Smseidel<paragraph role="heading" id="hd_id3148642" xml-lang="en-US" level="2" l10n="U">User Name</paragraph> 38*33101c50Smseidel<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US" l10n="U"><ahelp hid=".">Type the user name for accessing the database.</ahelp></paragraph> 39cdf0e10cSrcweir</section> 40cdf0e10cSrcweir<section id="passwort"> 41*33101c50Smseidel<paragraph role="heading" id="hd_id3153665" xml-lang="en-US" level="2" l10n="U">Password required</paragraph> 42*33101c50Smseidel<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US" l10n="U"><ahelp hid=".">Prevents an unauthorized user from accessing the database. You only need to enter the password once per session.</ahelp></paragraph> 43cdf0e10cSrcweir</section> 44cdf0e10cSrcweir<section id="treibereinstellungen"> 4577878c64Smseidel<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_ODBC_OPTIONS" id="bm_id3148473" localize="false"/> 46*33101c50Smseidel<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="2" l10n="U">Driver Settings</paragraph> 47*33101c50Smseidel<paragraph role="paragraph" id="par_id3143271" xml-lang="en-US" l10n="U"><ahelp hid="HID_DSADMIN_ODBC_OPTIONS">Use this text field to enter additional optional driver settings if this is necessary.</ahelp></paragraph> 48cdf0e10cSrcweir</section> 49cdf0e10cSrcweir<section id="zeichensatz"> 5077878c64Smseidel<!-- removed HID HID_DSADMIN_CHARSET_ODBC --> 51*33101c50Smseidel<paragraph role="heading" id="hd_id3152472" xml-lang="en-US" level="2" l10n="U">Character Set</paragraph> 52*33101c50Smseidel<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US" l10n="U"><ahelp hid="HID_DSADMIN_CHARSET_ODBC">Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.</ahelp> Choose "System" to use the default character set of your operating system. Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes.</paragraph> 53cdf0e10cSrcweir</section> 54cdf0e10cSrcweir<section id="retrieve"> 55*33101c50Smseidel<paragraph role="heading" id="hd_id3149669" xml-lang="en-US" level="2" l10n="U">General</paragraph> 5677878c64Smseidel<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_AUTORETRIEVEENABLED" id="bm_id3161657" localize="false"/> 57*33101c50Smseidel<paragraph role="heading" id="hd_id3147265" xml-lang="en-US" level="3" l10n="U">Retrieve generated values</paragraph> 58*33101c50Smseidel<paragraph role="paragraph" id="par_id3151054" xml-lang="en-US" l10n="U"><ahelp hid="HID_DSADMIN_AUTORETRIEVEENABLED">Enables $[officename] support of auto-incremented data fields for the current ODBC or JDBC data source.</ahelp> Select this check box if the database does not support the auto-increment feature in its SDBCX layer. In general, the auto-increment is selected for the primary key field.</paragraph> 5977878c64Smseidel<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_AUTOINCREMENTVALUE" id="bm_id3150792" localize="false"/> 60*33101c50Smseidel<paragraph role="heading" id="hd_id3150400" xml-lang="en-US" level="3" l10n="U">Auto-increment statement</paragraph> 61*33101c50Smseidel<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US" l10n="U"><ahelp hid="HID_DSADMIN_AUTOINCREMENTVALUE">Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field.</ahelp> For example, a typical SQL statement to create a data field is:</paragraph> 62*33101c50Smseidel<paragraph role="paragraph" id="par_id3159149" xml-lang="en-US" l10n="U">CREATE TABLE "table1" ("id" INTEGER)</paragraph> 63*33101c50Smseidel<paragraph role="paragraph" id="par_id3147084" xml-lang="en-US" l10n="U">To auto-increment the "id" data field in a MySQL database, change the statement to:</paragraph> 64*33101c50Smseidel<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US" l10n="U">CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT)</paragraph> 65*33101c50Smseidel<paragraph role="paragraph" id="par_id3152933" xml-lang="en-US" l10n="U">In other words, enter AUTO_INCREMENT into <emph>Auto-increment statement</emph> box.</paragraph> 6677878c64Smseidel<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_RETRIEVE_AUTO" id="bm_id3153195" localize="false"/> 67*33101c50Smseidel<paragraph role="heading" id="hd_id3149765" xml-lang="en-US" level="3" l10n="U">Query of generated values</paragraph> 68*33101c50Smseidel<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US" l10n="U"><ahelp hid="HID_DSADMIN_RETRIEVE_AUTO">Enter an SQL statement that returns the last auto-incremented value for the primary key data field.</ahelp> For example:</paragraph> 69*33101c50Smseidel<paragraph role="paragraph" id="par_id3150769" xml-lang="en-US" l10n="U">SELECT LAST_INSERT_D();</paragraph> 70cdf0e10cSrcweir</section> 71cdf0e10cSrcweir<section id="sql92"> 7277878c64Smseidel<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_SQL92CHECK" id="bm_id3147289" localize="false"/> 73*33101c50Smseidel<paragraph role="heading" id="hd_id3157892" xml-lang="en-US" level="3" l10n="U">Use SQL92 naming constraints</paragraph> 74*33101c50Smseidel<paragraph role="paragraph" id="par_id3153368" xml-lang="en-US" l10n="U"><ahelp hid="HID_DSADMIN_SQL92CHECK">Only allows names that use characters that conform to the SQL92 naming constraints in the data source. All other characters are rejected.</ahelp> Each name must begin with a lower or upper case letter, or an underline ( _ ). The remaining characters can be ASCII letters, underlines, and numbers.</paragraph> 75cdf0e10cSrcweir</section> 7677878c64Smseidel<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_USECATALOG" id="bm_id3146148" localize="false"/> 77*33101c50Smseidel<paragraph role="heading" id="hd_id3154011" xml-lang="en-US" level="3" l10n="U">Use Catalog for file-based databases</paragraph> 78*33101c50Smseidel<paragraph role="paragraph" id="par_id3148618" xml-lang="en-US" l10n="U"><ahelp hid="HID_DSADMIN_USECATALOG">Uses the current data source of the Catalog. This is useful when the ODBC data source is a database server. If the ODBC data source is a dBASE driver, leave this check box clear.</ahelp></paragraph> 79cdf0e10cSrcweir</body> 80cdf0e10cSrcweir</helpdocument> 81