Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\oraclewp.12.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/oraclewp.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="oraclewp.12.01.html#237584">8 The Oracle Wire Protocol Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="237584">Connection Option Descriptions</a></div> <div class="Body"><a name="544527">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="544528">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="544529">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', 'oraclewp.12.04.html#263816', '');" name="238132">Table 8-1</a></span> lists the connection string attributes supported by the Oracle Wire Protocol driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 8-1. <span style="color: #000000; font-size: 10.0pt; font-style: italic; font-variant: normal; font-weight: bold; text-transform: none; vertical-align: baseline;"><a name="263816">Oracle Wire Protocol Attribute Names</a></span><span style="color: #000000; font-size: 10.0pt; font-style: italic; font-variant: normal; font-weight: bold; text-transform: none; vertical-align: baseline;"> </span></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="263820">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="263822">Default</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#438497', '');" name="438584">AccountingInfo (AI)</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="438586">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#439811', '');" name="443057">Action (ACT)</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="443059">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', 'oraclewp.12.04.html#219762', '');" name="424407">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="424409">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#438658', '');" name="438621">ApplicationName (AN)</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="438623">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', 'oraclewp.12.04.html#219312', '');" name="424400">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="424402">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', 'oraclewp.12.04.html#219891', '');" name="424393">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="424395">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', 'oraclewp.12.04.html#220116', '');" name="424386">AuthenticationMethod (AM)</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="424388">1 (Encrypt Password)</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', 'oraclewp.12.04.html#220372', '');" name="424421">BulkBinaryThreshold (BBT)</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="424423">32</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', 'oraclewp.12.04.html#220632', '');" name="424414">BulkCharacterThreshold (BCT)</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="424416">-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', 'oraclewp.12.04.html#220750', '');" name="424428">BulkLoadBatchSize (BLBS)</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="424430">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" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#521688', '');" name="522020">BulkLoadFieldDelimiter (BLFD)</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="522022">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', 'oraclewp.12.04.html#469452', '');" name="447387">BulkLoadOptions (BLO)</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="447389">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#521866', '');" name="522066">BulkLoadRecordDelimiter (BLRD)</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="522068">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', 'oraclewp.12.04.html#221040', '');" name="424680">CachedCursorLimit (CCL)</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="424682">32</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', 'oraclewp.12.04.html#221135', '');" name="424673">CachedDescriptionLimit (CDL)</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="424675">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', 'oraclewp.12.04.html#291645', '');" name="424666">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="424668">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', 'oraclewp.12.04.html#221377', '');" name="424659">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="424661">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#439147', '');" name="438632">ClientHostName (CHN)</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="438634">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#443069', '');" name="443388">ClientID (CID)</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="443390">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#439170', '');" name="438639">ClientUser (CU)</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="438641">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', 'oraclewp.12.04.html#221609', '');" name="424652">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="424654">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', 'oraclewp.12.04.html#221692', '');" name="424645">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="424647">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', 'oraclewp.12.04.html#221716', '');" name="424638">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="424640">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', 'oraclewp.12.04.html#293864', '');" name="424631">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="424633">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', 'oraclewp.12.04.html#222204', '');" name="424624">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="424626">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', 'oraclewp.12.04.html#222775', '');" name="424617">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="424619">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', 'oraclewp.12.04.html#223896', '');" name="424610">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="424612">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', 'oraclewp.12.04.html#442310', '');" name="443009">EditionName (EN)</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="443011">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', 'oraclewp.12.04.html#224120', '');" name="424603">EnableBulkLoad (EBL)</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="424605">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', 'oraclewp.12.04.html#224252', '');" name="424596">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="424598">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', 'oraclewp.12.04.html#225516', '');" name="424589">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="424591">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', 'oraclewp.12.04.html#226833', '');" name="424582">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="424584">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', 'oraclewp.12.04.html#227859', '');" name="424575">EnableServerResultCache (ESRC)</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="424577">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', 'oraclewp.12.04.html#228023', '');" name="424568">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="424570">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', 'oraclewp.12.04.html#228255', '');" name="424561">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="424563">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', 'oraclewp.12.04.html#228436', '');" name="424554">EncryptionMethod (EM)</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="424556">0 (No Encryption)</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', 'oraclewp.12.04.html#228656', '');" name="424547">FailoverGranularity (FG)</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="424549">0 (Non-Atomic)</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', 'oraclewp.12.04.html#228683', '');" name="424540">FailoverMode (FM)</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="424542">0 (Connection)</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', 'oraclewp.12.04.html#228708', '');" name="424533">FailoverPreconnect (FP)</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="424535">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', 'oraclewp.12.04.html#344965', '');" name="424526">FetchTSWTZasTimestamp (FTSWTZAT)</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="424528">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', 'oraclewp.12.04.html#228995', '');" name="424519">GSSClient (GSSC)</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="424521">native</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', 'oraclewp.12.04.html#229275', '');" name="424512">HostName (HOST)</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="424514">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', 'oraclewp.12.04.html#412843', '');" name="424505">HostNameInCertificate (HNIC)</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="424507">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', 'oraclewp.12.04.html#230386', '');" name="424498">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="424500">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', 'oraclewp.12.04.html#230611', '');" name="424491">InitializationString (IS)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="424493">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', 'oraclewp.12.04.html#230840', '');" name="424484">KeyPassword (KP)</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="424486">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', 'oraclewp.12.04.html#230861', '');" name="424477">Keystore (KS)</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="424479">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', 'oraclewp.12.04.html#230883', '');" name="424470">KeystorePassword (KSP)</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="424472">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', 'oraclewp.12.04.html#231374', '');" name="424463">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="424465">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', 'oraclewp.12.04.html#231179', '');" name="424456">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="424458">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', 'oraclewp.12.04.html#231451', '');" name="424449">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="424451">"" (Empty String)</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', 'oraclewp.12.04.html#231513', '');" name="424442">LockTimeout (LTO)</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="424444">-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', 'oraclewp.12.04.html#231753', '');" name="424435">LoginTimeout (LT)</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="424437">15</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', 'oraclewp.12.04.html#232273', '');" name="424687">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="424689">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', 'oraclewp.12.04.html#232422', '');" name="424813">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="424815">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', 'oraclewp.12.04.html#232443', '');" name="424806">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="424808">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', 'oraclewp.12.04.html#443400', '');" name="443659">Module (MOD)</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="443661">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', 'oraclewp.12.04.html#233423', '');" name="424799">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="424801">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', 'oraclewp.12.04.html#233462', '');" name="424792">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="424794">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', 'oraclewp.12.04.html#233504', '');" name="424785">PortNumber (PORT)</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="424787">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', 'oraclewp.12.04.html#233666', '');" name="424778">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="424780">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#439453', '');" name="438649">ProgramID (PID)</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="438651">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', 'oraclewp.12.04.html#233873', '');" name="424771">QueryTimeout (QT)</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="424773">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', 'oraclewp.12.04.html#233964', '');" name="424763">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="424766">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', 'oraclewp.12.04.html#234168', '');" name="424757">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="424759">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', 'oraclewp.12.04.html#234367', '');" name="424750">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="424752">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', 'oraclewp.12.04.html#234468', '');" name="424743">ServerType (ST)</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="424745">0 (Server 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', 'oraclewp.12.04.html#234689', '');" name="424736">ServiceName (SN)</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="424738">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', 'oraclewp.12.04.html#234887', '');" name="424729">SID (SID)</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="424731">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', 'oraclewp.12.04.html#235124', '');" name="424722">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="424724">0 (Oracle 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', 'oraclewp.12.04.html#235284', '');" name="424715">TNSNamesFile (TNF)</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="424717">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', 'oraclewp.12.04.html#235567', '');" name="424708">Truststore (TS)</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="424710">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', 'oraclewp.12.04.html#235589', '');" name="424701">TruststorePassword (TSP)</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="424703">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', 'oraclewp.12.04.html#235771', '');" name="424694">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="424696">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', 'oraclewp.12.04.html#236358', '');" name="424841">ValidateServerCertificate (VSC)</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="424843">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', 'oraclewp.12.04.html#236274', '');" name="424834">WireProtocolMode (WPM)</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="424836">2</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="488332">Accounting Info</a></div> <div class="gutter_text_right"><a name="438495">Attribute</a></div> <div class="Body_attr"><a name="438497">AccountingInfo (AI)</a></div> <div class="gutter_text_right"><a name="439657">Description</a></div> <div class="Body"><a name="439982">Accounting information to be stored in the database. This value sets the CLIENT_INFO </a>value of the V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="439661">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="438504">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="438505">string</a></span></div> <div class="Body"><a name="438506">where </a><span class="EquationVariables">string</span> is the accounting information. </div> <div class="gutter_text_right"><a name="438507">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="438508">None</a></div> <div class="gutter_text_right"><a name="438943">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="438948">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="439808">Action</a></div> <div class="gutter_text_right"><a name="439809">Attribute</a></div> <div class="Body_attr"><a name="439811">Action (ACT)</a></div> <div class="gutter_text_right"><a name="439812">Description</a></div> <div class="Body"><a name="452226">The current action (Select, Insert, Update, or Delete, for example) within the current </a>module. This value sets the ACTION column of the V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="443018">This option only applies to connections to Oracle 10</a><span class="Emphasis">g</span> R2 and higher database servers.</div> <div class="Body"><a name="439990">NOTE: You can also specify this information using the Oracle </a>DBMS_APPLICATION_INFO.SET_ACTION procedure or the DBMS_APPLICATION_INFO.SET_MODULE procedure.</div> <div class="Body"><a name="439816">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="439818">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="439819">string</a></span></div> <div class="Body"><a name="439820">where </a><span class="EquationVariables">string</span> is the current action.</div> <div class="gutter_text_right"><a name="439821">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="439822">None</a></div> <div class="gutter_text_right"><a name="439823">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="439828">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="438951">Alternate Servers</a></div> <div class="gutter_text_right"><a name="438952">Attribute</a></div> <div class="Body_attr"><a name="219762">AlternateServers (ASRV)</a></div> <div class="gutter_text_right"><a name="219768">Description</a></div> <div class="Body"><a name="544533">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="219770">Valid Values</a></div> <div class="syntax_first"><span style="font-size: 9.0pt;"><a name="285766">(</a></span>HostName=<span class="EquationVariables">hostvalue</span>:PortNumber=<span class="EquationVariables">portvalue</span>:{SID<span class="EquationVariables">=sidvalue</span> | ServiceName=<span class="EquationVariables">servicevalue</span>}[, . . .]<span style="font-size: 9.0pt;">)</span></div> <div class="Body"><a name="240263">You must specify the host name, port number, and either the SID or service name of each </a>alternate server. </div> <div class="gutter_text_right"><a name="219772">Example</a></div> <div class="Body"><a name="240444">The following Alternate Servers value defines two alternate database servers for connection </a>failover:</div> <div class="syntax_first"><a name="219773">(HostName=AccountingOracleServer:PortNumber=1521:</a></div> <div class="syntax"><a name="295178">SID=Accounting,HostName=255.201.11.24:PortNumber=1522:</a></div> <div class="syntax"><a name="219776">ServiceName=ABackup.NA.MyCompany)</a></div> <div class="gutter_text_right"><a name="240154">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="240155">None</a></div> <div class="gutter_text_right"><a name="219785">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');" name="240181">Failover tab</a></span> </div> <div class="head_2_no_TOC"><a name="438655">Application Name</a></div> <div class="gutter_text_right"><a name="438656">Attribute</a></div> <div class="Body_attr"><a name="438658">ApplicationName (AN)</a></div> <div class="gutter_text_right"><a name="438659">Description</a></div> <div class="Body"><a name="452220">The name of the application to be stored in the database. This value sets the dbms_session </a>value in the database and the PROGRAM value of the V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="440050">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="438665">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="438666">string</a></span></div> <div class="Body"><a name="438667">where </a><span class="EquationVariables">string</span> is the name of the application.</div> <div class="Body"><a name="480198">If a value for this option is not specified, the driver uses the name of the current process.</a></div> <div class="gutter_text_right"><a name="438668">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="438669">None</a></div> <div class="gutter_text_right"><a name="438670">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="439130">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="219309">Application Using Threads</a></div> <div class="gutter_text_right"><a name="219310">Attribute</a></div> <div class="Body_attr"><a name="219312">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="219313">Description</a></div> <div class="Body"><a name="544537">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="241556">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="241502">Valid Values</a></div> <div class="Body"><a name="544541">0 | 1</a></div> <div class="Body"><a name="544542">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="544543">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="269633">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="269634">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="219335">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="241571">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="219888">Array Size</a></div> <div class="gutter_text_right"><a name="219889">Attribute</a></div> <div class="Body_attr"><a name="219891">ArraySize (AS)</a></div> <div class="gutter_text_right"><a name="219892">Description</a></div> <div class="Body"><a name="544547">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="247718">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="241620">Valid Values</a></div> <div class="Body"><a name="544551">An integer from 1 to 4,294,967,296 (4 GB)</a></div> <div class="Body"><a name="544552">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="241624">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="241621">60000</a></div> <div class="gutter_text_right"><a name="219912">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="247739">Performance tab</a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#263816', '');"> </a></span></div> <div class="head_2_no_TOC"><a name="220113">Authentication Method</a></div> <div class="gutter_text_right"><a name="220114">Attribute</a></div> <div class="Body_attr"><a name="220116">AuthenticationMethod (AM)</a></div> <div class="gutter_text_right"><a name="220117">Description</a></div> <div class="Body"><a name="544556">Specifies the method the driver uses to authenticate the user to the server when a </a>connection is established. If the specified authentication method is not supported by the database server, the connection fails and the driver generates an error.</div> <div class="gutter_text_right"><a name="241774">Valid Values</a></div> <div class="Body"><a name="241831">1 | 3 | 4 | 5</a></div> <div class="Body"><a name="544560">If set to 1 (Encrypt Password), the driver sends the user ID in clear text and an encrypted </a>password to the server for authentication.</div> <div class="Body"><a name="544564">If set to 3 (Client Authentication), the driver uses client authentication when establishing a </a>connection. The database server relies on the client to authenticate the user and does not provide additional authentication.</div> <div class="Body"><a name="544568">If set to 4 (Kerberos Authentication), the driver uses Kerberos authentication. This method </a>supports both Windows Active Directory Kerberos and MIT Kerberos environments.</div> <div class="Body"><a name="544572">When set to 5 (Kerberos with UID & PWD), the driver uses both Kerberos authentication </a>and user ID and password authentication. The driver first authenticates the user using Kerberos. If a user ID and password are specified, the driver reauthenticates using the user name and password supplied. An error is generated if a user ID and password are not specified.</div> <div class="gutter_text_right"><a name="384366">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="220119">1 (Encrypt Password)</a></div> <div class="gutter_text_right"><a name="220148">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="242413">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="220747">Batch Size</a></div> <div class="gutter_text_right"><a name="220748">Attribute</a></div> <div class="Body_attr"><a name="220750">BulkLoadBatchSize (BLBS)</a></div> <div class="gutter_text_right"><a name="220751">Description</a></div> <div class="Body"><a name="544576">The number of rows that the driver sends to the database at a time during bulk operations. </a>This value applies to all methods of bulk loading.</div> <div class="gutter_text_right"><a name="242663">Valid Values</a></div> <div class="Body"><a name="242669">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="242727">where </a><span class="EquationVariables">x</span> is the number of rows to send during a bulk operation.</div> <div class="gutter_text_right"><a name="374123">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="374124">1024</a></div> <div class="gutter_text_right"><a name="374125">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');" name="242657">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="220369">Bulk Binary Threshold</a></div> <div class="gutter_text_right"><a name="220370">Attribute</a></div> <div class="Body_attr"><a name="220372">BulkBinaryThreshold (BBT)</a></div> <div class="gutter_text_right"><a name="220373">Description</a></div> <div class="Body"><a name="544580">The maximum size, in KB, of binary data that is exported to the bulk data file. </a></div> <div class="gutter_text_right"><a name="243116">Valid Values</a></div> <div class="Body"><a name="544584">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="544585">where </a><span class="EquationVariables">x</span> is an integer that specifies the number of KB.</div> <div class="Body"><a name="544586">If set to -1, all binary data, regardless of size, is written to the bulk data file, not to an </a>external file.</div> <div class="Body"><a name="544587">If set to 0, all binary data, regardless of size, is written to an external file, not the bulk data </a>file. A reference to the external file is written to the bulk data file.</div> <div class="Body"><a name="544588">If set to </a><span class="EquationVariables">x</span>, any binary data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.</div> <div class="gutter_text_right"><a name="243111">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="220375">32</a></div> <div class="gutter_text_right"><a name="220391">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');" name="247842">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="220629">Bulk Character Threshold</a></div> <div class="gutter_text_right"><a name="220630">Attribute</a></div> <div class="Body_attr"><a name="220632">BulkCharacterThreshold (BCT)</a></div> <div class="gutter_text_right"><a name="220633">Description</a></div> <div class="Body"><a name="544592">The maximum size, in KB, of character data that is exported to the bulk data file. </a></div> <div class="gutter_text_right"><a name="244028">Valid Values</a></div> <div class="Body"><a name="544596">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="544597">where </a><span class="EquationVariables">x</span> is an integer that specifies the number of KB.</div> <div class="Body"><a name="544598">If set to -1, all character data, regardless of size, is written to the bulk data file, not to an </a>external file.</div> <div class="Body"><a name="544599">If set to 0, all character data regardless of size, is written to an external file, not the bulk data </a>file. A reference to the external file is written to the bulk data file.</div> <div class="Body"><a name="544600">If set to </a><span class="EquationVariables">x</span>, any character data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.</div> <div class="gutter_text_right"><a name="441447">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="441448">-1</a></div> <div class="gutter_text_right"><a name="220651">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');" name="245851">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="469449">Bulk Options</a></div> <div class="gutter_text_right"><a name="469450">Attribute</a></div> <div class="Body_attr"><a name="469452">BulkLoadOptions (BLO)</a></div> <div class="gutter_text_right"><a name="469649">Description</a></div> <div class="Body"><a name="544299">Toggles options for the bulk load process. </a></div> <div class="Body_attr"><a name="471262">This option only applies to connections to Oracle 11g R2 and higher database servers.</a></div> <div class="gutter_text_right"><a name="471234">Valid Values</a></div> <div class="Body"><a name="545293">0 | </a><span class="Emphasis">x</span></div> <div class="Body"><a name="545294">where </a><span class="Emphasis">x</span> is a positive integer representing the cumulative total of the Bulk Options values.</div> <div class="Body"><a name="545295">If set to 0, none of the options for bulk load are enabled.</a></div> <div class="Body"><a name="545296">If set to </a><span class="Emphasis">x</span>, the values represented by x are enabled.</div> <div class="Body"><a name="545297">NOTE: The cumulative value of the options is only used in a connection string with the </a>connection string attribute, BulkLoadOptions. On the Bulk tab of the driver Setup dialog, the individual options are enabled by selecting the appropriate check box.</div> <div class="Body"><a name="471543">Currently, the only bulk load option available is:</a></div> <div class="Body"><a name="471558">No Index Errors - The driver stops a bulk load operation when a value that would cause an </a>index to be invalidated is loaded. For example, if a value is loaded that violates a unique or non-null constraint, the driver stops the bulk load operation and discards all data being loaded, including any data that was loaded prior to the problem value. If not enabled, the bulk load operation continues even if a value that would cause an index to be invalidated is loaded. Value=128.</div> <div class="gutter_text_right"><a name="469460">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="469461">0</a></div> <div class="gutter_text_right"><a name="469462">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');" name="469467">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="221037">Cached Cursor Limit</a></div> <div class="gutter_text_right"><a name="221038">Attribute</a></div> <div class="Body_attr"><a name="221040">CachedCursorLimit (CCL)</a></div> <div class="gutter_text_right"><a name="221041">Description</a></div> <div class="Body"><a name="245768">Specifies the number of Oracle Cursor Identifiers that the driver stores in cache. A Cursor </a>Identifier is needed for each concurrent open Select statement. When a Select statement is closed, the driver stores the identifier in its cache, up to the limit specified, rather than closing the Cursor Identifier. When a new Cursor Identifier is needed, the driver takes one from its cache, if one is available. Cached Cursor Identifiers are closed when the connection is closed.</div> <div class="Body"><a name="245840">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="245767">Valid Values</a></div> <div class="Body"><a name="245812">An integer from 0 to 65535</a></div> <div class="gutter_text_right"><a name="245811">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="245882">32</a></div> <div class="gutter_text_right"><a name="245883">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="245892">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="245893">Cached Description Limit</a></div> <div class="gutter_text_right"><a name="221133">Attribute</a></div> <div class="Body_attr"><a name="221135">CachedDescriptionLimit (CDL)</a></div> <div class="gutter_text_right"><a name="221136">Description</a></div> <div class="Body"><a name="245930">Specifies the number of descriptions that the driver saves for Select statements. These </a>descriptions include the number of columns, data type, length, and scale for each column. The matching is done by an exact-text match through the FROM clause.</div> <div class="Body"><a name="246013">NOTE: If the Select statement contains a Union or a nested Select, the description is not </a>cached.</div> <div class="Body"><a name="246014">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="245977">Valid Values</a></div> <div class="Body"><a name="245978">An integer from 0 to 65535</a></div> <div class="gutter_text_right"><a name="245925">Default</a></div> <div class="Body"><a name="221138">0</a></div> <div class="gutter_text_right"><a name="221154">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="246051">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="221156">Catalog Functions Include Synonyms</a></div> <div class="gutter_text_right"><a name="291644">Attribute</a></div> <div class="Body_attr"><a name="291645">CatalogIncludesSynonyms (CIS)</a></div> <div class="gutter_text_right"><a name="291646">Description</a></div> <div class="Body"><a name="544604">Determines whether synonyms are included in calls to SQLProcedures, SQLStatistics, and </a>SQLProcedureColumns.</div> <div class="Body"><a name="291651">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="291655">Valid Values</a></div> <div class="Body"><a name="544608">0 | 1</a></div> <div class="Body"><a name="544609">If set to 1 (Enabled), synonyms are included in calls to SQLProcedures, SQLStatistics, and </a>SQLProcedureColumns. </div> <div class="Body"><a name="544610">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="379719">Default</a></div> <div class="Body"><a name="291663">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="221179">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="247939">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="221374">Catalog Options</a></div> <div class="gutter_text_right"><a name="221375">Attribute</a></div> <div class="Body_attr"><a name="221377">CatalogOptions (CO)</a></div> <div class="gutter_text_right"><a name="248167">Description</a></div> <div class="Body"><a name="544614">Determines whether SQL_NULL_DATA is returned for the result columns REMARKS and </a>COLUMN_DEF.</div> <div class="Body"><a name="248934">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="248169">Valid Values</a></div> <div class="Body"><a name="544618">0 | 1</a></div> <div class="Body"><a name="544619">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="544620">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="247969">Default</a></div> <div class="Body"><a name="221380">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="221398">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="248945">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="439144">Client Host Name</a></div> <div class="gutter_text_right"><a name="439145">Attribute</a></div> <div class="Body_attr"><a name="439147">ClientHostName (CHN)</a></div> <div class="gutter_text_right"><a name="439148">Description</a></div> <div class="Body"><a name="452244">The host name of the client machine to be stored in the database. This value sets the </a>MACHINE value in the V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="439432">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="439359">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="443709">string</a></span></div> <div class="Body"><a name="443710">where </a><span class="EquationVariables">string</span> is the host name of the client machine.</div> <div class="Body"><a name="443786">If a value for this option is not specified, the driver uses the current machine name and IP </a>address in the following format:</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="443768">machine_name/IP_address</a></span></div> <div class="gutter_text_right"><a name="443711">Default</a></div> <div class="Body"><a name="439158">None</a></div> <div class="gutter_text_right"><a name="439159">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="439318">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="443066">Client ID</a></div> <div class="gutter_text_right"><a name="443067">Attribute</a></div> <div class="Body_attr"><a name="443069">ClientID (CID)</a></div> <div class="gutter_text_right"><a name="443070">Description</a></div> <div class="Body"><a name="452250">Additional information about the client to be stored in the database. This value sets the </a>CLIENT_IDENTIFIER value in the V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="443228">This option only applies to connections to Oracle 10</a><span class="Emphasis">g</span> R2 and higher database servers.</div> <div class="Body"><a name="443071">NOTE: You can also specify this information using the Oracle </a>DBMS_SESSION.SETIDENTIFIER procedure or the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure.</div> <div class="Body"><a name="443074">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="443076">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="443077">string</a></span></div> <div class="Body"><a name="443078">where string is additional information about the client.</a></div> <div class="gutter_text_right"><a name="443079">Default</a></div> <div class="Body"><a name="443080">None</a></div> <div class="gutter_text_right"><a name="443081">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="443086">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="439167">Client User</a></div> <div class="gutter_text_right"><a name="439168">Attribute</a></div> <div class="Body_attr"><a name="439170">ClientUser (CU)</a></div> <div class="gutter_text_right"><a name="439171">Description</a></div> <div class="Body"><a name="452256">The user ID to be stored in the database. This value sets the OSUSER value in the </a>V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="439172">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="439177">Valid Values</a></div> <div class="Body"><a name="439178">-1 | </a><span class="EquationVariables">string</span> </div> <div class="Body"><a name="439179">where </a><span class="EquationVariables">string</span> is a valid user ID.</div> <div class="Body"><a name="439180">The value -1 means that the driver uses the userid of the user that is currently logged onto </a>the client.</div> <div class="Body"><a name="480597">If a value for this option is not specified, the driver uses name of the user that is currently </a>logged into the OS.</div> <div class="gutter_text_right"><a name="439181">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="439182">None</a></div> <div class="gutter_text_right"><a name="439183">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="439328">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="233459">Connection Pooling</a></div> <div class="gutter_text_right"><a name="233460">Attribute</a></div> <div class="Body_attr"><a name="233462">Pooling (POOL)</a></div> <div class="gutter_text_right"><a name="233463">Description</a></div> <div class="Body"><a name="544624">Specifies whether to use the driverâ??s connection pooling.</a></div> <div class="Body"><a name="544625">NOTE: The application must be thread-enabled to use connection pooling.</a></div> <div class="Body"><a name="387462">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="249779">Valid Values</a></div> <div class="Body"><a name="544629">0 | 1</a></div> <div class="Body"><a name="544630">If set to 1 (Enabled), the driver uses connection pooling. </a></div> <div class="Body"><a name="544631">If set to 0 (Disabled), the driver does not use connection pooling.</a></div> <div class="gutter_text_right"><a name="249959">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="233465">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="250871">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109100', '');" name="250880">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="250881">Connection Reset</a></div> <div class="gutter_text_right"><a name="221607">Attribute</a></div> <div class="Body_attr"><a name="221609">ConnectionReset (CR)</a></div> <div class="gutter_text_right"><a name="221610">Description</a></div> <div class="Body"><a name="544635">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="387475">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="250896">Valid Values</a></div> <div class="Body"><a name="544639">0 | 1</a></div> <div class="Body"><a name="544640">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="544641">If set to 0 (Disabled), the state of connections is not reset.</a></div> <div class="gutter_text_right"><a name="250892">Default</a></div> <div class="Body"><a name="221612">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="221626">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109100', '');" name="252449">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="221689">Connection Retry Count</a></div> <div class="gutter_text_right"><a name="221690">Attribute</a></div> <div class="Body_attr"><a name="221692">ConnectionRetryCount (CRC)</a></div> <div class="gutter_text_right"><a name="221693">Description</a></div> <div class="Body"><a name="544645">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="544646">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="277270">Valid Values</a></div> <div class="Body"><a name="544650">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="544651">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="544652">If set to 0, the driver does not try to connect after the initial unsuccessful attempt.</a></div> <div class="Body"><a name="544653">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="277276">Default</a></div> <div class="Body"><a name="277277">0</a></div> <div class="gutter_text_right"><a name="221711">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');" name="254333">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="221713">Connection Retry Delay</a></div> <div class="gutter_text_right"><a name="221714">Attribute</a></div> <div class="Body_attr"><a name="221716">ConnectionRetryDelay (CRD)</a></div> <div class="gutter_text_right"><a name="254352">Description</a></div> <div class="Body"><a name="544657">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="544658">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="254354">Valid Values</a></div> <div class="Body"><a name="544662">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="544663">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="544664">If set to 0, there is no delay between retries.</a></div> <div class="Body"><a name="544665">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="254359">Default</a></div> <div class="Body"><a name="254361">3</a></div> <div class="gutter_text_right"><a name="254378">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');" name="293859">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="293861">Data Source Name</a></div> <div class="gutter_text_right"><a name="293862">Attribute</a></div> <div class="Body_attr"><a name="293864">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="293865">Description</a></div> <div class="Body"><a name="544669">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="293870">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="544673">string</a></span> </div> <div class="Body"><a name="544674">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="293876">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="293878">None</a></div> <div class="gutter_text_right"><a name="293879">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="293884">General tab</a></span></div> <div class="head_2_no_TOC"><a name="293885">Default Buffer Size for Long/LOB Columns (in</a> Kb)</div> <div class="gutter_text_right"><a name="222202">Attribute</a></div> <div class="Body_attr"><a name="222204">DefaultLongDataBuffLen (DLDBL)</a></div> <div class="gutter_text_right"><a name="222205">Description</a></div> <div class="Body"><a name="544678">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="255052">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="254397">Valid Values</a></div> <div class="Body"><a name="544682">An integer in multiples of 1024</a></div> <div class="Body"><a name="544683">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="254401">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="222207">1024</a></div> <div class="gutter_text_right"><a name="222225">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="255374">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="222772">Describe at Prepare</a></div> <div class="gutter_text_right"><a name="222773">Attribute</a></div> <div class="Body_attr"><a name="222775">DescribeAtPrepare (DAP)</a></div> <div class="gutter_text_right"><a name="222776">Description</a></div> <div class="Body"><a name="544687">Determines whether the driver describes the SQL statement at prepare time.</a></div> <div class="Body"><a name="255979">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="255749">Valid Values</a></div> <div class="Body"><a name="544691">0 | 1</a></div> <div class="Body"><a name="544692">If set to 1 (Enabled), the driver describes the SQL statement at prepare time.</a></div> <div class="Body"><a name="544693">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="255584">Default</a></div> <div class="Body"><a name="222778">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="222795">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="256028">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="223893">Description</a></div> <div class="gutter_text_right"><a name="223894">Attribute</a></div> <div class="Body_attr"><a name="223896">Description (n/a)</a></div> <div class="gutter_text_right"><a name="256062">Description</a></div> <div class="Body"><a name="544697">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="256067">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="544701">string</a></span> </div> <div class="Body"><a name="544702">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="256070">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="256102">None</a></div> <div class="gutter_text_right"><a name="256103">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="256108">General tab</a></span></div> <div class="head_2_no_TOC"><a name="442307">Edition Name</a></div> <div class="gutter_text_right"><a name="442308">Attribute</a></div> <div class="Body_attr"><a name="442310">EditionName (EN)</a></div> <div class="gutter_text_right"><a name="442311">Description</a></div> <div class="Body"><a name="544706">The name of the Oracle edition the driver uses when establishing a connection. Oracle </a>11<span class="Emphasis">g</span> R2 and higher allows your database administrator to create multiple editions of schema objects so that your application can still use those objects while the database is being upgraded. This option is only valid for Oracle 11<span class="Emphasis">g</span> R2 and higher databases and tells the driver which edition of the schema objects to use.</div> <div class="Body"><a name="544707">The driver uses the default edition in the following cases:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="544708">When the specified edition is not a valid edition. The driver generates a warning </a>indicating that it was unable to set the current edition to the specified edition.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="544709">When the value for this option is not specified or is set to an empty string.</a></div> </td> </tr> </table> </div> <div class="Body"><a name="544710">If failover is enabled using the Failover Mode connection option and a connection fails over </a>to another database server, the driver connects to the alternate server using the same edition that was used for the failed connection. The driver does not track changes to the current edition made using the ALTER SESSION SQL statement.</div> <div class="gutter_text_right"><a name="442317">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="544714">string</a></span></div> <div class="Body"><a name="544715">where </a><span class="EquationVariables">string</span> is the name of a valid Oracle edition.</div> <div class="gutter_text_right"><a name="442320">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="442321">None</a></div> <div class="gutter_text_right"><a name="442322">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="447561">General tab</a></span></div> <div class="head_2_no_TOC"><a name="256109">Enable Bulk Load</a></div> <div class="gutter_text_right"><a name="224118">Attribute</a></div> <div class="Body_attr"><a name="224120">EnableBulkLoad (EBL)</a></div> <div class="gutter_text_right"><a name="256122">Description</a></div> <div class="Body"><a name="544719">Specifies the bulk load method. </a></div> <div class="gutter_text_right"><a name="256127">Valid Values</a></div> <div class="Body"><a name="544723">0 | 1</a></div> <div class="Body"><a name="544724">If set to 1 (Enabled), the driver uses the database bulk load protocol when an application </a>executes an INSERT with multiple rows of parameter data. If the protocol cannot be used, the driver returns a warning.</div> <div class="Body"><a name="544725">If set to 0 (Disabled), the driver uses standard parameter arrays.</a></div> <div class="Body"><a name="482262">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.08.html#454371', '');">â??DataDirect Bulk Loadâ??</a></span> for further details.</div> <div class="gutter_text_right"><a name="256131">Default</a></div> <div class="Body"><a name="256133">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="224138">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');" name="256145">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="225514">Enable N-CHAR Support</a></div> <div class="gutter_text_right"><a name="225515">Attribute</a></div> <div class="Body_attr"><a name="225516">EnableNcharSupport (ENS)</a></div> <div class="gutter_text_right"><a name="225517">Description</a></div> <div class="Body"><a name="544729">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="256771">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.07.html#110178', '');">â??Unicode Supportâ??</a></span> for details.</div> <div class="Body"><a name="256862">NOTE: Valid only on Oracle 9</a><span class="Emphasis">i</span> and higher.</div> <div class="gutter_text_right"><a name="256159">Valid Values</a></div> <div class="Body"><a name="544733">0 | 1</a></div> <div class="Body"><a name="544734">If set to 1 (Enabled), the driver provides support for the N-types NCHAR, NVARCHAR2, and </a>NCLOB. </div> <div class="Body"><a name="544735">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="256673">Default</a></div> <div class="Body"><a name="256674">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="225536">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="256901">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="226830">Enable Scrollable Cursors</a></div> <div class="gutter_text_right"><a name="226831">Attribute</a></div> <div class="Body_attr"><a name="226833">EnableScrollableCursors (ESC)</a></div> <div class="gutter_text_right"><a name="226834">Description</a></div> <div class="Body"><a name="544739">Determines whether scrollable cursors, both Keyset and Static, are enabled for the data </a>source.</div> <div class="Body"><a name="257160">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="256963">Valid Values</a></div> <div class="Body"><a name="544743">0 | 1</a></div> <div class="Body"><a name="544744">If set to 1 (Enabled), scrollable cursors are enabled for the data source. </a></div> <div class="Body"><a name="544745">If set to 0 (Disabled), scrollable cursors are not enabled.</a></div> <div class="gutter_text_right"><a name="256992">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="226836">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="226853">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="257171">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="227856">Enable Server Result Cache</a></div> <div class="gutter_text_right"><a name="227857">Attribute</a></div> <div class="Body_attr"><a name="227859">EnableServerResultCache (ESRC)</a></div> <div class="gutter_text_right"><a name="227860">Description</a></div> <div class="Body"><a name="257204">Determines whether the driver sets the RESULT_CACHE_MODE session parameter to </a>FORCE.</div> <div class="Body"><a name="257382">This option only applies to connections to Oracle 11</a><span class="Emphasis">g</span> database servers that support server-side result set caching.</div> <div class="Body"><a name="318133">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="257195">Valid Values</a></div> <div class="Body"><a name="257200">0 | 1</a></div> <div class="Body"><a name="257543">If set to 1 (Enabled), the driver sets the RESULT_CACHE_MODE session parameter to </a>FORCE.</div> <div class="Body"><a name="257545">If set to 0 (Disabled), the driver does not sets the RESULT_CACHE_MODE session </a>parameter. </div> <div class="gutter_text_right"><a name="257199">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="227862">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="227872">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="257776">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="224249">Enable SQLDescribeParam</a></div> <div class="gutter_text_right"><a name="224250">Attribute</a></div> <div class="Body_attr"><a name="224252">EnableDescribeParam (EDP)</a></div> <div class="gutter_text_right"><a name="224253">Description</a></div> <div class="Body"><a name="544749">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="295639">Valid Values</a></div> <div class="Body"><a name="544753">0 | 1</a></div> <div class="Body"><a name="544754">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="544755">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="295750">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="224255">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="227182">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="296142">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="228020">Enable Static Cursors for Long Data</a></div> <div class="gutter_text_right"><a name="228021">Attribute</a></div> <div class="Body_attr"><a name="228023">EnableStaticCursorsForLongData (ESCLD)</a></div> <div class="gutter_text_right"><a name="296871">Description</a></div> <div class="Body"><a name="544759">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="296898">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text"><a name="296907">Valid Values</a></div> <div class="Body"><a name="544763">0 | 1</a></div> <div class="Body"><a name="544764">If set to 1 (Enabled), the driver supports Long columns when using a static cursor.</a></div> <div class="Body"><a name="544765">If set to 0 (Disabled), the driver does not support Long columns when using a static cursor. </a></div> <div class="Body"><a name="544766">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="296297">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="228026">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="228044">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="296933">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="228252">Enable Timestamp with Timezone</a></div> <div class="gutter_text_right"><a name="228253">Attribute</a></div> <div class="Body_attr"><a name="228255">EnableTimestampwithTimezone (ETWT)</a></div> <div class="gutter_text_right"><a name="228256">Description</a></div> <div class="Body"><a name="544770">Determines whether the driver exposes timestamps with timezones to the application. </a></div> <div class="gutter_text_right"><a name="296962">Valid Values</a></div> <div class="Body"><a name="544774">0 | 1</a></div> <div class="Body"><a name="544775">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="544776">If set to 0 (Disabled), timestamps with timezones are not exposed to the application.</a></div> <div class="gutter_text_right"><a name="297845">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="228258">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="228271">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="298009">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="228433">Encryption Method</a></div> <div class="gutter_text_right"><a name="228434">Attribute</a></div> <div class="Body_attr"><a name="228436">EncryptionMethod (EM)</a></div> <div class="gutter_text_right"><a name="228437">Description</a></div> <div class="Body"><a name="544780">The method the driver uses to encrypt data sent between the driver and the database </a>server. If the specified encryption method is not supported by the database server, the connection fails and the driver returns an error.</div> <div class="Body"><a name="299558">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="298017">Valid Values</a></div> <div class="Body"><a name="298730">0 | 1 | 3 | 4 | 5</a></div> <div class="Body"><a name="544784">If set to 0 (No Encryption), data is not encrypted.</a></div> <div class="Body"><a name="544785">If set to 1 (SSL), data is encrypted using SSL. If the server supports protocol negotiation, </a>the driver and server negotiate the use of TLS v1, SSL v3, or SSL v2 in that order.</div> <div class="Body"><a name="299600">If set to 3 (SSL3), the driver uses SSL3 data encryption.</a></div> <div class="Body"><a name="299334">If set to 4 (SSL2), the driver uses SSL2 data encryption.</a></div> <div class="Body"><a name="299335">If set to 5 (TLS1), the driver uses TLS1 data encryption.</a></div> <div class="Body"><a name="344588">NOTE: Consult your database administrator concerning the SSL settings of your Oracle </a>server.</div> <div class="gutter_text_right"><a name="298729">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="228439">0 (No Encryption)</a></div> <div class="gutter_text_right"><a name="228461">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="299620">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="228653">Failover Granularity</a></div> <div class="gutter_text_right"><a name="228654">Attribute</a></div> <div class="Body_attr"><a name="228656">FailoverGranularity (FG)</a></div> <div class="gutter_text_right"><a name="228657">Description</a></div> <div class="Body"><a name="544789">Determines whether the driver fails the entire failover process or continues with the process </a>if errors occur while trying to reestablish a lost connection. </div> <div class="Body"><a name="544790">This option applies only when Failover Mode is set to 1 (Extended Connection) or 2 </a>(Select). </div> <div class="Body"><a name="544791">The Alternate Servers option specifies one or multiple alternate servers for failover and is </a>required for all failover methods.</div> <div class="gutter_text_right"><a name="300304">Valid Values</a></div> <div class="Body"><a name="544795">0 | 1 | 2 | 3</a></div> <div class="Body"><a name="544796">If set to 0 (Non-Atomic), the driver continues with the failover process and posts any errors </a>on the statement on which they occur. </div> <div class="Body"><a name="544797">If set to 1 (Atomic) the driver fails the entire failover process if an error is generated as the </a>result of anything other than executing and repositioning a Select statement. If an error is generated as a result of repositioning a result set to the last row position, the driver continues with the failover process, but generates a warning that the Select statement must be reissued. </div> <div class="Body"><a name="544798">If set to 2 (Atomic Including Repositioning), the driver fails the entire failover process if any </a>error is generated as the result of restoring the state of the connection or the state of work in progress.</div> <div class="Body"><a name="544799">If set to 3 (Disable Integrity Check), the driver does not verify that the rows that were </a>restored during the failover process match the original rows. This value applies only when Failover Mode is set to 2 (Select).</div> <div class="gutter_text_right"><a name="313999">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="314001">0 (Non-Atomic)</a></div> <div class="gutter_text_right"><a name="300368">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');" name="300369">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="228680">Failover Mode</a></div> <div class="gutter_text_right"><a name="228681">Attribute</a></div> <div class="Body_attr"><a name="228683">FailoverMode (FM)</a></div> <div class="gutter_text_right"><a name="314218">Description</a></div> <div class="Body"><a name="544803">Specifies the type of failover method the driver uses. </a></div> <div class="Body"><a name="544804">The Alternate Servers option specifies one or multiple alternate servers for failover and is </a>required for all failover methods.</div> <div class="gutter_text_right"><a name="314224">Valid Values</a></div> <div class="Body"><a name="544808">0 | 1 | 2</a></div> <div class="Body"><a name="544809">If set to 0 (Connection), the driver provides failover protection for new connections only. </a></div> <div class="Body"><a name="544810">If set to 1 (Extended Connection), the driver provides failover protection for new and lost </a>connections, but not any work in progress. </div> <div class="Body"><a name="544811">If set to 2 (Select), the driver provides failover protection for new and lost connections. In </a>addition, it preserves the state of work performed by the last Select statement executed.</div> <div class="gutter_text_right"><a name="314232">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="314234">0 (Connection)</a></div> <div class="gutter_text_right"><a name="228703">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');" name="314346">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="228705">Failover Preconnect</a></div> <div class="gutter_text_right"><a name="228706">Attribute</a></div> <div class="Body_attr"><a name="228708">FailoverPreconnect (FP)</a></div> <div class="gutter_text_right"><a name="314365">Description</a></div> <div class="Body"><a name="544815">Specifies whether the driver tries to connect to the primary and an alternate server at the </a>same time. </div> <div class="Body"><a name="544816">This attribute applies only when Failover Mode is set to 1 (Extended Connection) or 2 </a>(Select) and at least one alternate server is specified.</div> <div class="Body"><a name="544817">The Alternate Servers option specifies one or multiple alternate servers for failover and is </a>required for all failover methods.</div> <div class="gutter_text_right"><a name="314372">Valid Values</a></div> <div class="Body"><a name="544821">0 | 1</a></div> <div class="Body"><a name="544822">If set to 0 (Disabled), the driver tries to connect to an alternate server only when failover is </a>caused by an unsuccessful connection attempt or a lost connection. This value provides the best performance, but your application typically experiences a short wait while the failover connection is attempted.</div> <div class="Body"><a name="544823">If set to 1 (Enabled), the driver tries to connect to the primary and an alternate server at the </a>same time. This can be useful if your application is time-sensitive and cannot absorb the wait for the failover connection to succeed.</div> <div class="gutter_text_right"><a name="314379">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="314381">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="301290">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');" name="301299">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="344962">Fetch TSWTZ as Timestamp</a></div> <div class="gutter_text_right"><a name="344963">Attribute</a></div> <div class="Body_attr"><a name="344965">FetchTSWTZasTimestamp (FTSWTZAT)</a></div> <div class="gutter_text_right"><a name="344966">Description</a></div> <div class="Body"><a name="544827">Determines whether the driver returns column values with the timestamp with time zone </a>data type as the ODBC data type SQL_TYPE_TIMESTAMP or SQL_VARCHAR.</div> <div class="Body"><a name="345490">Valid on Oracle 10</a><span class="Emphasis">g</span> R2 or higher.</div> <div class="gutter_text_right"><a name="345491">Valid Values</a></div> <div class="Body"><a name="544831">0 | 1</a></div> <div class="Body"><a name="544832">If set to 1 (Enabled), the driver returns column values with the timestamp with time zone </a>data type as the ODBC type SQL_TYPE_TIMESTAMP. The time zone information in the fetched value is truncated. Use this value if your application needs to process values the same way as TIMESTAMP columns.</div> <div class="Body"><a name="544833">If set to 0 (Disabled), the driver returns column values with the timestamp with time zone </a>data type as the ODBC data type SQL_VARCHAR. Use this value if your application requires the time zone information in the fetched value.</div> <div class="gutter_text_right"><a name="344972">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="344974">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="345115">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="345120">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="521686">Field Delimiter</a></div> <div class="gutter_text_right"><a name="521687">Attribute</a></div> <div class="Body_attr"><a name="521688">BulkLoadFieldDelimiter (BLFD)</a></div> <div class="gutter_text_right"><a name="521689">Description</a></div> <div class="Body"><a name="545352">Specifies the character that the driver will use to delimit the field entries in a bulk load data </a>file.</div> <div class="gutter_text_right"><a name="521694">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="545356">x</a></span></div> <div class="Body"><a name="545357">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="545358">For simplicity, avoid using a value that can be in the data, including all alphanumeric </a>characters, the dash(-), the colon(:), the period (.), the forward slash (/), the space character, the single quote (') and the double quote ("). You can use some of these characters as delimiters if all of the data in the file is contained within double quotes.</div> <div class="Body"><a name="545359">NOTE: The Bulk Load Field Delimiter character must be different from the Bulk Load </a>Record Delimiter.</div> <div class="gutter_text_right"><a name="521702">Default</a></div> <div class="Body"><a name="521703">None</a></div> <div class="gutter_text_right"><a name="521704">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');" name="521709">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="301300">GSS Client Library</a></div> <div class="gutter_text_right"><a name="228993">Attribute</a></div> <div class="Body_attr"><a name="228995">GSSClient (GSSC)</a></div> <div class="gutter_text_right"><a name="314546">Description</a></div> <div class="Body"><a name="544837">The name of the GSS client library that the driver uses to communicate with the Key </a>Distribution Center (KDC). </div> <div class="Body"><a name="544838">The driver uses the path defined by the PATH environment variable for loading the specified </a>client library.</div> <div class="gutter_text_right"><a name="314552">Valid Values</a></div> <div class="Body"><a name="544842">native | </a><span class="EquationVariables">client_library</span></div> <div class="Body"><a name="544843">where </a><span class="EquationVariables">client_library</span> is a GSS client library installed on the client.</div> <div class="Body"><a name="544844">If set to </a><span class="EquationVariables">client_library</span>, the driver uses the specified GSS client library.</div> <div class="Body"><a name="544845">If set to native, the driver uses the GSS client shipped with the operating system.</a></div> <div class="gutter_text_right"><a name="314560">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="314562">native</a></div> <div class="gutter_text_right"><a name="229014">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="301305">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="229272">Host</a></div> <div class="gutter_text_right"><a name="229273">Attribute</a></div> <div class="Body_attr"><a name="229275">HostName (HOST)</a></div> <div class="gutter_text_right"><a name="229276">Description</a></div> <div class="Body"><a name="544849">The name or the IP address of the server to which you want to connect.</a></div> <div class="gutter_text_right"><a name="300419">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="544853">server_name</a></span> | <span class="EquationVariables">IP_address</span></div> <div class="Body"><a name="544854">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="544855">server_name</a></span> is the name of the server to which you want to connect.</div> <div class="Body"><span class="EquationVariables"><a name="544856">IP_address</a></span> is the IP address of the server to which you want to connect.</div> <div class="Body"><a name="545344">The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two. </a>See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'usingproduct.05.05.html#107073', '');">â??Using IP Addressesâ??</a></span> for details about these formats.</div> <div class="Body"><a name="478860">NOTE: This option is mutually exclusive with the Server Name and TNSNames File options.</a></div> <div class="gutter_text_right"><a name="314754">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="229278">None</a></div> <div class="gutter_text_right"><a name="229302">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="300475">General tab</a></span></div> <div class="head_2_no_TOC"><a name="229016">Host Name In Certificate</a></div> <div class="gutter_text_right"><a name="229017">Attribute</a></div> <div class="Body_attr"><a name="412843">HostNameInCertificate (HNIC)</a></div> <div class="gutter_text_right"><a name="314836">Description</a></div> <div class="Body"><a name="544860">A host name for certificate validation when SSL encryption is enabled (Encryption Method=</a>1) and validation is enabled (Validate Server Certificate=1). This option provides additional security against man-in-the-middle (MITM) attacks by ensuring that the server the driver is connecting to is the server that was requested.</div> <div class="gutter_text_right"><a name="314841">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="544864">host_name | #SERVERNAME#</a></span> </div> <div class="Body"><a name="544865">where the </a><span class="EquationVariables">host_name</span> is the host name specified in the certificate. Consult your SSL administrator for the correct value.</div> <div class="Body"><a name="544866">If set to a host name, the driver examines the subjectAltName values included in the </a>certificate. If a dnsName value is present in the subjectAltName values, then the driver compares the value specified for Host Name In Certificate with the dnsName value. The connection succeeds if the values match. The connection fails if the Host Name In Certificate value does not match the dnsName value.</div> <div class="Body"><a name="544867">If no subjectAltName values exist or a dnsName value is not in the list of subjectAltName </a>values, then the driver compares the value specified for Host Name In Certificate with the commonName part of the Subject name in the certificate. The commonName typically contains the host name of the machine for which the certificate was created. The connection succeeds if the values match. The connection fails if the Host Name In Certificate value does not match the commonName. If multiple commonName parts exist in the Subject name of the certificate, the connection succeeds if the Host Name In Certificate value matches any of the commonName parts.</div> <div class="Body"><a name="544868">If set to </a><span class="EquationVariables">#SERVERNAME#</span>, the driver compares the host server name specified as part of a data source or connection string to the dnsName or the commonName value.</div> <div class="gutter_text_right"><a name="314851">Default</a></div> <div class="Body"><a name="229042">None</a></div> <div class="gutter_text_right"><a name="314991">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="303681">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="230383">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="230384">Attribute</a></div> <div class="Body_attr"><a name="230386">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="304350">Description</a></div> <div class="Body"><a name="544872">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="544880">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="544881">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="544882">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="544883">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="544884">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="544885">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="304366">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="544889">IANA_code_page</a></span> </div> <div class="Body"><a name="544891">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="304374">Default</a></div> <div class="Body"><a name="304595">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="304596">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="304605">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="304606">Initialization String</a></div> <div class="gutter_text_right"><a name="230609">Attribute</a></div> <div class="Body_attr"><a name="230611">InitializationString (IS)</a></div> <div class="gutter_text_right"><a name="230612">Description</a></div> <div class="Body"><a name="544898">A SQL command that is issued immediately after connecting to the database to manage </a>session settings. </div> <div class="Body"><a name="544899">NOTE: If the statement fails to execute, the connection fails and the driver reports the error </a>returned from the server.</div> <div class="gutter_text_right"><a name="544903">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="544904">SQL_command</a></span></div> <div class="Body"><a name="544905">where </a><span class="EquationVariables">SQL_command</span> is a valid SQL command that is supported by the database.</div> <div class="gutter_text_right"><a name="413508">Example</a></div> <div class="Body"><a name="367687">To set the date format on every connection, specify:</a></div> <div class="syntax_first"><a name="367688">Initialization String=ALTER SESSION SET DATE_FORMAT = 'DD/MM/YYYY'</a></div> <div class="gutter_text_right"><a name="294152">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="230614">None</a></div> <div class="gutter_text_right"><a name="230629">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="294065">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="230837">Key Password</a></div> <div class="gutter_text_right"><a name="230838">Attribute</a></div> <div class="Body_attr"><a name="230840">KeyPassword (KP)</a></div> <div class="gutter_text_right"><a name="262654">Description</a></div> <div class="Body"><a name="544909">The password used to access the individual keys in the keystore file when SSL is enabled </a>(Encryption Method=1) and SSL client authentication is enabled on the database server. Keys stored in a keystore can be individually password-protected. To extract the key from the keystore, the driver must have the password of the key.</div> <div class="gutter_text_right"><a name="262659">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="544913">key_password</a></span></div> <div class="Body"><a name="544914">where </a><span class="EquationVariables">key_password</span> is the password of a key in the keystore.</div> <div class="gutter_text_right"><a name="262662">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="262663">None</a></div> <div class="gutter_text_right"><a name="262690">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="262716">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="230858">Keystore</a></div> <div class="gutter_text_right"><a name="230859">Attribute</a></div> <div class="Body_attr"><a name="230861">Keystore (KS)</a></div> <div class="gutter_text_right"><a name="262753">Description</a></div> <div class="Body"><a name="544918">The name of the directory containing the keystore file to be used when SSL is enabled </a>(Encryption Method=1) and SSL client authentication is enabled on the database server. The keystore file contains the certificates that the client sends to the server in response to the serverâ??s certificate request. If you do not specify a directory, the current directory is used.</div> <div class="Body"><a name="544919">NOTE: The keystore and truststore files may be the same file.</a></div> <div class="gutter_text_right"><a name="280587">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="544923">keystore_directory</a></span></div> <div class="Body"><a name="544924">where </a><span class="EquationVariables">keystore_directory</span> is the location of the keystore file.</div> <div class="gutter_text_right"><a name="280590">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="262763">None</a></div> <div class="gutter_text_right"><a name="230878">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="262784">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="230880">Keystore Password</a></div> <div class="gutter_text_right"><a name="230881">Attribute</a></div> <div class="Body_attr"><a name="230883">KeystorePassword (KSP)</a></div> <div class="gutter_text_right"><a name="262805">Description</a></div> <div class="Body"><a name="544928">The password used to access the keystore file when SSL is enabled (Encryption Method=1) </a>and SSL client authentication is enabled on the database server. The keystore file contains the certificates that the client sends to the server in response to the serverâ??s certificate request. </div> <div class="Body"><a name="544929">NOTE: The keystore and truststore files may be the same file; therefore, they may have the </a>same password.</div> <div class="gutter_text_right"><a name="262811">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="544933">keystore_password</a></span></div> <div class="Body"><a name="544934">where </a><span class="EquationVariables">keystore_password</span> is the password of the keystore file.</div> <div class="gutter_text_right"><a name="262814">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="262815">None</a></div> <div class="gutter_text_right"><a name="262824">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="230900">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="231371">Load Balance Timeout</a></div> <div class="gutter_text_right"><a name="231372">Attribute</a></div> <div class="Body_attr"><a name="231374">LoadBalanceTimeout (LBT)</a></div> <div class="gutter_text_right"><a name="262832">Description</a></div> <div class="Body"><a name="544938">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="544939">NOTE: The Min Pool Size option may cause some connections to ignore this value.</a></div> <div class="Body"><a name="387520">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="262839">Valid Values</a></div> <div class="Body"><a name="544943">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="544944">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="544945">If set to 0, inactive connections are kept open.</a></div> <div class="Body"><a name="544946">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="262844">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="262846">0</a></div> <div class="gutter_text_right"><a name="262911">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109100', '');" name="231391">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="231176">Load Balancing</a></div> <div class="gutter_text_right"><a name="231177">Attribute</a></div> <div class="Body_attr"><a name="231179">LoadBalancing (LB)</a></div> <div class="gutter_text_right"><a name="262970">Description</a></div> <div class="Body"><a name="544950">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="262975">Valid Values</a></div> <div class="Body"><a name="544954">0 | 1</a></div> <div class="Body"><a name="544955">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="544956">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="544957">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="262979">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="262981">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="263003">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109030', '');" name="231199">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="231448">Local Timezone Offset</a></div> <div class="gutter_text_right"><a name="231449">Attribute</a></div> <div class="Body_attr"><a name="231451">LocalTimezoneOffset (LTZO)</a></div> <div class="gutter_text_right"><a name="231452">Description</a></div> <div class="Body"><a name="544961">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="305636">Valid Values</a></div> <div class="Body"><a name="544965">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="544966">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="305643">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="231454">"" (empty string)</a></div> <div class="gutter_text_right"><a name="231468">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="307029">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="231510">Lock Timeout</a></div> <div class="gutter_text_right"><a name="231511">Attribute</a></div> <div class="Body_attr"><a name="231513">LockTimeout (LTO)</a></div> <div class="gutter_text_right"><a name="231514">Description</a></div> <div class="Body"><a name="544970">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="308548">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="307052">Valid Values</a></div> <div class="Body"><a name="544974">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="544975">where </a><span class="EquationVariables">x</span> is an integer that specifies a number of seconds.</div> <div class="Body"><a name="544976">If set to -1, the server waits indefinitely for the lock to be released.</a></div> <div class="Body"><a name="544977">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="544978">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="544979">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="307048">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="231516">-1</a></div> <div class="gutter_text_right"><a name="231536">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="308563">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="231750">Login Timeout</a></div> <div class="gutter_text_right"><a name="231751">Attribute</a></div> <div class="Body_attr"><a name="231753">LoginTimeout (LT)</a></div> <div class="gutter_text_right"><a name="263048">Description</a></div> <div class="Body"><a name="544983">The number of seconds the driver waits for a connection to be established before returning </a>control to the application and generating a timeout error. To override the value that is set by this connection option for an individual connection, set a different value in the SQL_ATTR_LOGIN_TIMEOUT connection attribute using the SQLSetConnectAttr() function.</div> <div class="gutter_text_right"><a name="263053">Valid Values</a></div> <div class="Body"><a name="544987">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="544988">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="544989">If set to -1, the connection request does not time out. The driver silently ignores the </a>SQL_ATTR_LOGIN_TIMEOUT attribute.</div> <div class="Body"><a name="544990">If set to 0, the connection request does not time out, but the driver responds to the </a>SQL_ATTR_LOGIN_TIMEOUT attribute.</div> <div class="Body"><a name="544991">If set to </a><span class="EquationVariables">x</span>, the connection request times out after the specified number of seconds unless the application overrides this setting with the SQL_ATTR_LOGIN_TIMEOUT attribute.</div> <div class="gutter_text_right"><a name="263059">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="263061">15</a></div> <div class="gutter_text_right"><a name="263072">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="231772">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="232419">Max Pool Size</a></div> <div class="gutter_text_right"><a name="232420">Attribute</a></div> <div class="Body_attr"><a name="232422">MaxPoolSize (MXPS)</a></div> <div class="gutter_text_right"><a name="263085">Description</a></div> <div class="Body"><a name="544995">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="387540">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="263090">Valid Values</a></div> <div class="Body"><a name="544999">An integer from 1 to 65535</a></div> <div class="Body"><a name="545000">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="263093">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="263095">100</a></div> <div class="gutter_text_right"><a name="263106">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109100', '');" name="232438">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="232440">Min Pool Size</a></div> <div class="gutter_text_right"><a name="232441">Attribute</a></div> <div class="Body_attr"><a name="232443">MinPoolSize (MNPS)</a></div> <div class="gutter_text_right"><a name="263519">Description</a></div> <div class="Body"><a name="545004">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="387556">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="263524">Valid Values</a></div> <div class="Body"><a name="545008">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="545009">where </a><span class="EquationVariables">x</span> is an integer from 1 to 65535.</div> <div class="Body"><a name="545010">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="545011">If set to 0, no connections are opened in addition to the current existing connection.</a></div> <div class="gutter_text_right"><a name="263527">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="263529">0</a></div> <div class="gutter_text_right"><a name="263631">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109100', '');" name="232459">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="443397">Module</a></div> <div class="gutter_text_right"><a name="443398">Attribute</a></div> <div class="Body_attr"><a name="443400">Module (MOD)</a></div> <div class="gutter_text_right"><a name="443401">Description</a></div> <div class="Body"><a name="452262">Additional information about the client to be stored in the database. This value sets the </a>CLIENT_IDENTIFIER value in the V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="443402">This option only applies to connections to Oracle 10</a><span class="Emphasis">g</span> R2 and higher database servers.</div> <div class="Body"><a name="443404">NOTE: You can also specify this information using the Oracle </a>DBMS_SESSION.SETIDENTIFIER procedure or the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure.</div> <div class="Body"><a name="443407">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="443480">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="444205">string</a></span></div> <div class="Body"><a name="444206">where </a><span class="EquationVariables">string</span> is a the name of a stored procedure or the name of the application.</div> <div class="Body"><a name="444207">If a value is not specified for this option, the driver uses the PROGRAM value in the </a>V$SESSION table. </div> <div class="gutter_text_right"><a name="443483">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="443484">None</a></div> <div class="gutter_text_right"><a name="443414">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="469026">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="233420">Password</a></div> <div class="gutter_text_right"><a name="233421">Attribute</a></div> <div class="Body_attr"><a name="233423">Password (PWD)</a></div> <div class="gutter_text_right"><a name="262069">Description</a></div> <div class="Body"><a name="545015">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="262074">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="545019">pwd</a></span> </div> <div class="Body"><a name="545020">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="262347">Default</a></div> <div class="Body"><a name="262599">None</a></div> <div class="gutter_text_right"><a name="390127">GUI Tab</a></div> <div class="Body"><a name="390673">n/a</a></div> <div class="head_2_no_TOC"><a name="233501">Port Number</a></div> <div class="gutter_text_right"><a name="233502">Attribute</a></div> <div class="Body_attr"><a name="233504">PortNumber (PORT)</a></div> <div class="gutter_text_right"><a name="327793">Description</a></div> <div class="Body"><a name="545024">The port number of the server listener.</a></div> <div class="Body"><a name="327798">NOTE: This option is mutually exclusive with the Server Name and TNSNames File options.</a></div> <div class="gutter_text_right"><a name="309197">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="545028">port_name</a></span> </div> <div class="Body"><a name="545029">where the </a><span class="EquationVariables">port_name</span> is the port number of the server listener. Check with your database administrator for the correct number.</div> <div class="gutter_text_right"><a name="233505">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="233507">None</a></div> <div class="gutter_text_right"><a name="233522">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="309363">General tab</a></span></div> <div class="head_2_no_TOC"><a name="233663">Procedure Returns Results</a></div> <div class="gutter_text_right"><a name="233664">Attribute</a></div> <div class="Body_attr"><a name="233666">ProcedureRetResults (PRR)</a></div> <div class="gutter_text_right"><a name="233667">Description</a></div> <div class="Body"><a name="545033">Determines whether the driver returns result sets from stored procedures/functions.</a></div> <div class="Body"><a name="309458">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.12.html#110429', '');">â??Support of Materialized Viewsâ??</a></span> for details.</div> <div class="Body"><a name="309463">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="309378">Valid Values</a></div> <div class="Body"><a name="545037">0 | 1</a></div> <div class="Body"><a name="545038">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="545039">If set to 0 (Disabled), the driver does not return result sets from stored procedures.</a></div> <div class="gutter_text_right"><a name="309638">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="309639">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="233687">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="309647">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="439450">Program ID</a></div> <div class="gutter_text_right"><a name="439451">Attribute</a></div> <div class="Body_attr"><a name="439453">ProgramID (PID)</a></div> <div class="gutter_text_right"><a name="439454">Description</a></div> <div class="Body"><a name="452322">The product and version information of the driver on the client to be stored in the database. </a>This value sets the PROCESS value in the V$SESSION table on the server. This value is used by the client information feature.</div> <div class="Body"><a name="439455">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="444003">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="472379">string</a></span></div> <div class="Body"><a name="472380">where </a><span class="EquationVariables">string</span> is a value that identifies the product and version of the driver on the client.</div> <div class="Body"><a name="472381">If a value for this option is not specified, the driver uses the process ID of the session.</a></div> <div class="gutter_text_right"><a name="439474">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="439475">None</a></div> <div class="gutter_text_right"><a name="439476">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#514129', '');" name="439622">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="233870">Query Timeout</a></div> <div class="gutter_text_right"><a name="233871">Attribute</a></div> <div class="Body_attr"><a name="233873">QueryTimeout (QT)</a></div> <div class="gutter_text_right"><a name="263667">Description</a></div> <div class="Body"><a name="545043">The number of seconds for the default query timeout for all statements that are created by a </a>connection. To override the value set by this connection option for an individual statement, set a different value in the SQL_ATTR_QUERY_TIMEOUT statement attribute on the SQLSetStmtAttr() function.</div> <div class="gutter_text_right"><a name="263672">Valid Values</a></div> <div class="Body"><a name="545047">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="545048">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="545049">If set to -1, the query does not time out. The driver silently ignores the </a>SQL_ATTR_QUERY_TIMEOUT attribute.</div> <div class="Body"><a name="545050">If set to 0, the query does not time out, but the driver responds to the </a>SQL_ATTR_QUERY_TIMEOUT attribute.</div> <div class="Body"><a name="545051">If set to </a><span class="EquationVariables">x</span>, all queries time out after the specified number of seconds unless the application overrides this value by setting the SQL_ATTR_QUERY_TIMEOUT attribute.</div> <div class="gutter_text_right"><a name="263678">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="263680">0</a></div> <div class="gutter_text_right"><a name="263691">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="233892">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="521864">Record Delimiter</a></div> <div class="gutter_text_right"><a name="521865">Attribute</a></div> <div class="Body_attr"><a name="521866">BulkLoadRecordDelimiter (BLRD)</a></div> <div class="gutter_text_right"><a name="521867">Description</a></div> <div class="Body"><a name="545363">Specifies the character that the driver will use to delimit the record entries in a bulk load data </a>file.</div> <div class="gutter_text_right"><a name="521872">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="545367">x</a></span></div> <div class="Body"><a name="545368">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="545369">For simplicity, avoid using a value that can be in the data, including all alphanumeric </a>characters, the dash(-), the colon(:), the period (.), the forward slash (/), the space character, the single quote (') and the double quote ("). You can use some of these characters as delimiters if all of the data in the file is contained within double quotes.</div> <div class="Body"><a name="545370">NOTE: The Bulk Load Record Delimiter character must be different from the Bulk Load </a>Field Delimiter.</div> <div class="gutter_text_right"><a name="521880">Default</a></div> <div class="Body"><a name="521881">None</a></div> <div class="gutter_text_right"><a name="521882">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#109110', '');" name="521887">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="233961">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="233962">Attribute</a></div> <div class="Body_attr"><a name="233964">ReportCodepageConversionErrors (RCCE)</a></div> <div class="gutter_text_right"><a name="263705">Description</a></div> <div class="Body"><a name="545055">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="545056">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="284197">Valid Values</a></div> <div class="Body"><a name="545060">0 | 1 | 2</a></div> <div class="Body"><a name="545061">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="545062">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="545063">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="284202">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="263719">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="263762">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="233984">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="234165">Report Recycle Bin</a></div> <div class="gutter_text_right"><a name="234166">Attribute</a></div> <div class="Body_attr"><a name="234168">ReportRecycleBin (RRB)</a></div> <div class="gutter_text_right"><a name="234169">Description</a></div> <div class="Body"><a name="545067">Determines whether support is provided for reporting objects that are in the Oracle Recycle </a>Bin.</div> <div class="Body"><a name="545068">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="309877">Valid Values</a></div> <div class="Body"><a name="545072">0 | 1</a></div> <div class="Body"><a name="545073">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="545074">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="309898">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="309958">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="309959">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="309968">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="309969">Server Name</a></div> <div class="gutter_text_right"><a name="234365">Attribute</a></div> <div class="Body_attr"><a name="234367">ServerName (SRVR)</a></div> <div class="gutter_text_right"><a name="234368">Description</a></div> <div class="Body"><a name="310565">Specifies a net service name that exists in the TNSNAMES.ORA file. The corresponding net </a>service name entry in the TNSNAMES.ORA file is used to obtain Host, Port Number, and Service Name or SID information.</div> <div class="Body"><a name="310612">NOTE: This option is mutually exclusive with the Host, Port Number, SID, and Service </a>Name options.</div> <div class="gutter_text_right"><a name="310386">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="310597">server_name</a></span></div> <div class="Body"><a name="310702">where </a><span class="EquationVariables">server_name</span> is a net service name in the TNSNAMES.ORA file.</div> <div class="gutter_text_right"><a name="310348">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="234370">None</a></div> <div class="gutter_text_right"><a name="234382">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="310690">General tab</a></span></div> <div class="head_2_no_TOC"><a name="234465">Server Process Type</a></div> <div class="gutter_text_right"><a name="234466">Attribute</a></div> <div class="Body_attr"><a name="234468">ServerType (ST)</a></div> <div class="gutter_text_right"><a name="234469">Description</a></div> <div class="Body"><a name="261266">Determines whether the connection is established using a shared or dedicated server </a>process (dedicated thread on Windows).</div> <div class="Body"><a name="261991">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="261239">Valid Values</a></div> <div class="Body"><a name="261243">0 | 1 | 2</a></div> <div class="Body"><a name="261769">If set to 0 (Server Default), the driver uses the default server process set on the server.</a></div> <div class="Body"><a name="261770">NOTE: The server must be configured for shared connections (the SHARED_SERVERS </a>initialization parameter on the server has a value greater than 0) for the driver to be able to specify the shared server process type.</div> <div class="Body"><a name="261771">If set to 1 (Shared), the server process used is retrieved from a pool. The socket connection </a>between the application and server is made to a dispatcher process on the server. This setting allows there to be fewer processes than the number of connections, reducing the need for server resources. Use this value when a server must handle a large number of connections.</div> <div class="Body"><a name="261772">If set to 2 (Dedicated), a server process is created to service only that connection. When </a>that connection ends, so does the process (UNIX and Linux) or thread (Windows). The socket connection is made directly between the application and the dedicated server process or thread. When connecting to UNIX and Linux servers, a dedicated server process can provide significant performance improvement, but uses more resources on the server. When connecting to Windows servers, the server resource penalty is insignificant. Use this value if you have a batch environment with a low number of connections.</div> <div class="gutter_text_right"><a name="261224">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="234471">0 (Server Default)</a></div> <div class="gutter_text_right"><a name="234489">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="262029">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="234686">Service Name</a></div> <div class="gutter_text_right"><a name="234687">Attribute</a></div> <div class="Body_attr"><a name="234689">ServiceName (SN)</a></div> <div class="gutter_text_right"><a name="234690">Description</a></div> <div class="Body"><a name="315501">The Oracle service name that specifies the database used for the connection. The service </a>name is a string that is the global database nameâ??a name that is comprised of the database name and domain name, for example:</div> <div class="syntax_first"><a name="315502">sales.us.acme.com</a></div> <div class="Body"><a name="315503">The service name is included as part of the Oracle connect descriptor, which is a description </a>of the destination for a network connection. The service name is specified in the CONNECT_DATA parameter of the connect descriptor, for example:</div> <div class="syntax_first"><a name="315504">(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))</a></div> <div class="Body"><a name="315505">In this example, you would specify </a><span class="Syntax">sales.us.acme.com</span> as the value for the Service Name connection option.</div> <div class="Body"><a name="315854">This option is mutually exclusive with the SID, Server Name, and TNSNames File options.</a></div> <div class="gutter_text_right"><a name="315138">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="316217">service_name</a></span></div> <div class="Body"><a name="316218">where </a><span class="EquationVariables">service_name</span> is the description of the destination for a network connection. </div> <div class="gutter_text_right"><a name="316219">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="234692">None</a></div> <div class="gutter_text_right"><a name="234709">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="316201">General tab</a></span></div> <div class="head_2_no_TOC"><a name="234884">SID</a></div> <div class="gutter_text_right"><a name="234885">Attribute</a></div> <div class="Body_attr"><a name="234887">SID (SID)</a></div> <div class="gutter_text_right"><a name="234888">Description</a></div> <div class="Body"><a name="316280">The Oracle System Identifier that refers to the instance of Oracle running on the server.</a></div> <div class="Body"><a name="316281">NOTE: This option is mutually exclusive with the Service Name, Server Name, and </a>TNSNames File options.</div> <div class="gutter_text_right"><a name="316228">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="316332">sid</a></span></div> <div class="Body"><a name="316341">where </a><span class="EquationVariables">sid</span> is the name of the Oracle System Identifier.</div> <div class="gutter_text_right"><a name="316248">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="234890">None</a></div> <div class="gutter_text_right"><a name="234902">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="316379">General tab</a></span></div> <div class="head_2_no_TOC"><a name="235121">Timestamp Escape Mapping</a></div> <div class="gutter_text_right"><a name="235122">Attribute</a></div> <div class="Body_attr"><a name="235124">TimestampEscapeMapping (TEM)</a></div> <div class="gutter_text_right"><a name="235125">Description</a></div> <div class="Body"><a name="545078">Determines how the driver maps Date, Time, and Timestamp literals.</a></div> <div class="gutter_text_right"><a name="260006">Valid Values</a></div> <div class="Body"><a name="545082">0 | 1</a></div> <div class="Body"><a name="545083">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="545084">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="260541">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="260542">0 (Oracle Version Specific)</a></div> <div class="gutter_text_right"><a name="235143">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#116062', '');" name="261150">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="235281">TNSNames File</a></div> <div class="gutter_text_right"><a name="235282">Attribute</a></div> <div class="Body_attr"><a name="235284">TNSNamesFile (TNF)</a></div> <div class="gutter_text_right"><a name="259881">Description</a></div> <div class="Body"><a name="259978">Specifies the name of the TNSNAMES.ORA file. In a TNSNAMES.ORA file, connection </a>information for Oracle services is associated with an Oracle net service name. The entry in the TNSNAMES.ORA file specifies Host, Port Number, and Service Name or SID.</div> <div class="Body"><a name="259882">TNSNames File is ignored if no value is specified in the Server Name option. If the Server </a>Name option is specified but the TNSNames File option is left blank, the TNS_ADMIN environment setting is used for the TNSNAMES.ORA file path. If there is no TNS_ADMIN setting, the ORACLE_HOME environment setting is used. On Windows, if ORACLE_HOME is not set, the path is taken from the Oracle section of the Registry.</div> <div class="Body"><a name="259885">Using an Oracle TNSNAMES.ORA file to centralize connection information in your Oracle </a>environment simplifies maintenance when changes occur. If, however, the TNSNAMES.ORA file is unavailable, then it is useful to be able to open a backup version of the TNSNAMES.ORA file (TNSNames file failover). You can specify one or more backup, or alternate, TNSNAMES.ORA files.</div> <div class="gutter_text_right"><a name="235285"> </a></div> <div class="Body"><a name="316632">NOTE: This option is mutually exclusive with the Host, Port Number, SID, and Service </a>Name options.</div> <div class="gutter_text_right"><a name="259617">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="317239">path_filename</a></span></div> <div class="Body"><a name="317242">where </a><span class="EquationVariables">path_filename</span> is the entire path, including the file name, to the TNSNAMES.ORA file. </div> <div class="Body"><a name="317449">To specify multiple TNSNAMES.ORA file locations, separate the names with a comma and </a>enclose the locations in parentheses (you do not need parentheses for a single entry). For example:</div> <div class="syntax_first"><a name="317450">(F:\server2\oracle\tnsnames.ora, </a>C:\oracle\product\10.1\db_1\network\admin\tnsnames.ora)</div> <div class="Body"><a name="317750">The driver tries to open the first file in the list. If that file is not available, then it tries to open </a>the second file in the list, and so on.</div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#221689', '');" name="317756">â??Connection Retry Countâ??</a></span> and <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.04.html#221713', '');">â??Connection Retry Delayâ??</a></span> are also valid with TNSNames failover. The driver makes at least one attempt to open the files, and, if Connection Retry Count is enabled, more than one. If Connection Retry Delay is enabled, the driver waits the specified number of seconds between attempts. Load Balancing is not available for TNSNames failover.</div> <div class="gutter_text_right"><a name="317173">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="235287">None</a></div> <div class="gutter_text_right"><a name="235311">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108675', '');" name="317835">General tab</a></span></div> <div class="head_2_no_TOC"><a name="235564">Truststore</a></div> <div class="gutter_text_right"><a name="235565">Attribute</a></div> <div class="Body_attr"><a name="235567">Truststore (TS)</a></div> <div class="gutter_text_right"><a name="259502">Description</a></div> <div class="Body"><a name="545088">The directory that contains the truststore file and the truststore file name to be used when </a>SSL is enabled (Encryption Method=1) and server authentication is used. The truststore file contains a list of the valid Certificate Authorities (CAs) that are trusted by the client machine for SSL server authentication. If you do not specify a directory, the current directory is used.</div> <div class="Body"><a name="545089">NOTE: The truststore and keystore files may be the same file.</a></div> <div class="gutter_text_right"><a name="259508">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="545093">truststore_directory\filename</a></span> </div> <div class="Body"><a name="545094">where </a><span class="EquationVariables">truststore_directory</span> is the directory where the truststore file is located and <span class="EquationVariables">filename</span> is the file name of the truststore file.</div> <div class="gutter_text_right"><a name="259511">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="259512">None</a></div> <div class="gutter_text_right"><a name="235584">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="356761">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="235586">Truststore Password</a></div> <div class="gutter_text_right"><a name="235587">Attribute</a></div> <div class="Body_attr"><a name="235589">TruststorePassword (TSP)</a></div> <div class="gutter_text_right"><a name="259154">Description</a></div> <div class="Body"><a name="545098">The password that is used to access the truststore file when SSL is enabled (Encryption </a>Method=1) and server authentication is used. The truststore file contains a list of the Certificate Authorities (CAs) that the client trusts. </div> <div class="Body"><a name="545099">NOTE: The truststore and keystore files may be the same file; therefore, they may have the </a>same password.</div> <div class="gutter_text_right"><a name="259160">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="545103">truststore_password</a></span></div> <div class="Body"><a name="545104">where </a><span class="EquationVariables">truststore_password</span> is a valid password for the truststore file.</div> <div class="gutter_text_right"><a name="259163">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="259164">None</a></div> <div class="gutter_text_right"><a name="235605">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="356769">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="235768">Use Current Schema for SQLProcedures</a></div> <div class="gutter_text_right"><a name="235769">Attribute</a></div> <div class="Body_attr"><a name="235771">UseCurrentSchema (UCS)</a></div> <div class="gutter_text_right"><a name="235772">Description</a></div> <div class="Body"><a name="545108">Determines whether the driver returns only procedures owned by the current user when </a>executing SQLProcedures. </div> <div class="Body"><a name="259204">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="259199">Valid Values</a></div> <div class="Body"><a name="545112">0 | 1</a></div> <div class="Body"><a name="545113">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="545114">When set to 0 (Disabled), the driver does not specify only the current user.</a></div> <div class="gutter_text_right"><a name="259296">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="259297">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="235791">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="259215">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="232270">User Name</a></div> <div class="gutter_text_right"><a name="232271">Attribute</a></div> <div class="Body_attr"><a name="232273">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="232274">Description</a></div> <div class="Body"><a name="545118">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="259005">You can also use OS Authentication to connect to your Oracle database. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.10.html#382847', '');">â??OS Authenticationâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="258649">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="545122">userid</a></span></div> <div class="Body"><a name="545123">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="258800">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="232276">None</a></div> <div class="gutter_text_right"><a name="232293">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="258805">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="236355">Validate Server Certificate</a></div> <div class="gutter_text_right"><a name="236356">Attribute</a></div> <div class="Body_attr"><a name="236358">ValidateServerCertificate (VSC)</a></div> <div class="gutter_text_right"><a name="236359">Description</a></div> <div class="Body"><a name="545127">Determines whether the driver validates the certificate that is sent by the database server </a>when SSL encryption is enabled (Encryption Method=1). When using SSL server authentication, any certificate sent by the server must be issued by a trusted Certificate Authority (CA). Allowing the driver to trust any certificate returned from the server even if the issuer is not a trusted CA is useful in test environments because it eliminates the need to specify truststore information on each client in the test environment. </div> <div class="Body"><a name="545128">Truststore information is specified using the Trust Store and Trust Store Password options. </a></div> <div class="gutter_text_right"><a name="258441">Valid Values</a></div> <div class="Body"><a name="545132">0 | 1</a></div> <div class="Body"><a name="545133">If set to 1 (Enabled), the driver validates the certificate that is sent by the database server. </a>Any certificate from the server must be issued by a trusted CA in the truststore file. If the Host Name In Certificate option is specified, the driver also validates the certificate using a host name. The Host Name In Certificate option provides additional security against man-in-the-middle (MITM) attacks by ensuring that the server the driver is connecting to is the server that was requested. </div> <div class="Body"><a name="545135">If set to 0 (Disabled), the driver does not validate the certificate that is sent by the database </a>server. The driver ignores any truststore information specified by the Trust Store and Trust Store Password options. </div> <div class="gutter_text_right"><a name="258602">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="258603">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="236374">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#131240', '');" name="258622">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="236272">Wire Protocol Mode</a></div> <div class="gutter_text_right"><a name="236273">Attribute</a></div> <div class="Body_attr"><a name="236274">WireProtocolMode (WPM)</a></div> <div class="gutter_text_right"><a name="236275">Description</a></div> <div class="Body"><a name="258052">Specifies whether the driver optimizes network traffic to the Oracle server.</a></div> <div class="Body"><a name="258341">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.05.html#109979', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="258053">Valid Values</a></div> <div class="Body"><a name="258054">1 | 2</a></div> <div class="Body"><a name="258179">If set to 1, the driver operates in normal wire protocol mode without optimizing network </a>traffic.</div> <div class="Body"><a name="258180">If set to 2, the driver optimizes network traffic to the Oracle server for result sets that contain </a>repeating data in some or all of the columns, and the repeating data is in consecutive rows. It also optimizes network traffic if the application is updating or inserting images, pictures, or long text or binary data.</div> <div class="gutter_text_right"><a name="257803">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="236276">2</a></div> <div class="gutter_text_right"><a name="236292">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclewp.12.03.html#108960', '');" name="258391">Performance 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