Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\btrieve.20.06.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Connection Option Descriptions</title> <link rel="StyleSheet" href="css/btrieve.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="btrieve.20.01.html#108482">15 The Btrieve (Pervasive.SQL) Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="108482">Connection Option Descriptions</a></div> <div class="Body"><a name="132864">The following connection option descriptions are listed alphabetically by the GUI name that </a>appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name. </div> <div class="Body"><a name="132865">In most cases, the GUI name and the attribute name are the same; however, some </a>exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.</div> <div class="Body"><a name="132866">Also, a few connection string attributes, for example, Password, do not have equivalent </a>options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.</div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#111018', '');" name="111008">Table 15-1</a></span> lists the connection string attributes supported by the Btrieve driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 15-1. <a name="111018">Btrieve Attribute Names</a> </div> </caption> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="111022">Attribute (Short Name)</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="111024">Default</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#112679', '');" name="117924">ApplicationUsingThreads (AUT)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117926">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#108523', '');" name="117917">ArraySize (AS)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117919">4096</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#108576', '');" name="117931">Database (DB)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117933">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#108538', '');" name="117945">DataFileExtension (DFE)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117947">DTA</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#112914', '');" name="117938">DataSourceName (DSN)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117940">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#113181', '');" name="117966">Description (n/a)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117968">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#108621', '');" name="117959">FileOpenCache (FOC)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117961">0 (No File Open Caching)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#108636', '');" name="117952">IntlSort (IS)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117954">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#113102', '');" name="117973">LogonID (UID)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117975">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#113703', '');" name="117980">Password (PWD)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117982">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#108490', '');" name="117987">UndefinedTable (UT)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="117989">Error</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.06.html#108668', '');" name="118001">UseLongQualifiers (ULQ)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="118003">0 (Disabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="108488">Action for Undefined Tables</a></div> <div class="gutter_text_right"><a name="108489">Attribute</a></div> <div class="Body_attr"><a name="108490">UndefinedTable (UT)</a></div> <div class="gutter_text_right"><a name="108491">Description</a></div> <div class="Body"><a name="132955">Determines whether the driver prompts the user when it encounters a table for which it has </a>no structure information.</div> <div class="gutter_text_right"><a name="109222">Valid Values</a></div> <div class="Body"><a name="117010">PROMPT | ERROR</a></div> <div class="Body"><a name="117011">Specify PROMPT to prompt the user.</a></div> <div class="Body"><a name="117012">Specify ERROR to return an error.</a></div> <div class="gutter_text_right"><a name="116992">Default</a></div> <div class="Body"><a name="116993">ERROR (driver returns an error)</a></div> <div class="gutter_text_right"><a name="112641">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="108502">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="112676">Application Using Threads</a></div> <div class="gutter_text_right"><a name="112677">Attribute</a></div> <div class="Body_attr"><a name="112679">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="112680">Description</a></div> <div class="Body"><a name="132830">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="gutter_text_right"><a name="112686">Valid Values</a></div> <div class="Body"><a name="132870">0 | 1</a></div> <div class="Body"><a name="132871">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="132872">If set to 0 (Disabled), the driver does not work with multi-threaded applications. If using the </a>driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.</div> <div class="gutter_text_right"><a name="112693">Default</a></div> <div class="Body"><a name="112695">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="118302">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="118307">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="108521">Array Size</a></div> <div class="gutter_text_right"><a name="108522">Attribute</a></div> <div class="Body_attr"><a name="108523">ArraySize (AS)</a></div> <div class="gutter_text_right"><a name="108850">Description</a></div> <div class="Body"><a name="108524">The number of bytes in the array. This connection option enables the driver to retrieve an </a>array of records from the Btrieve database and, in most cases, results in improved performance for the application. </div> <div class="gutter_text_right"><a name="109252">Valid Values</a></div> <div class="Body"><a name="109253">A positive integer from 1 to 65535</a></div> <div class="gutter_text_right"><a name="108525">Default</a></div> <div class="Body"><a name="108526">4096</a></div> <div class="gutter_text_right"><a name="118327">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="118332">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="108536">Data File Extension</a></div> <div class="gutter_text_right"><a name="108537">Attribute</a></div> <div class="Body_attr"><a name="108538">DataFileExtension (DFE)</a></div> <div class="gutter_text_right"><a name="108860">Description</a></div> <div class="Body"><a name="132923">A one- to three-character file name extension to use for data files.</a></div> <div class="gutter_text_right"><a name="109277">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="132927">ext</a></span></div> <div class="Body"><a name="132928">where </a><span class="EquationVariables">ext</span> is the name of the one- to three-character file name extension.</div> <div class="Body"><a name="132929">This value is used for all Create Table statements. Sending a Create Table using an </a>extension other than the value specified for this option causes an error.</div> <div class="Body"><a name="132930">In other SQL statements, such as Select or Insert, users can specify an extension other </a>than the one specified for this connection option. The Data File Extension value is used when no extension is specified.</div> <div class="gutter_text_right"><a name="108541">Default</a></div> <div class="Body"><a name="108542">DTA</a></div> <div class="gutter_text_right"><a name="118352">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="118357">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="112911">Data Source Name</a></div> <div class="gutter_text_right"><a name="112912">Attribute</a></div> <div class="Body_attr"><a name="112914">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="112915">Description</a></div> <div class="Body"><a name="132876">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="112920">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="132880">string</a></span> </div> <div class="Body"><a name="132881">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="112926">Default</a></div> <div class="Body"><a name="112928">None</a></div> <div class="gutter_text_right"><a name="112967">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106304', '');" name="112972">G</a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106304', '');">eneral tab</a></span></div> <div class="head_2_no_TOC"><a name="108574">Database Directory</a></div> <div class="gutter_text_right"><a name="108575">Attribute</a></div> <div class="Body_attr"><a name="108576">Database (DB)</a></div> <div class="gutter_text_right"><a name="108885">Description</a></div> <div class="Body"><a name="132914">The directory that contains the data files.</a></div> <div class="gutter_text_right"><a name="114097">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="132918">database_directory</a></span></div> <div class="Body"><a name="132919">where </a><span class="EquationVariables">database_directory</span> is the full path name of the directory in which the data files are stored. If no directory is specified, the current working directory is used.</div> <div class="Body"><a name="108578">This includes both Btrieve files and the data dictionary files (.DDF). Data dictionary files </a>describe the structure of Btrieve data.</div> <div class="gutter_text_right"><a name="114027">Default</a></div> <div class="Body"><a name="108579">None</a></div> <div class="gutter_text_right"><a name="118417">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106304', '');" name="118423">G</a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106304', '');">eneral tab</a></span></div> <div class="head_2_no_TOC"><a name="108589">Default Logon ID</a></div> <div class="gutter_text_right"><a name="113100">Attribute</a></div> <div class="Body_attr"><a name="113102">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="113103">Description</a></div> <div class="Body"><a name="132885">The default user ID that is used to connect to your database. Your ODBC application may </a>override this value or you may override it in the logon dialog box or connection string.</div> <div class="gutter_text_right"><a name="113108">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="132889">userid</a></span></div> <div class="Body"><a name="132890">where </a><span class="EquationVariables">userid</span> is a valid user ID with permissions to access the database.</div> <div class="gutter_text_right"><a name="113114">Default</a></div> <div class="Body"><a name="113115">None</a></div> <div class="gutter_text_right"><a name="118369">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="118374">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="108604">Description</a></div> <div class="gutter_text_right"><a name="113179">Attribute</a></div> <div class="Body_attr"><a name="113181">Description (n/a)</a></div> <div class="gutter_text_right"><a name="113182">Description</a></div> <div class="Body"><a name="132854">An optional long description of a data source. This description is not used as a runtime </a>connection attribute, but does appear in the ODBC.INI section of the Registry and in the odbc.ini file.</div> <div class="gutter_text_right"><a name="113187">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="132894">string</a></span> </div> <div class="Body"><a name="132895">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="113193">Default</a></div> <div class="Body"><a name="113194">None</a></div> <div class="gutter_text_right"><a name="118431">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106304', '');" name="118437">G</a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106304', '');">eneral tab</a></span></div> <div class="head_2_no_TOC"><a name="110091">File Open Cache</a></div> <div class="gutter_text_right"><a name="108620">Attribute</a></div> <div class="Body_attr"><a name="108621">FileOpenCache (FOC)</a></div> <div class="gutter_text_right"><a name="108908">Description</a></div> <div class="Body"><a name="132941">The maximum number of used file handles to cache.</a></div> <div class="gutter_text_right"><a name="109309">Valid Values</a></div> <div class="Body"><a name="132934">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="132935">where </a><span class="EquationVariables">x</span> is a positive integer.</div> <div class="Body"><a name="132936">If set to 0, no file open caching is performed.</a></div> <div class="Body"><a name="132937">If set to </a><span class="EquationVariables">x</span>, when a user opens and closes <span class="EquationVariables">x</span> tables, the tables are not actually closed. The driver keeps them open so that if another query uses one of these tables, the driver does not have to perform another open, which is expensive. The advantage of file open caching is improved performance. The disadvantage is that a user who tries to open the file exclusively may get a file locking conflict even though no one appears to have the file open.</div> <div class="gutter_text_right"><a name="118956">Default</a></div> <div class="Body"><a name="118957">0 (No File Open Caching)</a></div> <div class="gutter_text_right"><a name="118958">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="118963">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="108634">International Sort</a></div> <div class="gutter_text_right"><a name="108635">Attribute</a></div> <div class="Body_attr"><a name="108636">IntlSort (IS)</a></div> <div class="gutter_text_right"><a name="108914">Description</a></div> <div class="Body"><a name="132899">Uses international sort order as defined by your operating system when you issue a Select </a>statement with an Order By clause.</div> <div class="gutter_text_right"><a name="109325">Valid Values</a></div> <div class="Body"><a name="132903">0 | 1</a></div> <div class="Body"><a name="132904">If set to 1 (Enabled), this order is always alphabetic, regardless of case; the letters are </a>sorted as "A, b, C." Refer to your operating system documentation concerning the sorting of accented characters.</div> <div class="Body"><a name="132905">If set to 0 (Disabled), ASCII sort order is used. This order sorts items alphabetically with </a>uppercase letters preceding lowercase letters. For example, "A, b, C" is sorted as "A, C, b."</div> <div class="gutter_text_right"><a name="108639">Default</a></div> <div class="Body"><a name="108640">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="118391">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="119212">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="119214">Password</a></div> <div class="gutter_text_right"><a name="119215">Attribute</a></div> <div class="Body_attr"><a name="113703">Password (PWD)</a></div> <div class="gutter_text_right"><a name="113704">Description</a></div> <div class="Body"><a name="113707">The password that you must enter if your Scalable SQL data dictionary files have security </a>restrictions set. The Password option cannot be specified through the Administrator GUI.</div> <div class="gutter_text_right"><a name="113709">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="132909">pwd</a></span> </div> <div class="Body"><a name="132910">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="113715">Default</a></div> <div class="Body"><a name="113716">None</a></div> <div class="gutter_text_right"><a name="120763">GUI Tab</a></div> <div class="Body"><a name="120796">n/a</a></div> <div class="head_2_no_TOC"><a name="108666">Use Long Qualifiers</a></div> <div class="gutter_text_right"><a name="108667">Attribute</a></div> <div class="Body_attr"><a name="108668">UseLongQualifiers (ULQ)</a></div> <div class="gutter_text_right"><a name="108934">Description</a></div> <div class="Body"><a name="132951">Determines whether the driver uses long path names.</a></div> <div class="gutter_text_right"><a name="109345">Valid Values</a></div> <div class="Body"><a name="132945">0 | 1</a></div> <div class="Body"><a name="132946">If set to 1 (Enabled), path names can be a maximum of 255 characters.</a></div> <div class="Body"><a name="132947">If set to 0 (Disabled), path names can be a maximum of 128 characters.</a></div> <div class="gutter_text_right"><a name="108670">Default</a></div> <div class="Body"><a name="108671">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="118404">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'btrieve.20.05.html#106320', '');" name="118409">Advanced tab</a></span></div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de