Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\progopenedgewp.14.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/progopenedgewp.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="progopenedgewp.14.01.html#610339">10 The Progress OpenEdge® Wire Protocol Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="610339">Connection Option Descriptions</a></div> <div class="Body"><a name="703037">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="703038">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="703039">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', 'progopenedgewp.14.04.html#638165', '');" name="610353">Table 10-1</a></span> lists the connection string attributes supported by the Progress OpenEdge Wire Protocol driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 10-1. <a name="638165">Progress OpenEdge Wire Protocol Attribute Names</a> </div> </caption> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="638169">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="638171">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', 'progopenedgewp.14.04.html#610866', '');" name="638176">AlternateServers (ASVR)</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="638178">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', 'progopenedgewp.14.04.html#661964', '');" name="638183">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="638185">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', 'progopenedgewp.14.04.html#611264', '');" name="638190">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="638192">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', 'progopenedgewp.14.04.html#611293', '');" name="638197">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="638199">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" 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', 'progopenedgewp.14.04.html#611368', '');" name="638211">Database (DB)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="638213">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', 'progopenedgewp.14.04.html#611341', '');" name="638218">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="638220">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', 'progopenedgewp.14.04.html#611395', '');" name="638225">DefaultIsolationLevel (DIL)</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="638227">1- READ COMMITTED</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', 'progopenedgewp.14.04.html#611448', '');" name="638232">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="638234">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', 'progopenedgewp.14.04.html#629112', '');" name="638239">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="638241">1 (enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.04.html#629253', '');" name="638246">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="638248">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" 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', 'progopenedgewp.14.04.html#611557', '');" name="638253">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="638255">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" 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', 'progopenedgewp.14.04.html#611588', '');" name="638260">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="638262">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" 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', 'progopenedgewp.14.04.html#611621', '');" name="638267">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="638269">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', 'progopenedgewp.14.04.html#661961', '');" name="689630">Fetch Array Size</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="689632">50</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', 'progopenedgewp.14.04.html#630588', '');" name="638274">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="638276">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', 'progopenedgewp.14.04.html#611723', '');" name="638281">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="638283">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', 'progopenedgewp.14.04.html#611759', '');" name="638288">IANAAppCodePage (IACP)</a></span> 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="638290">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" 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', 'progopenedgewp.14.04.html#638656', '');" name="638779">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="638817">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', 'progopenedgewp.14.04.html#611991', '');" name="638295">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="638297">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" 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', 'progopenedgewp.14.04.html#612444', '');" name="638302">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="638304">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', 'progopenedgewp.14.04.html#612232', '');" name="638323">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="638325">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', 'progopenedgewp.14.04.html#634682', '');" name="638330">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="638332">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', 'progopenedgewp.14.04.html#612288', '');" name="638337">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="638392">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', 'progopenedgewp.14.04.html#612371', '');" name="638358">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="638360">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', 'progopenedgewp.14.04.html#612397', '');" name="638365">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="638367">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', 'progopenedgewp.14.04.html#636179', '');" name="638372">UseWideCharacterTypes (UWCT)</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="638374">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', 'progopenedgewp.14.04.html#612470', '');" name="638379">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="638381">1 (enabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="610863">Alternate Servers</a></div> <div class="gutter_text_right"><a name="610864">Attribute</a></div> <div class="Body_attr"><a name="610866">AlternateServers (ASVR)</a></div> <div class="gutter_text_right"><a name="610867">Description</a></div> <div class="Body"><a name="703043">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="610872">Valid Values</a></div> <div class="syntax_first"><span style="font-size: 9.0pt;"><a name="661198">(</a></span>HostName=<span class="EquationVariables">hostvalue</span>:PortNumber=<span class="EquationVariables">portvalue</span>:Database<span class="EquationVariables">=databasevalue</span>[, . . .])</div> <div class="Body"><a name="661208">You must specify the host name, port number, and database name of each alternate server.</a></div> <div class="Body"><a name="703047">NOTE: An alternate server address in IPv6 format must be enclosed in double quotation </a>marks.</div> <div class="gutter_text_right"><a name="610879">Example</a></div> <div class="Body"><a name="610880">The following Alternate Servers values define two alternate database servers for connection </a>failover:</div> <div class="syntax_first"><a name="610881">AlternateServers=(HostName=123.456.78.90:PortNumber=5177:Database=PAYROLL1,</a><br />HostName=223.456.78.90:PortNumber=5178:Database=PAYROLL2)</div> <div class="gutter_text_right"><a name="610884">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="610885">None</a></div> <div class="gutter_text_right"><a name="661069">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#676957', '');" name="661074">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="611261">Connection Retry Count</a></div> <div class="gutter_text_right"><a name="611262">Attribute</a></div> <div class="Body_attr"><a name="611264">ConnectionRetryCount (CRC)</a></div> <div class="gutter_text_right"><a name="611265">Description</a></div> <div class="Body"><a name="703095">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="703096">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="611271">Valid Values</a></div> <div class="Body"><a name="703100">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="703101">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="703102">If set to 0, the driver does not try to connect after the initial unsuccessful attempt.</a></div> <div class="Body"><a name="703103">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="611279">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611281">0</a></div> <div class="gutter_text_right"><a name="611282">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#676957', '');" name="611287">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="611290">Connection Retry Delay</a></div> <div class="gutter_text_right"><a name="611291">Attribute</a></div> <div class="Body_attr"><a name="611293">ConnectionRetryDelay (CRD)</a></div> <div class="gutter_text_right"><a name="611294">Description</a></div> <div class="Body"><a name="703107">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="703108">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="611300">Valid Values</a></div> <div class="Body"><a name="703112">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="703113">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="703114">If set to 0, there is no delay between retries.</a></div> <div class="Body"><a name="703115">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="611308">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611310">3</a></div> <div class="gutter_text_right"><a name="611311">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#676957', '');" name="611316">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="611338">Data Source Name</a></div> <div class="gutter_text_right"><a name="611339">Attribute</a></div> <div class="Body_attr"><a name="611341">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="611342">Description</a></div> <div class="Body"><a name="703119">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="611347">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="703123">string</a></span> </div> <div class="Body"><a name="703124">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="611353">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611355">None</a></div> <div class="gutter_text_right"><a name="611356">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609524', '');" name="611361">General tab</a></span></div> <div class="head_2_no_TOC"><a name="611365">Database Name</a></div> <div class="gutter_text_right"><a name="611366">Attribute</a></div> <div class="Body_attr"><a name="611368">Database (DB)</a></div> <div class="gutter_text_right"><a name="611369">Description</a></div> <div class="Body"><a name="703003">The name of the database to which you want to connect.</a></div> <div class="gutter_text_right"><a name="662588">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="703128">database_name</a></span> </div> <div class="Body"><a name="703129">where </a><span class="EquationVariables">database_name</span> is the name of a valid database.</div> <div class="gutter_text_right"><a name="611382">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611383">None</a></div> <div class="gutter_text_right"><a name="611384">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609524', '');" name="611389">General tab</a></span></div> <div class="head_2_no_TOC"><a name="611392">Default Isolation Level</a></div> <div class="gutter_text_right"><a name="611393">Attribute</a></div> <div class="Body_attr"><a name="611395">DefaultIsolationLevel (DIL)</a></div> <div class="gutter_text_right"><a name="611396">Description</a></div> <div class="Body"><a name="611397">The method by which locks on data in the database are acquired and released.</a></div> <div class="gutter_text_right"><a name="611428">Valid Values</a></div> <div class="Body"><a name="688925">0 | 1 | 2 | 3 </a></div> <div class="Body"><a name="688926">If set to 0 (READ_UNCOMMITTED), other processes can be read from the database. Only </a>modified data is locked and is not released until the transaction ends.</div> <div class="Body"><a name="688927">If set to 1 (READ_COMMITTED) other processes can change a row that your application </a>has read if the cursor is not on the row you want to change. This level prevents other processes from changing records that your application has changed until your application commits them or ends the transaction. </div> <div class="Body"><a name="689176">If set to 2 (REPEATABLE_READ), other processes are prevented from accessing data that </a>your application has read or modified. All read or modified data is locked until transaction ends.</div> <div class="Body"><a name="689177">If set to 3 (SERIALIZABLE), other processes are prevented from changing records that are </a>read or changed by your application (including phantom records) until your program commits them or ends the transaction. This level prevents the application from reading modified records that have not been committed by another process. If your application opens the same query during a single unit of work under this isolation level, the results table will be identical to the previous table; however, it can contain updates made by your application.</div> <div class="Body"><a name="665346">Refer to </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'lock.09.1.html#106144', '');">Chapter 7 â??Locking and Isolation Levelsâ??</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;"> </span><span class="Emphasis" style="font-size: 10.0pt;">Reference</span> for details about ODBC isolation levels.</div> <div class="gutter_text_right"><a name="664563">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="664565">1 - READ COMMITTED</a></div> <div class="gutter_text_right"><a name="664566">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609601', '');" name="611443">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="611445">Description</a></div> <div class="gutter_text_right"><a name="611446">Attribute</a></div> <div class="Body_attr"><a name="611448">Description (n/a)</a></div> <div class="gutter_text_right"><a name="611449">Description</a></div> <div class="Body"><a name="703133">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="611454">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="703137">string</a></span> </div> <div class="Body"><a name="703138">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="611460">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611461">None</a></div> <div class="gutter_text_right"><a name="611462">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609524', '');" name="611467">General tab</a></span></div> <div class="head_2_no_TOC"><a name="629109">Enable Timestamp with Timezone</a></div> <div class="gutter_text_right"><a name="629110">Attribute</a></div> <div class="Body_attr"><a name="629112">EnableTimestampwithTimezone (ETWT)</a></div> <div class="gutter_text_right"><a name="629113">Description</a></div> <div class="Body"><a name="703051">Determines whether the driver exposes timestamps with timezones to the application. </a></div> <div class="gutter_text_right"><a name="629118">Valid Values</a></div> <div class="Body"><a name="629121">0 | 1</a></div> <div class="Body"><a name="629122">If set to 1 (Enabled), the driver exposes timestamps with timezones to the application. </a></div> <div class="Body"><a name="629123">If set to 0 (Disabled), timestamps with timezones are not exposed to the application.</a></div> <div class="gutter_text_right"><a name="629125">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="629126">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="629127">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609601', '');" name="629132">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="629250">Encryption Method</a></div> <div class="gutter_text_right"><a name="629251">Attribute</a></div> <div class="Body_attr"><a name="629253">EncryptionMethod (EM)</a></div> <div class="gutter_text_right"><a name="629254">Description</a></div> <div class="Body"><a name="703055">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="629259">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.05.html#606884', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="629263">Valid Values</a></div> <div class="Body"><a name="629264">0 | 1</a></div> <div class="Body"><a name="703059">If set to 0 (No Encryption), data is not encrypted.</a></div> <div class="Body"><a name="703060">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="gutter_text_right"><a name="629272">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="629274">0 (No Encryption)</a></div> <div class="gutter_text_right"><a name="629275">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609778', '');" name="629280">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="611554">Failover Granularity</a></div> <div class="gutter_text_right"><a name="611555">Attribute</a></div> <div class="Body_attr"><a name="611557">FailoverGranularity (FG)</a></div> <div class="gutter_text_right"><a name="611558">Description</a></div> <div class="Body"><a name="703142">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="703143">This option applies only when Failover Mode is set to 1 (Extended Connection) or 2 </a>(Select). </div> <div class="Body"><a name="703144">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="611565">Valid Values</a></div> <div class="Body"><a name="703148">0 | 1 | 2 | 3</a></div> <div class="Body"><a name="703149">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="703150">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="703151">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="703152">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="611574">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611576">0 (Non-Atomic)</a></div> <div class="gutter_text_right"><a name="611577">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#676957', '');" name="611582">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="611585">Failover Mode</a></div> <div class="gutter_text_right"><a name="611586">Attribute</a></div> <div class="Body_attr"><a name="611588">FailoverMode (FM)</a></div> <div class="gutter_text_right"><a name="611589">Description</a></div> <div class="Body"><a name="703156">Specifies the type of failover method the driver uses. </a></div> <div class="Body"><a name="703157">The Alternate Servers option specifies one or multiple alternate servers for failover and is </a>required for all failover methods.</div> <div class="Body"><a name="611595">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.05.html#606884', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="611599">Valid Values</a></div> <div class="Body"><a name="703161">0 | 1 | 2</a></div> <div class="Body"><a name="703162">If set to 0 (Connection), the driver provides failover protection for new connections only. </a></div> <div class="Body"><a name="703163">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="703164">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="611607">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611609">0 (Connection)</a></div> <div class="gutter_text_right"><a name="611610">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#676957', '');" name="611615">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="611618">Failover Preconnect</a></div> <div class="gutter_text_right"><a name="611619">Attribute</a></div> <div class="Body_attr"><a name="611621">FailoverPreconnect (FP)</a></div> <div class="gutter_text_right"><a name="611622">Description</a></div> <div class="Body"><a name="703168">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="703169">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="703170">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="611629">Valid Values</a></div> <div class="Body"><a name="703174">0 | 1</a></div> <div class="Body"><a name="703175">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="703176">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="611636">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611638">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="611639">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#676957', '');" name="611644">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="661961">Fetch Array Size</a></div> <div class="gutter_text_right"><a name="661962">Attribute</a></div> <div class="Body_attr"><a name="661964">ArraySize (AS)</a></div> <div class="gutter_text_right"><a name="661965">Description</a></div> <div class="Body"><a name="665162">The number of rows the driver retrieves from the server for a fetch. This is not the number of </a>rows given to the user.</div> <div class="Body"><a name="661970">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.05.html#606884', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="661974">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="665166">x</a></span></div> <div class="Body"><a name="665167">where </a><span class="EquationVariables">x</span> is a positive integer specifying the number of bytes.</div> <div class="gutter_text_right"><a name="665168">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="665169">50</a></div> <div class="gutter_text_right"><a name="661982">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609601', '');" name="670780">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="630585">Host Name</a></div> <div class="gutter_text_right"><a name="630586">Attribute</a></div> <div class="Body_attr"><a name="630588">HostName (HOST)</a></div> <div class="gutter_text_right"><a name="630589">Description</a></div> <div class="Body"><a name="703064">The name or the IP address of the server to which you want to connect.</a></div> <div class="gutter_text_right"><a name="630594">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="703068">server_name</a></span> | <span class="EquationVariables">IP_address</span></div> <div class="Body"><a name="703069">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="703070">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="703071">IP_address</a></span> is the IP address of the server to which you want to connect.</div> <div class="Body"><a name="670176">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="gutter_text_right"><a name="630605">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="630606">None</a></div> <div class="gutter_text_right"><a name="630607">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609524', '');" name="630612">General tab</a></span></div> <div class="head_2_no_TOC"><a name="611720">Host Name In Certificate</a></div> <div class="gutter_text_right"><a name="611721">Attribute</a></div> <div class="Body_attr"><a name="611723">HostNameInCertificate (HNIC)</a></div> <div class="gutter_text_right"><a name="611724">Description</a></div> <div class="Body"><a name="703180">A host name for certificate validation when SSL encryption is enabled (Encryption </a>Method=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="611729">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="703184">host_name | #SERVERNAME#</a></span> </div> <div class="Body"><a name="703185">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="703186">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="703187">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="703188">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="611738">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611739">None</a></div> <div class="gutter_text_right"><a name="611740">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609778', '');" name="699384">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="699394">IANA</a><span style="font-size: 11.0pt; font-weight: normal;"><img class="icon" src="images/progopenedgewp.14.04.1.gif" width="30" height="33" style="display: block; left: 0.0; top: 0.0;" alt="UNIX icon" /></span>AppCodePage</div> <div class="gutter_text_right"><a name="699395">Attribute</a></div> <div class="Body_attr"><a name="611759">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="611760">Description</a></div> <div class="Body"><a name="702961">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="702969">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="702970">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="702971">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="702972">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="702973">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="702974">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="611778">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="702978">IANA_code_page</a></span> </div> <div class="Body"><a name="702980">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="611788">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="611790">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="611791">GUI Tab</a></div> <div class="Body"><a name="611796">N/A</a></div> <div class="head_2_no_TOC"><a name="638653">Load Balancing</a></div> <div class="gutter_text_right"><a name="638654">Attribute</a></div> <div class="Body_attr"><a name="638656">LoadBalancing (LB)</a></div> <div class="gutter_text_right"><a name="638657">Description</a></div> <div class="Body"><a name="703084">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="638662">Valid Values</a></div> <div class="Body"><a name="703088">0 | 1</a></div> <div class="Body"><a name="703089">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="703090">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="703091">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="638670">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="638672">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="638673">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#676957', '');" name="638678">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="611988">Login Timeout</a></div> <div class="gutter_text_right"><a name="611989">Attribute</a></div> <div class="Body_attr"><a name="611991">LoginTimeout (LT)</a></div> <div class="gutter_text_right"><a name="611992">Description</a></div> <div class="Body"><a name="703192">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="611997">Valid Values</a></div> <div class="Body"><a name="703196">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="703197">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="703198">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="703199">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="703200">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="612006">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="612008">15</a></div> <div class="gutter_text_right"><a name="612009">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609601', '');" name="612014">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="612229">Password</a></div> <div class="gutter_text_right"><a name="612230">Attribute</a></div> <div class="Body_attr"><a name="612232">Password (PWD)</a></div> <div class="gutter_text_right"><a name="612233">Description</a></div> <div class="Body"><a name="703204">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="612238">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="703208">pwd</a></span> </div> <div class="Body"><a name="703209">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="612244">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="612245">None</a></div> <div class="gutter_text_right"><a name="612246">GUI Tab</a></div> <div class="Body"><a name="612248">n/a</a></div> <div class="head_2_no_TOC"><a name="634679">Port Number</a></div> <div class="gutter_text_right"><a name="634680">Attribute</a></div> <div class="Body_attr"><a name="634682">PortNumber (PORT)</a></div> <div class="gutter_text_right"><a name="634683">Description</a></div> <div class="Body"><a name="703075">The port number of the server listener.</a></div> <div class="gutter_text_right"><a name="634689">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="703079">port_name</a></span> </div> <div class="Body"><a name="703080">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="634695">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="634696">None</a></div> <div class="gutter_text_right"><a name="634697">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609524', '');" name="634702">General tab</a></span></div> <div class="head_2_no_TOC"><a name="612285">Query Timeout</a></div> <div class="gutter_text_right"><a name="612286">Attribute</a></div> <div class="Body_attr"><a name="612288">QueryTimeout (QT)</a></div> <div class="gutter_text_right"><a name="612289">Description</a></div> <div class="Body"><a name="703213">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="612294">Valid Values</a></div> <div class="Body"><a name="703217">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="703218">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="703219">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="703220">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="703221">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="612304">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="612306">0</a></div> <div class="gutter_text_right"><a name="612307">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609601', '');" name="612312">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="612368">Truststore</a></div> <div class="gutter_text_right"><a name="612369">Attribute</a></div> <div class="Body_attr"><a name="612371">Truststore (TS)</a></div> <div class="gutter_text_right"><a name="612372">Description</a></div> <div class="Body"><a name="703225">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="703226">NOTE: The truststore and keystore files may be the same file.</a></div> <div class="gutter_text_right"><a name="612378">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="703230">truststore_directory\filename</a></span> </div> <div class="Body"><a name="703231">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="612384">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="612385">None</a></div> <div class="gutter_text_right"><a name="612386">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609778', '');" name="612391">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="612394">Truststore Password</a></div> <div class="gutter_text_right"><a name="612395">Attribute</a></div> <div class="Body_attr"><a name="612397">TruststorePassword (TSP)</a></div> <div class="gutter_text_right"><a name="612398">Description</a></div> <div class="Body"><a name="703235">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="703236">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="612404">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="703240">truststore_password</a></span></div> <div class="Body"><a name="703241">where </a><span class="EquationVariables">truststore_password</span> is a valid password for the truststore file.</div> <div class="gutter_text_right"><a name="612410">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="612411">None</a></div> <div class="gutter_text_right"><a name="612412">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609778', '');" name="612417">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="636069">Use Wide Character Types</a></div> <div class="gutter_text_right"><a name="636177">Attribute</a></div> <div class="Body_attr"><a name="636179">UseWideCharacterTypes (UWCT)</a></div> <div class="gutter_text_right"><a name="636437">Description</a></div> <div class="Body"><a name="636440">A value that determines whether character data types are described to the application as </a>SQL_CHAR or SQL_WCHAR when connected to a Unicode database.</div> <div class="gutter_text_right"><a name="636442">Valid Values</a></div> <div class="Body"><a name="636791">0 | 1</a></div> <div class="Body"><a name="636809">If set to 0 (Disabled), character data types are described to the application as SQL_CHAR.</a></div> <div class="Body"><a name="636853">If set to 1 (Enabled), character data types are described to the application as </a>SQL_WCHAR.</div> <div class="gutter_text_right"><a name="665234">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="665235">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="665236">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609601', '');" name="636455">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="612441">User ID</a></div> <div class="gutter_text_right"><a name="612442">Attribute</a></div> <div class="Body_attr"><a name="612444">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="612445">Description</a></div> <div class="Body"><a name="703245">The default user ID that is used to connect to your database. Your ODBC application may </a>override this value or you may override it in the logon dialog box or connection string.</div> <div class="gutter_text_right"><a name="612450">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="703249">userid</a></span></div> <div class="Body"><a name="703250">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="612456">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="612457">None</a></div> <div class="gutter_text_right"><a name="612458">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609524', '');" name="612463">General tab</a></span></div> <div class="head_2_no_TOC"><a name="612467">Validate Server Certificate</a></div> <div class="gutter_text_right"><a name="612468">Attribute</a></div> <div class="Body_attr"><a name="612470">ValidateServerCertificate (VSC)</a></div> <div class="gutter_text_right"><a name="612471">Description</a></div> <div class="Body"><a name="703254">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="703255">Truststore information is specified using the Trust Store and Trust Store Password options. </a></div> <div class="gutter_text_right"><a name="612477">Valid Values</a></div> <div class="Body"><a name="703259">0 | 1</a></div> <div class="Body"><a name="703260">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="703262">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="612485">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="612487">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="612488">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'progopenedgewp.14.03.html#609778', '');" name="612493">Security 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