Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\xml.24.08.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/xml.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="xml.24.01.html#121382">19 The XML Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="121382">Connection Option Descriptions</a></div> <div class="Body"><a name="123910">The following connection option descriptions are listed alphabetically by the GUI name that </a>appears on the driver Setup dialog. The connection string attribute name is listed immediately underneath the GUI name. For example:</div> <div class="hanging_label_head"><a name="123911">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="123912">Attribute</a></div> <div class="Body"><a name="123914">ReportCodepageConversionErrors</a></div> <div class="Body"><a name="123915">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="123916">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"><a name="122161">NOTE: XML driver connection string attributes do not use short name equivalents.</a></div> <div class="head_2"><a name="111971">Driver Setup Dialog Box Descriptions</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.08.html#113756', '');" name="113746">Table 19-2</a></span> lists the connection string attributes associated with General, Advanced, and Options tabs of the XML driver Setup dialog box. The descriptions themselves are listed below the table.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 19-2. <a name="113756">XML 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="113760">Attribute</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="113762">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', 'xml.24.08.html#113121', '');" name="113767">DataSourceName</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="113769">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', 'xml.24.08.html#113157', '');" name="113774">Description</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="113776">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', 'xml.24.08.html#112774', '');" name="113781">InternationalSort</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="113783">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', 'xml.24.08.html#112792', '');" name="113788">Location</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="113790">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', 'xml.24.08.html#112808', '');" name="113795">Logging</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="113797">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', 'xml.24.08.html#157408', '');" name="157479">ReadOnly</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="157481">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', 'xml.24.08.html#113361', '');" name="113802">ReportCodepageConversionErrors</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="113804">0 (Ignore Errors)</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', 'xml.24.08.html#112922', '');" name="113809">ShowManufacturedSchemas</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="113811">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', 'xml.24.08.html#112943', '');" name="113816">ShowVirtualSchemas</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="113818">1 (Enabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="112721">Data Source Name</a></div> <div class="gutter_text_right"><a name="113119">Attribute</a></div> <div class="Body_attr"><a name="113121">DataSourceName</a></div> <div class="gutter_text_right"><a name="113122">Description</a></div> <div class="Body"><a name="189322">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="113127">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="189351">string</a></span> </div> <div class="Body"><a name="189352">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="113133">Default</a></div> <div class="Body"><a name="113135">None</a></div> <div class="gutter_text_right"><a name="113136">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106603', '');" name="113141">General tab</a></span></div> <div class="head_2_no_TOC"><a name="112742">Description</a></div> <div class="gutter_text_right"><a name="113155">Attribute</a></div> <div class="Body_attr"><a name="113157">Description</a></div> <div class="gutter_text_right"><a name="113158">Description</a></div> <div class="Body"><a name="189342">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="113163">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="189356">string</a></span> </div> <div class="Body"><a name="189357">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="113169">Default</a></div> <div class="Body"><a name="113170">None</a></div> <div class="gutter_text_right"><a name="134161">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106603', '');" name="134166">General tab</a></span></div> <div class="head_2_no_TOC"><a name="112757">Driver Options</a></div> <div class="gutter_text_right"><a name="112758">Attribute</a></div> <div class="Body_attr"><a name="112759">n/a</a></div> <div class="gutter_text_right"><a name="121857">Description</a></div> <div class="Body"><a name="121841">Type configuration options specific to the XML driver.</a></div> <div class="gutter_text_right"><a name="121845">Valid Values</a></div> <div class="Body"><a name="121842">WARNING: The properties you set in the Options tab override other properties for this </a>session only and can adversely affect the operation of the XML driver. Use only authorized entries. For information about authorized entries for the Options tab, contact Progress DataDirect customer support.</div> <div class="gutter_text_right"><a name="112761">Default</a></div> <div class="Body"><a name="121732">None</a></div> <div class="gutter_text_right"><a name="121733">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106783', '');" name="121738">Options tab</a></span></div> <div class="head_2_no_TOC"><a name="121739">International Sort Order</a></div> <div class="gutter_text_right"><a name="112773">Attribute</a></div> <div class="Body_attr"><a name="112774">InternationalSort</a></div> <div class="gutter_text_right"><a name="121948">Description</a></div> <div class="Body"><a name="189376">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="121755">Valid Values</a></div> <div class="Body"><a name="189380">0 | 1</a></div> <div class="Body"><a name="189381">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="189382">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="112777">Default</a></div> <div class="Body"><a name="121463">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="121540">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106705', '');" name="121496">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="121474">Location Names</a></div> <div class="gutter_text_right"><a name="121475">Attribute</a></div> <div class="Body_attr"><a name="112792">Location</a></div> <div class="gutter_text_right"><a name="148653">Description</a></div> <div class="Body"><a name="112793">A display of all existing location names defined for the data source you are configuring.</a></div> <div class="gutter_text_right"><a name="121927">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="121956">string</a></span></div> <div class="Body"><a name="121957">where </a><span class="EquationVariables">string</span> is the name of a location.</div> <div class="Body"><a name="122011">The location names listed in the text box are used for connections according to the order </a>that they are displayed. If you want to change the order or precedence, use the Up and Down buttons.</div> <div class="gutter_text_right"><a name="112794">Default</a></div> <div class="Body"><a name="112796">None</a></div> <div class="gutter_text_right"><a name="134170">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106603', '');" name="134175">General tab</a></span></div> <div class="head_2_no_TOC"><a name="112806">Logging</a></div> <div class="gutter_text_right"><a name="112807">Attribute</a></div> <div class="Body_attr"><a name="112808">Logging</a></div> <div class="gutter_text_right"><a name="148663">Description</a></div> <div class="Body"><a name="112809">Creates a log file that logs the SQL execution plan. A value of 0 means no logging is </a>performed. </div> <div class="gutter_text_right"><a name="122041">Valid Values</a></div> <div class="Body"><a name="122109">0 | 1</a></div> <div class="Body"><a name="122110">If set to 1 (Enabled), a log file is created in the current directory. The default log file name is </a>\Integrator.txt.</div> <div class="Body"><a name="122111">If set to 0 (Disabled), no logging is performed.</a></div> <div class="gutter_text_right"><a name="112810">Default</a></div> <div class="Body"><a name="112812">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="134186">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106705', '');" name="134191">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="155446">Read Only</a></div> <div class="gutter_text_right"><a name="155447">Attribute</a></div> <div class="Body_attr"><a name="157408">ReadOnly</a></div> <div class="gutter_text_right"><a name="157409">Description</a></div> <div class="Body"><a name="157414">Controls whether the driver opens files for Read-Write access or Read-Only access</a></div> <div class="gutter_text_right"><a name="157410">Valid Values</a></div> <div class="Body"><a name="156671">0 | 1</a></div> <div class="Body"><a name="157430">If set to 1 (Enabled), the driver opens XML files for Read-Only access. In this case, the XML </a>driver opens XML files with a Shared Read lock. This allows other connections and applications to read the same XML file that the XML driver has open; however, they cannot write to the XML file.</div> <div class="Body"><a name="155460">If set to 0 (Disabled), the XML driver opens XML files for Read-Write access. Opening an </a>XML file for Read-Write access places an exclusive lock on the file. No other connections or applications can open the XML file while the driver has the file open.</div> <div class="gutter_text_right"><a name="155610">Default</a></div> <div class="Body"><a name="155463">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="155464">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106705', '');" name="155469">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="112838">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="113360">Attribute</a></div> <div class="Body_attr"><a name="113361">ReportCodepageConversionErrors</a></div> <div class="gutter_text_right"><a name="113362">Description</a></div> <div class="Body"><a name="189346">Specifies how the driver handles code page conversion errors that occur when a character </a>cannot be converted from one character set to another.</div> <div class="Body"><a name="189347">An error message or warning can occur if an ODBC call causes a conversion error, or if an </a>error occurs during code page conversions to and from the database or to and from the application. The error or warning generated is <span class="Syntax">Code page conversion error encountered</span>. In the case of parameter data conversion errors, the driver adds the following sentence: <span class="Syntax">Error in parameter</span><span class="Syntax"> </span><span class="EquationVariables">x</span>, where <span class="EquationVariables">x</span> is the parameter number. The standard rules for returning specific row and column errors for bulk operations apply.</div> <div class="gutter_text_right"><a name="113369">Valid Values</a></div> <div class="Body"><a name="189361">0 | 1 | 2</a></div> <div class="Body"><a name="189362">If set to 0 (Ignore Errors), the driver substitutes 0x1A for each character that cannot be </a>converted and does not return a warning or error.</div> <div class="Body"><a name="189363">If set to 1 (Return Error), the driver returns an error instead of substituting 0x1A for </a>unconverted characters.</div> <div class="Body"><a name="189364">If set to 2 (Return Warning), the driver substitutes 0x1A for each character that cannot be </a>converted and returns a warning.</div> <div class="gutter_text_right"><a name="113377">Default</a></div> <div class="Body"><a name="113379">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="134195">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106705', '');" name="134200">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="112857">Schema Mode</a></div> <div class="gutter_text_right"><a name="112858">Attribute</a></div> <div class="Body_attr"><a name="112859">n/a</a></div> <div class="gutter_text_right"><a name="122333">Description</a></div> <div class="Body"><a name="112860">Specifies whether to show virtual schemas, manufactured schemas, or both.</a></div> <div class="gutter_text_right"><a name="122347">Valid Values</a></div> <div class="Body"><a name="112862">Choose one of the following options:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="123367">Show Virtual Schemas Only. This option returns "XML" in the Schema Name column </a>when a SQLTables or SQLColumns operation is performed when connected to a data source. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.08.html#112941', '');">Show Virtual Schemas</a></span>.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="123368">Show Manufactured Schemas Only. This option returns the manufactured schema </a>names in the Schema Name column when a SQLTables or SQLColumns operation is performed when connected to a data source. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.08.html#112920', '');">Show Manufactured Schemas</a></span>.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="123482">Show Both Virtual and Manufactured Schemas. This option returns both virtual and </a>manufactured schema names when a SQLTables or SQLColumns operation is performed when connected to a data source.</div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="112909">Default</a></div> <div class="Body"><a name="112910">Show Virtual Schemas Only</a></div> <div class="gutter_text_right"><a name="134204">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106705', '');" name="134209">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="112920">Show Manufactured Schemas</a></div> <div class="gutter_text_right"><a name="112921">Attribute</a></div> <div class="Body_attr"><a name="112922">ShowManufacturedSchemas</a></div> <div class="gutter_text_right"><a name="123059">Description</a></div> <div class="Body"><a name="123067">Returns the manufactured schema names in the Schema Name column when a SQLTables </a>or SQLColumns operation is performed when connected to a data source. The Location names you define for a data source are manufactured into a schema name by adding a # symbol after the Location names. For example:</div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="146642">Schema Name</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="146644">Table Name</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146646">LOC1#</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146648">TAB1A</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146650">LOC1#</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146652">TAB1B</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146654">LOC2#</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146656">TAB2A</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146658">LOC2#</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="146660">TAB2B</a></div> </td> </tr> </table> <div class="gutter_text_right"><a name="146662">Valid Values</a></div> <div class="Body"><a name="122449">0 | 1</a></div> <div class="Body"><a name="122450">If set to 1 (Enabled), manufactured schema names are returned.</a></div> <div class="Body"><a name="122451">If set to 0 (Disabled), manufactured schema names are not returned.</a></div> <div class="Body"><a name="123638">To return both manufactured and virtual schema names, set this option to 1 (Enabled) and </a>the Show Virtual Schemas option to 1 (Enabled).</div> <div class="gutter_text_right"><a name="122452">Default</a></div> <div class="Body"><a name="122454">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="134213">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106705', '');" name="134218">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="112941">Show Virtual Schemas</a></div> <div class="gutter_text_right"><a name="112942">Attribute</a></div> <div class="Body_attr"><a name="112943">ShowVirtualSchemas</a></div> <div class="gutter_text_right"><a name="122763">Description</a></div> <div class="Body"><a name="122555">Returns "XML" in the Schema Name column when a SQLTables or SQLColumns operation </a>is performed when connected to a data source. For example:</div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="122918">Schema Name</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="122920">Table Name</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122922">XML</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122924">TAB1A</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122926">XML</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122928">TAB1B</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122930">XML</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122932">TAB2A</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122934">XML</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="122936">TAB2B</a></div> </td> </tr> </table> <div class="gutter_text_right"><a name="122494">Valid Values</a></div> <div class="Body"><a name="122495">0 | 1</a></div> <div class="Body"><a name="123744">If set to 1 (Enabled), virtual schema names are returned.</a></div> <div class="Body"><a name="123745">If set to 0 (Disabled), virtual schema names are not returned.</a></div> <div class="Body"><a name="123709">To return both virtual and manufactured schema names, set this option to 1 (Enabled) and </a>the Show Manufactured Schemas option to 1 (Enabled).</div> <div class="gutter_text_right"><a name="123699">Default</a></div> <div class="Body"><a name="123700">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="134222">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106705', '');" name="134227">Advanced tab</a></span></div> <div class="head_2"><a name="114440">Configure Location Dialog Box Descriptions</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.08.html#146739', '');" name="114445">Table 19-3</a></span> lists the connection string attributes associated with General and Advanced tabs of the XML driver Configure Location dialog box. The descriptions themselves are listed below the table. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.05.html#106488', '');">â??Defining Locationsâ??</a></span> for an explanation of locations.</div> <div class="Body"><a name="123753">NOTE: XML driver connection string attributes do not use short name equivalents.</a></div> <div class="Body"><a name="125337">The names of all connection options in this section are preceded by </a><span class="Emphasis">location_name</span>, where <span class="Emphasis">location_name</span> represents the name of a specific location that you have defined, for example, LOC1. See the description of the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.08.html#120134', '');">Location Name</a></span> option for details.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 19-3. <a name="146739">XML Configure Location 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="146743">Attribute</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="146745">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', 'xml.24.08.html#124474', '');" name="155324">location_name</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="155326">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', 'xml.24.08.html#120090', '');" name="155317">location_name.Catalog Type Hint</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="155319">Folder</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', 'xml.24.08.html#120795', '');" name="155331">location_name.Create Type</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="155333">DataDirect</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', 'xml.24.08.html#120954', '');" name="155352">location_name.Delete Schema</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="155354">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', 'xml.24.08.html#120564', '');" name="155345">location_name.Flush Every Change</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="155347">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', 'xml.24.08.html#120162', '');" name="155338">location_name.Initial Catalog</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="155340">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', 'xml.24.08.html#120732', '');" name="155380">location_name.Password</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="155382">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', 'xml.24.08.html#120640', '');" name="155373">location_name.Require Passwd</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="155375">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', 'xml.24.08.html#120471', '');" name="155366">location_name.Resolve External</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="155368">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', 'xml.24.08.html#120343', '');" name="155359">location_name.Row Hint</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="155361">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', 'xml.24.08.html#121144', '');" name="155387">location_name.Scan Rows</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="155389">0</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', 'xml.24.08.html#120222', '');" name="155408">location_name.Table Hint</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="155410">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', 'xml.24.08.html#118325', '');" name="155401">location_name.User ID</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="155403">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', 'xml.24.08.html#118511', '');" name="155394">location_name.Validate Schema</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="155396">0 (Disabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="164705">Delete Linked Schema</a></div> <div class="gutter_text_right"><a name="120953">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120954">location_name</a></span>.Delete Schema</div> <div class="gutter_text_right"><a name="125691">Description</a></div> <div class="Body"><a name="120995">Specifies whether an externally-linked schema file is deleted when a table is deleted. This </a>option is valid only for Folder location types. The XML document for the table contains a link to this external schema file. By default, this check box is not selected.</div> <div class="gutter_text_right"><a name="125447">Valid Values</a></div> <div class="Body"><a name="125448">0 | 1</a></div> <div class="Body"><a name="125449">If set to 1 (Enabled), the externally-linked schema file is deleted when the table is deleted. If </a>multiple XML documents are linked to the same schema file, the schema file is not deleted when a table is deleted.</div> <div class="Body"><a name="125450">If set to 0 (Disabled), the externally-linked schema file is not deleted when the table is </a>deleted.</div> <div class="gutter_text_right"><a name="125452">Default</a></div> <div class="Body"><a name="125453">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="125608">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="120562">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="125633">Flush Every Change</a></div> <div class="gutter_text_right"><a name="120563">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120564">location_name</a></span>.Flush Every Change</div> <div class="gutter_text_right"><a name="125998">Description</a></div> <div class="Body"><a name="120613">Writes the data document to disk after every insert, update, or delete operation. This option </a>is valid only for Folder location types.</div> <div class="gutter_text_right"><a name="125950">Valid Values</a></div> <div class="Body"><a name="125951">0 | 1</a></div> <div class="Body"><a name="125952">If set to 1 (Enabled), the driver writes the data document to disk after every change.</a></div> <div class="Body"><a name="125953">If set to 0 (Disabled), the driver does not write the data document to disk after every change. </a>Disabling this option can improve performance.</div> <div class="gutter_text_right"><a name="125954">Default</a></div> <div class="Body"><a name="125955">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="134308">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134313">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="120160">Location</a></div> <div class="gutter_text_right"><a name="120161">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120162">location_name</a></span>.Initial Catalog</div> <div class="gutter_text_right"><a name="124537">Description</a></div> <div class="Body"><a name="120209">The full path name to the location you are defining.</a></div> <div class="gutter_text_right"><a name="124527">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="124515">location_directory</a></span></div> <div class="Body"><a name="124516">where </a><span class="EquationVariables">location_directory</span> is the full path name of the directory in which the data files are stored. For example:</div> <div class="syntax_first"><a name="125421">LOC1.Initial Catalog=C:\Documents\filesml</a></div> <div class="gutter_text_right"><a name="120164">Default</a></div> <div class="Body"><a name="120165">None</a></div> <div class="gutter_text_right"><a name="124547">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#117166', '');" name="124552">Configure Location General tab</a></span></div> <div class="head_2_no_TOC"><a name="120134">Location Name</a></div> <div class="gutter_text_right"><a name="124473">Attribute</a></div> <div class="Body_attr" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Emphasis"><a name="124474">location_name</a></span></div> <div class="gutter_text_right"><a name="123860">Description</a></div> <div class="Body"><a name="119975">A unique name for the location you are defining, for example, LOC1.</a></div> <div class="gutter_text_right"><a name="123824">Valid Values</a></div> <div class="Body"><span class="Emphasis"><a name="123825">location_name</a></span>={DataDirect Closed XML ADO Provider}</div> <div class="Body"><a name="123826">where </a><span class="Emphasis">location_name</span> is the unique name of the location you are defining. For example, if you choose the location name LOC1, then:</div> <div class="syntax_first"><a name="124365">LOC1={DataDirect Closed XML ADO Provider}</a></div> <div class="gutter_text_right"><a name="119976">Default</a></div> <div class="Body"><a name="120061">None</a></div> <div class="gutter_text_right"><a name="134125">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#117166', '');" name="134130">Configure Location General tab</a></span></div> <div class="head_2_no_TOC"><a name="120088">Location Type</a></div> <div class="gutter_text_right"><a name="120089">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120090">location_name</a></span>.Catalog Type Hint</div> <div class="gutter_text_right"><a name="126733">Description</a></div> <div class="Body"><a name="126577">Specifies the type of location you are defining for the connection.</a></div> <div class="gutter_text_right"><a name="126542">Valid Values</a></div> <div class="Body"><a name="126432">Folder | XML Document | HTML Document</a></div> <div class="Body"><a name="126603">For example:</a></div> <div class="syntax_first"><a name="126604">LOC1.Catalog Type Hint=XML Document</a></div> <div class="Body"><a name="126679">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.05.html#106488', '');">â??Defining Locationsâ??</a></span> for the definition of each type.</div> <div class="gutter_text_right"><a name="126435">Default</a></div> <div class="Body"><a name="126436">Folder</a></div> <div class="gutter_text_right"><a name="134138">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#117166', '');" name="134143">Configure Location General tab</a></span></div> <div class="head_2_no_TOC"><a name="126404">Max Rows to Scan</a></div> <div class="gutter_text_right"><a name="121143">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="121144">location_name</a></span>.Scan Rows</div> <div class="gutter_text_right"><a name="126806">Description</a></div> <div class="Body"><a name="126807">An integer that represents the maximum number of rows to scan when the XML driver is </a>determining the data type of each column. This option is valid only for XML Document location types.</div> <div class="gutter_text_right"><a name="126808">Valid Values</a></div> <div class="Body"><a name="126809">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="126810">where </a><span class="EquationVariables">x</span> is the number of rows to scan.</div> <div class="Body"><a name="127053">If set to </a><span class="EquationVariables">x</span>, the driver scans a maximum of <span class="EquationVariables">x</span> rows in the table. During the scan, the driver inspects each column value in the row of a table and adjusts the data type determination for each column based on the corresponding value. The more sample column values it encounters, the more accurate the determination.</div> <div class="Body"><a name="126811">If set to 0, the driver scans all rows in the table. Disabling this option can improve </a>performance because limiting the number of rows can reduce the amount of time it takes to determine the column information on very large documents. Because less information is available, however, the determination of the data types can be incorrect.</div> <div class="gutter_text_right"><a name="126812">Default</a></div> <div class="Body"><a name="126813">0</a></div> <div class="gutter_text_right"><a name="134317">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134322">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="121051">Password</a></div> <div class="gutter_text_right"><a name="121052">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120732">location_name</a></span>.Password</div> <div class="gutter_text_right"><a name="127375">Description</a></div> <div class="Body"><a name="120779">The password used to establish a connection to the location specified by </a><span class="Emphasis">location_name</span>. A password is required only if the location to which you are connecting is password-protected.</div> <div class="Body"><a name="127387">This option is not available unless the Require User ID/Password option is enabled.</a></div> <div class="gutter_text_right"><a name="127405">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="189386">pwd</a></span> </div> <div class="Body"><a name="189387">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="Body"><a name="127502">WARNING: The encrypted password is stored in the Windows Registry.</a></div> <div class="gutter_text_right"><a name="127453">Default</a></div> <div class="Body"><a name="120739">None</a></div> <div class="gutter_text_right"><a name="134326">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134331">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="120638">Require User ID/Password</a></div> <div class="gutter_text_right"><a name="120639">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120640">location_name</a></span>.Require Passwd</div> <div class="gutter_text_right"><a name="127674">Description</a></div> <div class="Body"><a name="120687">Specifies whether a User ID and password are required to establish a connection to the </a>location you are defining.</div> <div class="gutter_text_right"><a name="127611">Valid Values</a></div> <div class="Body"><a name="127612">0 | 1</a></div> <div class="Body"><a name="127613">If set to 1 (Enabled), a User ID and password are required to establish a connection to the </a>location. You must enable this option if the location you are defining is password-protected; otherwise, the connection will fail. Enabling this option causes a <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106802', '');">Logon dialog box</a></span> to appear when connecting with the driver.</div> <div class="Body"><a name="127614">If set to 0 (Disabled), no user ID and password are required to establish a connection to the </a>location.</div> <div class="gutter_text_right"><a name="127615">Default</a></div> <div class="Body"><a name="127616">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="134363">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134368">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="120469">Resolve External References</a></div> <div class="gutter_text_right"><a name="120470">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120471">location_name</a></span>.Resolve External</div> <div class="gutter_text_right"><a name="128007">Description</a></div> <div class="Body"><a name="120472">Determines whether external references such as DTDs, Schemas, Entities, and Notations </a>are resolved for the XML documents contained within the location specified by <span class="Emphasis">location_name</span>.</div> <div class="gutter_text_right"><a name="128090">Valid Values</a></div> <div class="Body"><a name="127968">0 | 1</a></div> <div class="Body"><a name="127969">If set to 1 (Enabled), the documents are not processed if the XML parser cannot locate the </a>external references.</div> <div class="Body"><a name="127971">If set to 0 (Disabled), the document is processed, even if the XML parser cannot locate the </a>external references.</div> <div class="gutter_text_right"><a name="127972">Default</a></div> <div class="Body"><a name="127973">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="134400">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134405">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="120341">Row Hint</a></div> <div class="gutter_text_right"><a name="120342">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120343">location_name</a></span>.Row Hint</div> <div class="gutter_text_right"><a name="128157">Description</a></div> <div class="Body"><a name="120390">A string that specifies an Extensible Stylesheet Language (XSL) pattern to identify the </a>nodes that make up the rows in the rowset of a tabular-formatted XML document contained within the location specified by <span class="Emphasis">location_name</span>. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.09.html#107151', '');">â??Using Hints for Tabular-Formatted XML Documentsâ??</a></span> for details.</div> <div class="Body"><a name="120344">This option is valid only for Folder and HTML Document location types.</a></div> <div class="gutter_text_right"><a name="128133">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="128167">row_hint</a></span></div> <div class="Body"><a name="128168">where </a><span class="EquationVariables">row_hint</span> is an XSL pattern. </div> <div class="gutter_text_right"><a name="128137">Default</a></div> <div class="Body"><a name="128138">None</a></div> <div class="gutter_text_right"><a name="134429">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134434">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="120793">Table Creation</a></div> <div class="gutter_text_right"><a name="120794">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120795">location_name</a></span>.Create Type</div> <div class="gutter_text_right"><a name="128358">Description</a></div> <div class="Body"><a name="120838">Determines the style of XML that is generated when a new table is created. This option is </a>valid only for Folder location types.</div> <div class="gutter_text_right"><a name="128277">Valid Values</a></div> <div class="Body"><a name="128278">IE5DataIsland | ADO25 | DataDirect</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="128526">Data Island Format (IE5DataIsland): New tables are created with the Internet Explorer 5 </a>Data Island XML style.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="128527">ADO Format (ADO25): New tables are created with the ADO</a> 2.5 XML style.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="128528">DataDirect Format (DataDirect): New tables are created with the DataDirect format. </a>This format conforms to the W3C recommendation for XML schema, working draft April 07, 2000.</div> </td> </tr> </table> </div> <div class="Body"><a name="128557">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.03.html#163836', '');">â??Common Tabular Formats for XML Documentsâ??</a></span> for a description of each of these formats.</div> <div class="gutter_text_right"><a name="128285">Default</a></div> <div class="Body"><a name="128286">DataDirect</a></div> <div class="gutter_text_right"><a name="134454">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134459">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="120220">Table Hint</a></div> <div class="gutter_text_right"><a name="120221">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="120222">location_name</a></span>.Table Hint</div> <div class="gutter_text_right"><a name="128682">Description</a></div> <div class="Body"><a name="128683">A string that specifies an Extensible Stylesheet Language (XSL) pattern to identify the table </a>or rowset nodes in a tabular-formatted XML document contained within the location specified by <span class="Emphasis">location_name</span>. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.09.html#107151', '');">â??Using Hints for Tabular-Formatted XML Documentsâ??</a></span> for details.</div> <div class="Body"><a name="128596">This option is valid only for Folder and HTML Document location types.</a></div> <div class="gutter_text_right"><a name="128597">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="128598">table_hint</a></span></div> <div class="Body"><a name="128599">where </a><span class="EquationVariables">table_hint</span> is an XSL pattern. </div> <div class="gutter_text_right"><a name="128600">Default</a></div> <div class="Body"><a name="128601">None</a></div> <div class="gutter_text_right"><a name="134463">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134468">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="120071">User ID</a></div> <div class="gutter_text_right"><a name="118323">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="118325">location_name</a></span>.User ID</div> <div class="gutter_text_right"><a name="128810">Description</a></div> <div class="Body"><a name="128811">The User ID (user name) used to establish a connection to the location specified by </a><span class="Emphasis">location_name</span>. A password is required only if the location to which you are connecting is password-protected.</div> <div class="Body"><a name="128813">This option is not available unless the Require User ID/Password option is enabled.</a></div> <div class="gutter_text_right"><a name="128814">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="128817">userid</a></span></div> <div class="Body"><a name="128818">where </a><span class="EquationVariables">userid</span> is a valid user name.</div> <div class="gutter_text_right"><a name="128821">Default</a></div> <div class="Body"><a name="128822">None</a></div> <div class="gutter_text_right"><a name="134472">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134477">Configure Location Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="118391">Validate Schema</a></div> <div class="gutter_text_right"><a name="118392">Attribute</a></div> <div class="Body_attr"><span class="Emphasis"><a name="118511">location_name</a></span>.Validate Schema</div> <div class="gutter_text_right"><a name="129024">Description</a></div> <div class="Body"><a name="118599">Determines whether the XML documents contained within the location specified by </a><span class="Emphasis">location_name</span> are validated against their schema. </div> <div class="gutter_text_right"><a name="128995">Valid Values</a></div> <div class="Body"><a name="128996">0 | 1</a></div> <div class="Body"><a name="128997">If set to 1 (Enabled), the XML documents are validated against their schema. This allows a </a>well-formed XML document to be processed, even if the document is not valid.</div> <div class="Body"><a name="128998">If set to 0 (Disabled), the XML documents are not validated against their schema.</a></div> <div class="gutter_text_right"><a name="128999">Default</a></div> <div class="Body"><a name="129000">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="134481">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106644', '');" name="134486">Configure Location 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