Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\oraclecli.17.04.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/oraclecli.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="oraclecli.17.01.html#556941">13 The Oracle Driver </a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="556941">Connection Option Descriptions</a></div> <div class="Body"><a name="608327">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="608328">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="608329">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', 'oraclecli.17.04.html#556961', '');" name="556951">Table 13-1</a></span> lists the connection string attributes supported by the Oracle driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 13-1. <a name="556961">Oracle 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="556965">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="556967">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557508', '');" name="556972">AlternateServers (ASRV)</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="556974">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557533', '');" name="556979">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="556981">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557563', '');" name="556986">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="556988">60000</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557593', '');" name="557053">CatalogIncludesSynonyms (CIS)</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="557055">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557624', '');" name="557060">CatalogOptions (CO)</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="557062">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557654', '');" name="557067">ClientVersion (CV)</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="557069">9iR2</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557707', '');" name="557074">ConnectionReset (CR)</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="557076">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557736', '');" name="557081">ConnectionRetryCount (CRC)</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="557083">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557764', '');" name="557088">ConnectionRetryDelay (CRD)</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="557090">3</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557792', '');" name="557095">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="557097">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557818', '');" name="557102">DefaultLongDataBuffLen (DLDBL)</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="557104">1024</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557848', '');" name="557109">DescribeAtPrepare (DAP)</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="557111">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557877', '');" name="557116">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="557118">Empty</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557964', '');" name="557133">EnableDescribeParam (EDP)</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="557135">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557902', '');" name="557140">EnableNcharSupport (ENS)</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="557142">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557933', '');" name="557147">EnableScrollableCursors (ESC)</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="557149">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557991', '');" name="557154">EnableStaticCursorsForLongData (ESCLD)</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="557156">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558022', '');" name="557161">EnableTimestampwithTimezone (ETWT)</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="557163">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558057', '');" name="557228">IANAAppCodePage (IACP)</a></span> <br />UNIX ONLY</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="557230">4 (ISO 8559-1 Latin-1)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558101', '');" name="557285">LoadBalanceTimeout (LBT)</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="557287">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558134', '');" name="557292">LoadBalancing (LB)</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="557294">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558161', '');" name="557299">LocalTimezoneOffset (LTZO)</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="557301">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"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558187', '');" name="557306">LockTimeout (LTO)</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_text"><a name="557308">-1</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558514', '');" name="557323">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="557325">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558220', '');" name="557370">MaxPoolSize (MXPS)</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="557372">100</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558250', '');" name="557377">MinPoolSize (MNPS)</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="557379">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558282', '');" name="557384">OptimizeLongPerformance (OLP)</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="557386">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558307', '');" name="580656">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="580658">Empty</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#557676', '');" name="557391">Pooling (POOL)</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="557393">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558328', '');" name="557415">ProcedureRetResults (PRR)</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="557417">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558359', '');" name="557432">ReportCodepageConversionErrors (RCCE)</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="557434">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558387', '');" name="557439">ReportRecycleBin (RRB)</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="557441">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558414', '');" name="557446">ServerList</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="557448">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558437', '');" name="557453">ServerName (SRVR)</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="557455">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558458', '');" name="557460">TimestampEscapeMapping (TEM)</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="557462">0 (Version Specific)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.04.html#558484', '');" name="557487">UseCurrentSchema (UCS)</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="557489">1 (Enabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="557505">Alternate Servers</a></div> <div class="gutter_text_right"><a name="557506">Attribute</a></div> <div class="Body_attr"><a name="557508">AlternateServers (ASRV)</a></div> <div class="gutter_text_right"><a name="557509">Description</a></div> <div class="Body"><a name="608333">A list of alternate database servers to which the driver tries to connect if the primary </a>database server is unavailable. Specifying a value for this option enables connection failover for the driver. The value you specify must be in the form of a string that defines the physical location of each alternate server. All of the other required connection information for each alternate server is the same as what is defined for the primary server connection.</div> <div class="gutter_text_right"><a name="557514">Valid Values</a></div> <div class="syntax_first"><span style="font-size: 9.0pt;"><a name="557515">(</a></span>ServerName=<span class="EquationVariables">servervalue</span>[, . . .]<span style="font-size: 9.0pt;">)</span></div> <div class="Body"><a name="557516">You must specify the server name of each alternate server. </a></div> <div class="gutter_text_right"><a name="557517">Example</a></div> <div class="Body"><a name="557518">The following Alternate Servers value defines two alternate database servers for connection </a>failover:</div> <div class="syntax_first"><a name="557519">(ServerName=AcctBackup1, ServerName=AcctBackup2)</a></div> <div class="gutter_text_right"><a name="557520">Default</a></div> <div class="Body"><a name="557521">None</a></div> <div class="gutter_text_right"><a name="557522">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556549', '');" name="557527">Failover tab</a></span> </div> <div class="head_2_no_TOC"><a name="557530">Application Using Threads</a></div> <div class="gutter_text_right"><a name="557531">Attribute</a></div> <div class="Body_attr"><a name="557533">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="557534">Description</a></div> <div class="Body"><a name="608337">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="557541">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557543">Valid Values</a></div> <div class="Body"><a name="608341">0 | 1</a></div> <div class="Body"><a name="608342">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="608343">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="557550">Default</a></div> <div class="Body"><a name="557551">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="557552">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="557557">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="557560">Array Size</a></div> <div class="gutter_text_right"><a name="557561">Attribute</a></div> <div class="Body_attr"><a name="557563">ArraySize (AS)</a></div> <div class="gutter_text_right"><a name="557564">Description</a></div> <div class="Body"><a name="608347">The number of bytes the driver can fetch in a single network round trip. Larger values </a>increase throughput by reducing the number of times the driver fetches data across the network. Smaller values increase response time, as there is less of a delay waiting for the server to transmit data.</div> <div class="Body"><a name="557571">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557573">Valid Values</a></div> <div class="Body"><a name="608351">An integer from 1 to 4,294,967,296 (4 GB)</a></div> <div class="Body"><a name="608352">The value 1 does not define the number of bytes but, instead, causes the driver to allocate </a>space for exactly one row of data.</div> <div class="gutter_text_right"><a name="557579">Default</a></div> <div class="Body"><a name="557580">60000</a></div> <div class="gutter_text_right"><a name="557581">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556479', '');" name="557587">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="557590">Catalog Functions Include Synonyms</a></div> <div class="gutter_text_right"><a name="557591">Attribute</a></div> <div class="Body_attr"><a name="557593">CatalogIncludesSynonyms (CIS)</a></div> <div class="gutter_text_right"><a name="557594">Description</a></div> <div class="Body"><a name="608356">Determines whether synonyms are included in calls to SQLProcedures, SQLStatistics, and </a>SQLProcedureColumns.</div> <div class="Body"><a name="557601">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557603">Valid Values</a></div> <div class="Body"><a name="608360">0 | 1</a></div> <div class="Body"><a name="608361">If set to 1 (Enabled), synonyms are included in calls to SQLProcedures, SQLStatistics, and </a>SQLProcedureColumns. </div> <div class="Body"><a name="608362">If set to 0 (Disabled), synonyms are excluded (a non-standard behavior) and performance is </a>thereby improved.</div> <div class="gutter_text_right"><a name="557610">Default</a></div> <div class="Body"><a name="557611">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="557612">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556479', '');" name="557617">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="557621">Catalog Options</a></div> <div class="gutter_text_right"><a name="557622">Attribute</a></div> <div class="Body_attr"><a name="557624">CatalogOptions (CO)</a></div> <div class="gutter_text_right"><a name="557625">Description</a></div> <div class="Body"><a name="608366">Determines whether SQL_NULL_DATA is returned for the result columns REMARKS and </a>COLUMN_DEF.</div> <div class="Body"><a name="557632">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557634">Valid Values</a></div> <div class="Body"><a name="608370">0 | 1</a></div> <div class="Body"><a name="608371">If set to 1 (Enabled), the result column REMARKS (for the catalog functions SQLTables and </a>SQLColumns) and the result column COLUMN_DEF (for the catalog function SQLColumns) return actual values. Enabling this option reduces the performance of your catalog (SQLColumns and SQLTables) queries.</div> <div class="Body"><a name="608372">If set to 0 (Disabled), SQL_NULL_DATA is returned for the result columns REMARKS and </a>COLUMN_DEF.</div> <div class="gutter_text_right"><a name="557641">Default</a></div> <div class="Body"><a name="557642">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="557643">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="557648">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="557651">Client Version</a></div> <div class="gutter_text_right"><a name="557652">Attribute</a></div> <div class="Body_attr"><a name="557654">ClientVersion (CV)</a></div> <div class="gutter_text_right"><a name="557655">Description</a></div> <div class="Body"><a name="557656">A value to specify the Oracle client software version. The driver assumes that it is using the </a>version of Oracle client software specified by this option to connect to an Oracle server. </div> <div class="gutter_text_right"><a name="557657">Valid Values</a></div> <div class="Body"><a name="557658">8i | 9iR1 | 9iR2 | 10gR1</a></div> <div class="Body"><a name="557659">When set to 10gR1 and later, the driver binds all non-integer numerics as BINARY FLOAT </a>and BINARY DOUBLE. When set to any Oracle version previous to Oracle10<span class="Emphasis">g</span> R1, the driver binds non-integer numerics as if connected to an Oracle 9<span class="Emphasis">i</span> R2 or earlier version of the server (regardless of the actual version of the server to which it is connected). When connecting to an Oracle 10<span class="Emphasis">g</span> server with a pre-10<span class="Emphasis">g</span> client, this attribute must be set to the same version as the actual Oracle client software in use; otherwise, numeric parameter bindings may fail. Versions of the Oracle client software prior to 10<span class="Emphasis">g</span> R1 do not fully support the new features of the Oracle 10<span class="Emphasis">g</span> database server.</div> <div class="gutter_text_right"><a name="557660">Default</a></div> <div class="Body"><a name="557662">9iR2</a></div> <div class="gutter_text_right"><a name="557663">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556114', '');" name="557668">General tab</a></span></div> <div class="head_2_no_TOC"><a name="557673">Connection Pooling</a></div> <div class="gutter_text_right"><a name="557674">Attribute</a></div> <div class="Body_attr"><a name="557676">Pooling (POOL)</a></div> <div class="gutter_text_right"><a name="557677">Description</a></div> <div class="Body"><a name="608376">Specifies whether to use the driverâ??s connection pooling.</a></div> <div class="Body"><a name="608377">NOTE: The application must be thread-enabled to use connection pooling.</a></div> <div class="Body"><a name="557685">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557687">Valid Values</a></div> <div class="Body"><a name="608381">0 | 1</a></div> <div class="Body"><a name="608382">If set to 1 (Enabled), the driver uses connection pooling. </a></div> <div class="Body"><a name="608383">If set to 0 (Disabled), the driver does not use connection pooling.</a></div> <div class="gutter_text_right"><a name="557694">Default</a></div> <div class="Body"><a name="557695">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="557696">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556632', '');" name="557701">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="557704">Connection Reset</a></div> <div class="gutter_text_right"><a name="557705">Attribute</a></div> <div class="Body_attr"><a name="557707">ConnectionReset (CR)</a></div> <div class="gutter_text_right"><a name="557708">Description</a></div> <div class="Body"><a name="608387">Determines whether the state of connections that are removed from the connection pool for </a>reuse by the application is reset to the initial configuration of the connection.</div> <div class="Body"><a name="557715">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557717">Valid Values</a></div> <div class="Body"><a name="608391">0 | 1</a></div> <div class="Body"><a name="608392">If set to 1 (Enabled), the state of connections removed from the connection pool for reuse </a>by an application is reset to the initial configuration of the connection. Resetting the state can negatively impact performance because additional commands must be sent over the network to the server to reset the state of the connection.</div> <div class="Body"><a name="608393">If set to 0 (Disabled), the state of connections is not reset.</a></div> <div class="gutter_text_right"><a name="557724">Default</a></div> <div class="Body"><a name="557725">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="557726">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556632', '');" name="557731">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="557733">Connection Retry Count</a></div> <div class="gutter_text_right"><a name="557734">Attribute</a></div> <div class="Body_attr"><a name="557736">ConnectionRetryCount (CRC)</a></div> <div class="gutter_text_right"><a name="557737">Description</a></div> <div class="Body"><a name="608397">The number of times the driver retries connection attempts to the primary database server, </a>and if specified, alternate servers until a successful connection is established. </div> <div class="Body"><a name="608398">This option and the Connection Retry Delay connection option, which specifies the wait </a>interval between attempts, can be used in conjunction with failover.</div> <div class="gutter_text_right"><a name="557743">Valid Values</a></div> <div class="Body"><a name="608402">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="608403">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="608404">If set to 0, the driver does not try to connect after the initial unsuccessful attempt.</a></div> <div class="Body"><a name="608405">If set to </a><span class="EquationVariables">x</span>, the driver retries connection attempts the specified number of times. If a connection is not established during the retry attempts, the driver returns an error that is generated by the last server to which it tried to connect.</div> <div class="gutter_text_right"><a name="557751">Default</a></div> <div class="Body"><a name="557752">0</a></div> <div class="gutter_text_right"><a name="557753">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556549', '');" name="557758">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="557761">Connection Retry Delay</a></div> <div class="gutter_text_right"><a name="557762">Attribute</a></div> <div class="Body_attr"><a name="557764">ConnectionRetryDelay (CRD)</a></div> <div class="gutter_text_right"><a name="557765">Description</a></div> <div class="Body"><a name="608409">The number of seconds the driver waits between connection retry attempts when </a>Connection Retry Count is set to a positive integer.</div> <div class="Body"><a name="608410">This option and the Connection Retry Count connection option can be used in conjunction </a>with failover.</div> <div class="gutter_text_right"><a name="557771">Valid Values</a></div> <div class="Body"><a name="608414">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="608415">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="608416">If set to 0, there is no delay between retries.</a></div> <div class="Body"><a name="608417">If set to </a><span class="EquationVariables">x</span>, the driver waits the specified number of seconds between connection retry attempts.</div> <div class="gutter_text_right"><a name="557779">Default</a></div> <div class="Body"><a name="557780">3</a></div> <div class="gutter_text_right"><a name="557781">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556549', '');" name="557786">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="557789">Data Source Name</a></div> <div class="gutter_text_right"><a name="557790">Attribute</a></div> <div class="Body_attr"><a name="557792">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="557793">Description</a></div> <div class="Body"><a name="608421">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="557798">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="608425">string</a></span> </div> <div class="Body"><a name="608426">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="557804">Default</a></div> <div class="Body"><a name="557806">None</a></div> <div class="gutter_text_right"><a name="557807">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556114', '');" name="557812">General tab</a></span></div> <div class="head_2_no_TOC"><a name="557815">Default Buffer Size for Long/LOB Columns (in</a> Kb)</div> <div class="gutter_text_right"><a name="557816">Attribute</a></div> <div class="Body_attr"><a name="557818">DefaultLongDataBuffLen (DLDBL)</a></div> <div class="gutter_text_right"><a name="557819">Description</a></div> <div class="Body"><a name="608430">The maximum length of data (in KB) the driver can fetch from long columns in a single </a>round trip and the maximum length of data that the driver can send using the SQL_DATA_AT_EXEC parameter. </div> <div class="Body"><a name="557824">NOTE: If this option is enabled, the Optimize Long Performance option is ignored.</a></div> <div class="Body"><a name="557827">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557829">Valid Values</a></div> <div class="Body"><a name="608434">An integer in multiples of 1024</a></div> <div class="Body"><a name="608435">The value must be in multiples of 1024 (for example, 1024, 2048). You need to increase the </a>default value if the total size of any Long data exceeds 1 MB. This value is multiplied by 1024 to determine the total maximum length of fetched data. For example, if you enter a value of 2048, the maximum length of data would be 1024 x 2048, or 2097152 (2 MB).</div> <div class="gutter_text_right"><a name="557835">Default</a></div> <div class="Body"><a name="557836">1024</a></div> <div class="gutter_text_right"><a name="557837">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="557842">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="557845">Describe At Prepare</a></div> <div class="gutter_text_right"><a name="557846">Attribute</a></div> <div class="Body_attr"><a name="557848">DescribeAtPrepare (DAP)</a></div> <div class="gutter_text_right"><a name="557849">Description</a></div> <div class="Body"><a name="608439">Determines whether the driver describes the SQL statement at prepare time.</a></div> <div class="Body"><a name="557856">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557858">Valid Values</a></div> <div class="Body"><a name="608443">0 | 1</a></div> <div class="Body"><a name="608444">If set to 1 (Enabled), the driver describes the SQL statement at prepare time.</a></div> <div class="Body"><a name="608445">If set to 0 (Disabled), the driver does not describe the SQL statement at prepare time.</a></div> <div class="gutter_text_right"><a name="557865">Default</a></div> <div class="Body"><a name="557866">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="557867">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="557872">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="557874">Description</a></div> <div class="gutter_text_right"><a name="557875">Attribute</a></div> <div class="Body_attr"><a name="557877">Description (n/a)</a></div> <div class="gutter_text_right"><a name="557878">Description</a></div> <div class="Body"><a name="608449">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="557883">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="608453">string</a></span> </div> <div class="Body"><a name="608454">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="557889">Default</a></div> <div class="Body"><a name="557890">None</a></div> <div class="gutter_text_right"><a name="557891">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556114', '');" name="557896">General tab</a></span></div> <div class="head_2_no_TOC"><a name="557899">Enable N-CHAR Support</a></div> <div class="gutter_text_right"><a name="557900">Attribute</a></div> <div class="Body_attr"><a name="557902">EnableNcharSupport (ENS)</a></div> <div class="gutter_text_right"><a name="557903">Description</a></div> <div class="Body"><a name="608458">Determines whether the driver provides support for the N-types NCHAR, NVARCHAR2, and </a>NCLOB. These types are described as SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCHAR, and are returned as supported by SQLGetTypeInfo. In addition, the "normal" char types (char, varchar2, long, clob) are described as SQL_CHAR, SQL_VARCHAR, and SQL_LONGVARCHAR regardless of the character set on the Oracle server.</div> <div class="Body"><a name="557911">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.07.html#559048', '');">â??Unicode Supportâ??</a></span> for details.</div> <div class="Body"><a name="557912">NOTE: Valid only on Oracle 9</a><span class="Emphasis">i</span> and higher.</div> <div class="gutter_text_right"><a name="557913">Valid Values</a></div> <div class="Body"><a name="608462">0 | 1</a></div> <div class="Body"><a name="608463">If set to 1 (Enabled), the driver provides support for the N-types NCHAR, NVARCHAR2, and </a>NCLOB. </div> <div class="Body"><a name="608464">If set to 0 (Disabled), the driver does not provide support for the N-types NCHAR, </a>NVARCHAR2, and NCLOB.</div> <div class="gutter_text_right"><a name="557920">Default</a></div> <div class="Body"><a name="557921">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="557922">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="557927">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="557930">Enable Scrollable Cursors</a></div> <div class="gutter_text_right"><a name="557931">Attribute</a></div> <div class="Body_attr"><a name="557933">EnableScrollableCursors (ESC)</a></div> <div class="gutter_text_right"><a name="557934">Description</a></div> <div class="Body"><a name="608468">Determines whether scrollable cursors, both Keyset and Static, are enabled for the data </a>source.</div> <div class="Body"><a name="557941">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="557943">Valid Values</a></div> <div class="Body"><a name="608472">0 | 1</a></div> <div class="Body"><a name="608473">If set to 1 (Enabled), scrollable cursors are enabled for the data source. </a></div> <div class="Body"><a name="608474">If set to 0 (Disabled), scrollable cursors are not enabled.</a></div> <div class="gutter_text_right"><a name="557950">Default</a></div> <div class="Body"><a name="557951">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="557952">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556479', '');" name="557957">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="557961">Enable SQLDescribeParam</a></div> <div class="gutter_text_right"><a name="557962">Attribute</a></div> <div class="Body_attr"><a name="557964">EnableDescribeParam (EDP)</a></div> <div class="gutter_text_right"><a name="557965">Description</a></div> <div class="Body"><a name="608478">Determines whether the SQLDescribeParam function describes all parameters with a data </a>type of SQL_VARCHAR for Select statements. For Insert/Update/Delete statements and for stored procedures, the parameters are described as the actual Oracle data types on the Oracle server. This option must be enabled to access data when using Microsoft Remote Data Objects (RDO).</div> <div class="gutter_text_right"><a name="557970">Valid Values</a></div> <div class="Body"><a name="608482">0 | 1</a></div> <div class="Body"><a name="608483">If set to 1 (Enabled), the SQLDescribeParam function describes all parameters with a data </a>type of SQL_VARCHAR for Select statements. </div> <div class="Body"><a name="608484">If set to 0 (Disabled), the SQLDescribeParam function does not describe all parameters with </a>a data type of SQL_VARCHAR for Select statements.</div> <div class="gutter_text_right"><a name="557977">Default</a></div> <div class="Body"><a name="557978">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="557979">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="557985">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="557988">Enable Static Cursors for Long Data</a></div> <div class="gutter_text_right"><a name="557989">Attribute</a></div> <div class="Body_attr"><a name="557991">EnableStaticCursorsForLongData (ESCLD)</a></div> <div class="gutter_text_right"><a name="557992">Description</a></div> <div class="Body"><a name="608488">Determines whether the driver supports Long columns when using a static cursor. Enabling </a>this option causes a performance penalty at the time of execution when reading Long data.</div> <div class="Body"><a name="557999">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text"><a name="558001">Valid Values</a></div> <div class="Body"><a name="608492">0 | 1</a></div> <div class="Body"><a name="608493">If set to 1 (Enabled), the driver supports Long columns when using a static cursor.</a></div> <div class="Body"><a name="608494">If set to 0 (Disabled), the driver does not support Long columns when using a static cursor. </a></div> <div class="Body"><a name="608495">NOTE: You must enable this option if you want to persist a result set that contains Long data </a>into an XML data file.</div> <div class="gutter_text_right"><a name="558009">Default</a></div> <div class="Body"><a name="558010">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="558011">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556479', '');" name="558016">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="558019">Enable Timestamp with Timezone</a></div> <div class="gutter_text_right"><a name="558020">Attribute</a></div> <div class="Body_attr"><a name="558022">EnableTimestampwithTimezone (ETWT)</a></div> <div class="gutter_text_right"><a name="558023">Description</a></div> <div class="Body"><a name="608499">Determines whether the driver exposes timestamps with timezones to the application. </a></div> <div class="gutter_text_right"><a name="558028">Valid Values</a></div> <div class="Body"><a name="608503">0 | 1</a></div> <div class="Body"><a name="608504">If set to 1 (Enabled), the driver exposes timestamps with timezones to the application. The </a>driver issues an ALTER SESSION at connection time to modify NLS_TIMESTAMP_TZ_FORMAT. NLS_TIMESTAMP_TZ_FORMAT is changed to the ODBC definition of a timestamp literal with the addition of the timezone literal: '<span class="EquationVariables">YYYY-MM-DD </span><span class="EquationVariables">HH24:MI:SSXFF TZR</span>'.</div> <div class="Body"><a name="608505">If set to 0 (Disabled), timestamps with timezones are not exposed to the application.</a></div> <div class="gutter_text_right"><a name="558035">Default</a></div> <div class="Body"><a name="558036">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="558037">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558043">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="558054">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="558055">Attribute</a></div> <div class="Body_attr"><a name="558057">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="558058">Description</a></div> <div class="Body"><a name="608509">An Internet Assigned Numbers Authority (IANA) value. You must specify a value for this </a>option if your application is not Unicodeâ??enabled or if your database character set is not Unicode. Refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'unicode.06.1.html#106144', '');">Chapter 4 â??Internationalization, Localization, and Unicodeâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span> for details. </div> <div class="Body"><a name="608517">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="608518">The driver and Driver Manager both check for the value of IANAAppCodePage in the </a>following order:</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="608519">In the connection string</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="608520">In the Data Source section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="608521">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="608522">If the driver does not find an IANAAppCodePage value, the driver uses the default value of </a>4 (ISO 8859-1 Latin-1).</div> <div class="gutter_text_right"><a name="558076">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="608526">IANA_code_page</a></span> </div> <div class="Body"><a name="608528">where </a><span class="EquationVariables">IANA_code_page</span> is one of the valid values listed in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'appcodepage.03.1.html#108909', '');">Chapter 1 â??Values for the Attribute IANAAppCodePageâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span>. The value must match the database character encoding and the system locale.</div> <div class="gutter_text_right"><a name="558086">Default</a></div> <div class="Body"><a name="558088">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="558089">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558095">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="558098">Load Balance Timeout</a></div> <div class="gutter_text_right"><a name="558099">Attribute</a></div> <div class="Body_attr"><a name="558101">LoadBalanceTimeout (LBT)</a></div> <div class="gutter_text_right"><a name="558102">Description</a></div> <div class="Body"><a name="608535">The number of seconds to keep inactive connections open in a connection pool. An inactive </a>connection is a database session that is not associated with an ODBC connection handle, that is, a connection in the pool that is not in use by an application.</div> <div class="Body"><a name="608536">NOTE: The Min Pool Size option may cause some connections to ignore this value.</a></div> <div class="Body"><a name="558110">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558112">Valid Values</a></div> <div class="Body"><a name="608540">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="608541">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="608542">If set to 0, inactive connections are kept open.</a></div> <div class="Body"><a name="608543">If set to </a><span class="EquationVariables">x</span>, inactive connections are closed after the specified number of seconds passes.</div> <div class="gutter_text_right"><a name="558120">Default</a></div> <div class="Body"><a name="558122">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="558123">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556632', '');" name="558128">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="558131">Load Balancing</a></div> <div class="gutter_text_right"><a name="558132">Attribute</a></div> <div class="Body_attr"><a name="558134">LoadBalancing (LB)</a></div> <div class="gutter_text_right"><a name="558135">Description</a></div> <div class="Body"><a name="608547">Determines whether the driver uses client load balancing in its attempts to connect to the </a>database servers (primary and alternate). You can specify one or multiple alternate servers by setting the Alternate Servers option. </div> <div class="gutter_text_right"><a name="558140">Valid Values</a></div> <div class="Body"><a name="608551">0 | 1</a></div> <div class="Body"><a name="608552">If set to 1 (Enabled), the driver uses client load balancing and attempts to connect to the </a>database servers (primary and alternate servers) in random order. </div> <div class="Body"><a name="608553">If set to 0 (Disabled), the driver does not use client load balancing and connects to each </a>server based on their sequential order (primary server first, then, alternate servers in the order they are specified).</div> <div class="Body"><a name="608554">NOTE: This option has no effect unless alternate servers are defined for the Alternate </a>Servers connection option.</div> <div class="gutter_text_right"><a name="558148">Default</a></div> <div class="Body"><a name="558149">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="558150">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556549', '');" name="558155">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="558158">Local Timezone Offset</a></div> <div class="gutter_text_right"><a name="558159">Attribute</a></div> <div class="Body_attr"><a name="558161">LocalTimezoneOffset (LTZO)</a></div> <div class="gutter_text_right"><a name="558162">Description</a></div> <div class="Body"><a name="608558">A value to alter local time zone information. The default is "" (empty string), which means </a>that the driver determines local time zone information from the operating system. If it is not available from the operating system, the driver defaults to using the setting on the Oracle server.</div> <div class="gutter_text_right"><a name="558167">Valid Values</a></div> <div class="Body"><a name="608562">Valid values are specified as offsets from GMT as follows: </a><span class="EquationVariables">(â??)HH:MM</span>. For example, <span class="Syntax">-08:00</span> equals GMT minus 8 hours. </div> <div class="Body"><a name="608563">The driver uses the value of this option to issue an ALTER SESSION for local time zone at </a>connection time.</div> <div class="gutter_text_right"><a name="558173">Default</a></div> <div class="Body"><a name="558174">"" (Empty String)</a></div> <div class="gutter_text_right"><a name="558175">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558181">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="558184">Lock Timeout</a></div> <div class="gutter_text_right"><a name="558185">Attribute</a></div> <div class="Body_attr"><a name="558187">LockTimeout (LTO)</a></div> <div class="gutter_text_right"><a name="558188">Description</a></div> <div class="Body"><a name="608567">Specifies the amount of time, in seconds, the Oracle server waits for a lock to be released </a>before generating an error when processing a Select...For Update statement on an Oracle 9<span class="Emphasis">i</span> or higher server.</div> <div class="Body"><a name="558195">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558197">Valid Values</a></div> <div class="Body"><a name="608571">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="608572">where </a><span class="EquationVariables">x</span> is an integer that specifies a number of seconds.</div> <div class="Body"><a name="608573">If set to -1, the server waits indefinitely for the lock to be released.</a></div> <div class="Body"><a name="608574">If set to 0, the server generates an error immediately and does not wait for the lock to time </a>out. </div> <div class="Body"><a name="608575">If set to </a><span class="EquationVariables">x</span>, the server waits for the specified number of seconds for the lock to be released.</div> <div class="Body"><a name="608576">NOTE: If you are connected to an Oracle 8</a><span class="Emphasis">i</span> server, any value greater than 0 is equivalent to the value -1.</div> <div class="gutter_text_right"><a name="558207">Default</a></div> <div class="Body"><a name="558208">-1</a></div> <div class="gutter_text_right"><a name="558209">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556479', '');" name="558214">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="558217">Max Pool Size</a></div> <div class="gutter_text_right"><a name="558218">Attribute</a></div> <div class="Body_attr"><a name="558220">MaxPoolSize (MXPS)</a></div> <div class="gutter_text_right"><a name="558221">Description</a></div> <div class="Body"><a name="608580">The maximum number of connections allowed within a single connection pool. When the </a>maximum number of connections is reached, no additional connections can be created in the connection pool.</div> <div class="Body"><a name="558228">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558230">Valid Values</a></div> <div class="Body"><a name="608584">An integer from 1 to 65535</a></div> <div class="Body"><a name="608585">For example, if set to 20, the maximum number of connections allowed in the pool is 20.</a></div> <div class="gutter_text_right"><a name="558236">Default</a></div> <div class="Body"><a name="558238">100</a></div> <div class="gutter_text_right"><a name="558239">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556632', '');" name="558244">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="558247">Min Pool Size</a></div> <div class="gutter_text_right"><a name="558248">Attribute</a></div> <div class="Body_attr"><a name="558250">MinPoolSize (MNPS)</a></div> <div class="gutter_text_right"><a name="558251">Description</a></div> <div class="Body"><a name="608589">The minimum number of connections that are opened and placed in a connection pool, in </a>addition to the active connection, when the pool is created. The connection pool retains this number of connections, even when some connections exceed their Load Balance Timeout value. </div> <div class="Body"><a name="558258">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558260">Valid Values</a></div> <div class="Body"><a name="608593">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="608594">where </a><span class="EquationVariables">x</span> is an integer from 1 to 65535.</div> <div class="Body"><a name="608595">For example, if set to 5, the start-up number of connections in the pool is 5 in addition to the </a>current existing connection.</div> <div class="Body"><a name="608596">If set to 0, no connections are opened in addition to the current existing connection.</a></div> <div class="gutter_text_right"><a name="558268">Default</a></div> <div class="Body"><a name="558270">0</a></div> <div class="gutter_text_right"><a name="558271">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556632', '');" name="558276">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="558279">Optimize Long Performance</a></div> <div class="gutter_text_right"><a name="558280">Attribute</a></div> <div class="Body_attr"><a name="558282">OptimizeLongPerformance (OLP)</a></div> <div class="gutter_text_right"><a name="558283">Description</a></div> <div class="Body"><a name="558284">Allows the driver to fetch Long data directly into the applicationâ??s buffers rather than </a>allocating buffers and making a copy. This option decreases fetch times on Long data; however, it can cause the application to be limited to one active statement per connection.</div> <div class="Body"><a name="558285">NOTE: If this option is enabled, the Default Buffer Size for Long/LOB Columns option is </a>ignored.</div> <div class="Body"><a name="558288">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558290">Valid Values</a></div> <div class="Body"><a name="558291">0 | 1</a></div> <div class="Body"><a name="558292">If set to 1 (Enabled), the driver fetches Long data directly into the applicationâ??s buffers rather </a>than allocating buffers and making a copy. </div> <div class="Body"><a name="558293">If set to 0 (Disabled), the driver does not fetch Long data directly into the applicationâ??s </a>buffers. </div> <div class="gutter_text_right"><a name="558294">Default</a></div> <div class="Body"><a name="558296">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="558297">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556479', '');" name="558302">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="558304">Password</a></div> <div class="gutter_text_right"><a name="558305">Attribute</a></div> <div class="Body_attr"><a name="558307">Password (PWD)</a></div> <div class="gutter_text_right"><a name="558308">Description</a></div> <div class="Body"><a name="608600">The password that the application uses to connect to your database. The Password option </a>cannot be specified through the driver Setup dialog box and should not be stored in a data source. It is specified through the Logon dialog box or a connection string.</div> <div class="gutter_text_right"><a name="558313">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="608604">pwd</a></span> </div> <div class="Body"><a name="608605">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="558319">Default</a></div> <div class="Body"><a name="558320">None</a></div> <div class="gutter_text_right"><a name="558321">GUI Tab</a></div> <div class="Body"><a name="558322">n/a</a></div> <div class="head_2_no_TOC"><a name="558325">Procedure Returns Results</a></div> <div class="gutter_text_right"><a name="558326">Attribute</a></div> <div class="Body_attr"><a name="558328">ProcedureRetResults (PRR)</a></div> <div class="gutter_text_right"><a name="558329">Description</a></div> <div class="Body"><a name="608609">Determines whether the driver returns result sets from stored procedures/functions.</a></div> <div class="Body"><a name="558337">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.10.html#559132', '');">â??MTS Supportâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558338">Valid Values</a></div> <div class="Body"><a name="608613">0 | 1</a></div> <div class="Body"><a name="608614">If set to 1 (Enabled), the driver returns result sets from stored procedures/functions. When </a>set to 1 and you execute a stored procedure that does not return result sets, you will incur a small performance penalty.</div> <div class="Body"><a name="608615">If set to 0 (Disabled), the driver does not return result sets from stored procedures.</a></div> <div class="gutter_text_right"><a name="558345">Default</a></div> <div class="Body"><a name="558346">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="558347">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558353">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="558356">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="558357">Attribute</a></div> <div class="Body_attr"><a name="558359">ReportCodepageConversionErrors (RCCE)</a></div> <div class="gutter_text_right"><a name="558360">Description</a></div> <div class="Body"><a name="608619">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="608620">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="558366">Valid Values</a></div> <div class="Body"><a name="608624">0 | 1 | 2</a></div> <div class="Body"><a name="608625">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="608626">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="608627">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="558374">Default</a></div> <div class="Body"><a name="558375">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="558376">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558381">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="558384">Report Recycle Bin</a></div> <div class="gutter_text_right"><a name="558385">Attribute</a></div> <div class="Body_attr"><a name="558387">ReportRecycleBin (RRB)</a></div> <div class="gutter_text_right"><a name="558388">Description</a></div> <div class="Body"><a name="608631">Determines whether support is provided for reporting objects that are in the Oracle Recycle </a>Bin.</div> <div class="Body"><a name="608632">On Oracle 10</a><span class="Emphasis">g</span> R1 and higher, when a table is dropped, it is not actually removed from the database, but placed in the recycle bin instead. </div> <div class="gutter_text_right"><a name="558394">Valid Values</a></div> <div class="Body"><a name="608636">0 | 1</a></div> <div class="Body"><a name="608637">If set to 1 (Enabled), support is provided for reporting objects that are in the Oracle Recycle </a>Bin.</div> <div class="Body"><a name="608638">If set to 0 (Disabled), the driver does not return tables contained in the recycle bin in the </a>result sets returned from SQLTables and SQLColumns. Functionally, this means that the driver filters out any results whose Table name begins with BIN$.</div> <div class="gutter_text_right"><a name="558401">Default</a></div> <div class="Body"><a name="558402">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="558403">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558408">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="558411">Server List</a></div> <div class="gutter_text_right"><a name="558412">Attribute</a></div> <div class="Body_attr"><a name="558414">ServerList</a></div> <div class="gutter_text_right"><a name="558415">Description</a></div> <div class="Body"><a name="558416">A list of client connection strings that appear in the logon dialog box. This option applies to </a>GUIs only and is not a runtime connection string attribute.</div> <div class="Body"><a name="558420">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details about the logon dialog box.</div> <div class="gutter_text_right"><a name="558421">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="558422">string</a></span></div> <div class="Body"><a name="558423">where </a><span class="EquationVariables">string</span> is a list of valid client connection strings. Separate the strings with commas. If the client connection string contains a comma, enclose it in quotation marks, for example, <span class="Syntax">"Serv,1", "Serv,2", "Serv,3"</span>.</div> <div class="gutter_text_right"><a name="558424">Default</a></div> <div class="Body"><a name="558425">None</a></div> <div class="gutter_text_right"><a name="558426">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558431">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="558434">Server Name</a></div> <div class="gutter_text_right"><a name="558435">Attribute</a></div> <div class="Body_attr"><a name="558437">ServerName (SRVR)</a></div> <div class="gutter_text_right"><a name="558438">Description</a></div> <div class="Body"><a name="558439">The client connection string of the computer containing the Oracle database tables you </a>want to access.</div> <div class="gutter_text_right"><a name="558440">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="558441">string</a></span></div> <div class="Body"><a name="558442">where </a><span class="EquationVariables">string</span> is a valid client connection string.</div> <div class="Body"><a name="558443">For local servers, use the SQL*Net connection string. If the SQL*Net connection string </a>contains semicolons, enclose it in quotation marks. Refer to your SQL*Net documentation for more information.</div> <div class="Body"><a name="558444">For remote servers, the Oracle TNS Client connection string is the alias name of the Oracle </a>Listener on your network.</div> <div class="gutter_text_right"><a name="558445">Default</a></div> <div class="Body"><a name="558446">None</a></div> <div class="gutter_text_right"><a name="558447">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556114', '');" name="558452">General tab</a></span></div> <div class="head_2_no_TOC"><a name="558455">Timestamp Escape Mapping</a></div> <div class="gutter_text_right"><a name="558456">Attribute</a></div> <div class="Body_attr"><a name="558458">TimestampEscapeMapping (TEM)</a></div> <div class="gutter_text_right"><a name="558459">Description</a></div> <div class="Body"><a name="608642">Determines how the driver maps Date, Time, and Timestamp literals.</a></div> <div class="gutter_text_right"><a name="558464">Valid Values</a></div> <div class="Body"><a name="608646">0 | 1</a></div> <div class="Body"><a name="608647">If set to 0 (Oracle Version Specific), the driver determines whether to use the TO_DATE or </a>TO_TIMESTAMP function based on the version of the Oracle server to which it is connected. If the driver is connected to an 8.x server, it maps the Date, Time, and Timestamp literals to the TO_DATE function. If the driver is connected to a 9.x or higher server, it maps these escapes to the TO_TIMESTAMP function.</div> <div class="Body"><a name="608648">If set to 1 (Oracle 8x Compatible), the driver always uses the Oracle 8.x TO_DATE function </a>as if connected to an Oracle 8.x server.</div> <div class="gutter_text_right"><a name="558471">Default</a></div> <div class="Body"><a name="558472">0 (Oracle Version Specific)</a></div> <div class="gutter_text_right"><a name="558473">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558478">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="558481">Use Current Schema for SQLProcedures</a></div> <div class="gutter_text_right"><a name="558482">Attribute</a></div> <div class="Body_attr"><a name="558484">UseCurrentSchema (UCS)</a></div> <div class="gutter_text_right"><a name="558485">Description</a></div> <div class="Body"><a name="608652">Determines whether the driver returns only procedures owned by the current user when </a>executing SQLProcedures. </div> <div class="Body"><a name="558492">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.05.html#558790', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558494">Valid Values</a></div> <div class="Body"><a name="608656">0 | 1</a></div> <div class="Body"><a name="608657">When set to 1 (Enabled), the call for SQLProcedures is optimized, but only procedures </a>owned by the user are returned.</div> <div class="Body"><a name="608658">When set to 0 (Disabled), the driver does not specify only the current user.</a></div> <div class="gutter_text_right"><a name="558501">Default</a></div> <div class="Body"><a name="558502">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="558503">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556479', '');" name="558508">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="558511">User Name</a></div> <div class="gutter_text_right"><a name="558512">Attribute</a></div> <div class="Body_attr"><a name="558514">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="558515">Description</a></div> <div class="Body"><a name="608662">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="Body"><a name="558522">You can also use OS Authentication to connect to your Oracle database. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.11.html#559148', '');">â??OS Authenticationâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="558524">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="608666">userid</a></span></div> <div class="Body"><a name="608667">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="558530">Default</a></div> <div class="Body"><a name="558531">None</a></div> <div class="gutter_text_right"><a name="558532">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.03.html#556161', '');" name="558537">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