Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\sybase.16.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/sybase.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="sybase.16.01.html#113104">12 The Sybase Wire Protocol Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="113104">Connection Option Descriptions</a></div> <div class="Body"><a name="352334">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="352335">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="352336">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', 'sybase.16.04.html#224289', '');" name="224279">Table 12-1</a></span> lists the connection string attributes supported by the Sybase Wire Protocol driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 12-1. <a name="224289">Sybase 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="224293">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="224295">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', 'sybase.16.04.html#113112', '');" name="239968">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="239970">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', 'sybase.16.04.html#180287', '');" name="239961">ApplicationName (APP)</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="239963">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', 'sybase.16.04.html#113137', '');" name="239954">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="239956">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', 'sybase.16.04.html#113408', '');" name="239975">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="239977">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.04.html#113158', '');" name="239982">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="239984">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', 'sybase.16.04.html#145552', '');" name="239996">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="239998">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', 'sybase.16.04.html#145579', '');" name="239989">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="239991">-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', 'sybase.16.04.html#145531', '');" name="240003">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="240005">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', 'sybase.16.04.html#310086', '');" name="311091">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="311093">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', 'sybase.16.04.html#310209', '');" name="311098">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="311100">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', 'sybase.16.04.html#113179', '');" name="240031">Charset (CS)</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="240033">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', 'sybase.16.04.html#145883', '');" name="240024">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="240026">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', 'sybase.16.04.html#127725', '');" name="240017">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="240019">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', 'sybase.16.04.html#113215', '');" name="240010">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="240012">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', 'sybase.16.04.html#151161', '');" name="265943">CursorCacheSize (CCS)</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="265945">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', 'sybase.16.04.html#113287', '');" name="240045">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="240047">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', 'sybase.16.04.html#122160', '');" name="303453">Database List</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="303455">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', 'sybase.16.04.html#113253', '');" name="240038">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="240040">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', 'sybase.16.04.html#113317', '');" name="240052">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="240054">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', 'sybase.16.04.html#136425', '');" name="240059">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="240061">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', 'sybase.16.04.html#113339', '');" name="240080">DistributedTransactionModel (DTM)</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="240082">0 (XA Protocol)</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', 'sybase.16.04.html#146132', '');" name="240073">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="240075">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', 'sybase.16.04.html#113353', '');" name="240066">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="240068">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', 'sybase.16.04.html#113367', '');" name="240290">EnableQuotedIdentifiers (EQI)</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="240292">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', 'sybase.16.04.html#113385', '');" name="240283">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="240285">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', 'sybase.16.04.html#144852', '');" name="240276">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="240278">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', 'sybase.16.04.html#144882', '');" name="240269">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="240271">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', 'sybase.16.04.html#113446', '');" name="240262">FailoverNetworkAddress (FNA)</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="240264">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', 'sybase.16.04.html#144910', '');" name="240255">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="240257">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', 'sybase.16.04.html#291964', '');" name="293309">FetchTWFSasTime (FTWFSAT)</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="293311">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', 'sybase.16.04.html#113426', '');" name="240248">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="240250">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', 'sybase.16.04.html#113463', '');" name="240241">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="240243">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', 'sybase.16.04.html#113487', '');" name="240234">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="240236">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', 'sybase.16.04.html#113518', '');" name="240227">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="240229">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', 'sybase.16.04.html#113535', '');" name="240220">InterfacesFile (IF)</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="240222">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', 'sybase.16.04.html#113703', '');" name="240213">InterfacesFileServerName (IFSN)</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="240215">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', 'sybase.16.04.html#113551', '');" name="240185">Language (LANG)</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="240187">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', 'sybase.16.04.html#146505', '');" name="240178">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="240180">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', 'sybase.16.04.html#146533', '');" name="240171">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="240173">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', 'sybase.16.04.html#146668', '');" name="240164">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="240166">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', 'sybase.16.04.html#113803', '');" name="240157">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="240159">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', 'sybase.16.04.html#146830', '');" name="240136">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="240138">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', 'sybase.16.04.html#146855', '');" name="240129">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="240131">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', 'sybase.16.04.html#113586', '');" name="240122">NetworkAddress (NA)</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="240124">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', 'sybase.16.04.html#113646', '');" name="240115">OptimizePrepare (OP)</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="240117">1 (Partial)</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', 'sybase.16.04.html#113607', '');" name="240108">PacketSize (PS)</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="240110">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', 'sybase.16.04.html#113631', '');" name="240101">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="240103">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', 'sybase.16.04.html#145858', '');" name="240094">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="240096">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', 'sybase.16.04.html#147060', '');" name="240087">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="240089">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', 'sybase.16.04.html#113234', '');" name="240297">RaiseErrorPositionBehavior (REPB)</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="240299">0 (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', 'sybase.16.04.html#113665', '');" name="240367">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="240369">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', 'sybase.16.04.html#113686', '');" name="240360">SelectMethod (SM)</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="240362">0 (Cursor)</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', 'sybase.16.04.html#113719', '');" name="240353">ServicePrincipalName (SPN)</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="240355">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', 'sybase.16.04.html#113736', '');" name="240346">TightlyCoupledDistributedTransactions (TCDT)</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="240348">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', 'sybase.16.04.html#113752', '');" name="240339">TruncateTimeTypeFractions (TTTF)</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="240341">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', 'sybase.16.04.html#113767', '');" name="240332">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="240334">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', 'sybase.16.04.html#113785', '');" name="240325">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="240327">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', 'sybase.16.04.html#113817', '');" name="240318">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="240320">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', 'sybase.16.04.html#113838', '');" name="240311">WorkstationID (WKID)</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="240313">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', 'sybase.16.04.html#113853', '');" name="240304">XAOpenStringParameters (XAOSP)</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="240306">None</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="113110">Alternate Servers</a></div> <div class="gutter_text_right"><a name="113111">Attribute</a></div> <div class="Body_attr"><a name="113112">AlternateServers (ASRV)</a></div> <div class="gutter_text_right"><a name="121873">Description</a></div> <div class="Body"><a name="352439">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="127913">Valid Values</a></div> <div class="syntax_first"><a name="230136">({NetworkAddress=</a><span class="EquationVariables">addressvalue</span> | InterfacesFileServerName=<span class="EquationVariables">sectionvalue</span>}[, ...])</div> <div class="Body"><a name="230141">NetworkAddress and InterfacesFileServerName can be used in the same string.</a></div> <div class="Body"><a name="352465">NOTE: An alternate server address in IPv6 format must be enclosed in double quotation </a>marks.</div> <div class="Body"><a name="113117">You must specify the network address of each alternate database server or the section in </a>the Interfaces file that contains the network connection information for the Sybase database server you want to access (InterfacesFileServerName).</div> <div class="Body"><a name="230040">NOTE: The Alternate Servers option and the HA Failover Server Connection Information </a>option are mutually exclusive.</div> <div class="gutter_text_right"><a name="230041">Example</a></div> <div class="Body"><a name="230042">The following example Alternate Servers values define three alternate database servers for </a>connection failover:</div> <div class="syntax_first"><a name="128695">(InterfacesFileServerName=Accounting, NetworkAddress="255.125.1.11, 4200", </a>NetworkAddress="SybaseASE2, 4200")</div> <div class="Body"><a name="128696">In this example, the network address of the last two alternates contain commas. In this </a>case, enclose the network address with double quotation marks as shown.</div> <div class="gutter_text_right"><a name="113125">Default</a></div> <div class="Body"><a name="113126">None</a></div> <div class="gutter_text_right"><a name="121906">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="121910">Failover tab</a></span> </div> <div class="head_2_no_TOC"><a name="180101">Application Name</a></div> <div class="gutter_text_right"><a name="180286">Attribute</a></div> <div class="Body_attr"><a name="180287">ApplicationName (APP)</a></div> <div class="gutter_text_right"><a name="180288">Description</a></div> <div class="Body"><a name="180106">The name used by Sybase to identify your application. </a></div> <div class="gutter_text_right"><a name="180108">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="180429">string</a></span></div> <div class="Body"><a name="180430">where </a><span class="EquationVariables">string</span> is a valid application name.</div> <div class="gutter_text_right"><a name="180115">Default</a></div> <div class="Body"><a name="180116">None</a></div> <div class="gutter_text_right"><a name="180117">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106547', '');" name="188238">Connection tab</a></span> </div> <div class="head_2_no_TOC"><a name="121911">Application Using Threads</a></div> <div class="gutter_text_right"><a name="113136">Attribute</a></div> <div class="Body_attr"><a name="113137">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="121862">Description</a></div> <div class="Body"><a name="352443">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="154065">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="142828">Valid Values</a></div> <div class="Body"><a name="352579">0 | 1</a></div> <div class="Body"><a name="352580">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="352581">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="142835">Default</a></div> <div class="Body"><a name="142837">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="113155">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="118891">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="113156">Authentication Method</a></div> <div class="gutter_text_right"><a name="113157">Attribute</a></div> <div class="Body_attr"><a name="113158">AuthenticationMethod (AM)</a></div> <div class="gutter_text_right"><a name="120172">Description</a></div> <div class="Body"><a name="352447">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="118905">Valid Values</a></div> <div class="Body"><a name="118906">0 | 1 | 4</a></div> <div class="Body"><a name="352340">If set to 0 (No Encryption), the driver sends the user ID and password in clear text to the </a>server for authentication.</div> <div class="Body"><a name="352344">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="352358">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="135365">If the specified authentication method is not supported by the database server, the </a>connection fails and the driver generates an error.</div> <div class="gutter_text_right"><a name="133904">Default</a></div> <div class="Body"><a name="133906">0 (No Encryption)</a></div> <div class="gutter_text_right"><a name="113176">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="120577">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="145528">Batch Size</a></div> <div class="gutter_text_right"><a name="145529">Attribute</a></div> <div class="Body_attr"><a name="145531">BulkLoadBatchSize (BLBS)</a></div> <div class="gutter_text_right"><a name="145532">Description</a></div> <div class="Body"><a name="352568">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="Body"><a name="163353">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="145537">Valid Values</a></div> <div class="Body"><a name="145538">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="145539">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="145540">Default</a></div> <div class="Body"><a name="145541">1024</a></div> <div class="gutter_text_right"><a name="145542">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109199', '');" name="145547">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="145549">Bulk Binary Threshold</a></div> <div class="gutter_text_right"><a name="145550">Attribute</a></div> <div class="Body_attr"><a name="145552">BulkBinaryThreshold (BBT)</a></div> <div class="gutter_text_right"><a name="145553">Description</a></div> <div class="Body"><a name="352654">The maximum size, in KB, of binary data that is exported to the bulk data file. </a></div> <div class="Body"><a name="163364">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="145558">Valid Values</a></div> <div class="Body"><a name="352658">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352659">where </a><span class="EquationVariables">x</span> is an integer that specifies the number of KB.</div> <div class="Body"><a name="352660">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="352661">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="352662">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="145567">Default</a></div> <div class="Body"><a name="145568">32</a></div> <div class="gutter_text_right"><a name="145569">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109199', '');" name="145574">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="145576">Bulk Character Threshold</a></div> <div class="gutter_text_right"><a name="145577">Attribute</a></div> <div class="Body_attr"><a name="145579">BulkCharacterThreshold (BCT)</a></div> <div class="gutter_text_right"><a name="145580">Description</a></div> <div class="Body"><a name="352666">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="145585">Valid Values</a></div> <div class="Body"><a name="352670">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352671">where </a><span class="EquationVariables">x</span> is an integer that specifies the number of KB.</div> <div class="Body"><a name="352672">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="352673">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="352674">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="145594">Default</a></div> <div class="Body"><a name="145595">-1</a></div> <div class="gutter_text_right"><a name="145596">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109199', '');" name="145601">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="113177">Charset</a></div> <div class="gutter_text_right"><a name="113178">Attribute</a></div> <div class="Body_attr"><a name="113179">Charset (CS)</a></div> <div class="gutter_text_right"><a name="121856">Description</a></div> <div class="Body"><a name="113180">The name of a character set installed on the Sybase server to be used by the driver. </a></div> <div class="Body"><a name="113182">This option is not a substitute for the IANAAppCodePage option. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.04.html#325472', '');">IANAAppCodePage</a></span> for details.</div> <div class="gutter_text_right"><a name="118912">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="127848">charset</a></span></div> <div class="Body"><a name="118913">where </a><span class="EquationVariables">charset</span> is the name of a character set installed on the Sybase server. </div> <div class="Body"><a name="135667">If unspecified, the character set setting on the Sybase server is used.</a></div> <div class="Body"><a name="135823">For the driver to return Unicode SQL types for connections to Sybase 12.5 and higher, use </a>a value of UTF-8. Refer to the Sybase server documentation for a list of valid character sets.</div> <div class="gutter_text_right"><a name="135946">Example</a></div> <div class="Body"><a name="136004">If your client needs to receive data in iso-8859-1 from a non-Unicode Sybase server, you </a>would specify a value of iso_1.</div> <div class="gutter_text_right"><a name="113183">Default</a></div> <div class="Body"><a name="113184">None</a></div> <div class="gutter_text_right"><a name="120977">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106547', '');" name="212468">Connection tab</a></span> </div> <div class="head_2_no_TOC"><a name="151035">Connection Cache Size</a></div> <div class="gutter_text_right"><a name="151160">Attribute</a></div> <div class="Body_attr"><a name="151161">CursorCacheSize (CCS) </a></div> <div class="gutter_text_right"><a name="151177">Description</a></div> <div class="Body"><a name="151162">The number of connections that the connection cache can hold. </a></div> <div class="gutter_text_right"><a name="151379">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="153592">x</a></span></div> <div class="Body"><a name="153593">where </a><span class="EquationVariables">x</span> is a positive integer representing the number of connections that the connection cache can hold.</div> <div class="Body"><a name="153594">To enable the connection cache, you must set the Select Method option to 1 (enabled). </a>Increasing the connection cache may increase performance of some applications but requires additional database resources.</div> <div class="gutter_text_right"><a name="151190">Default</a></div> <div class="Body"><a name="152498">1</a></div> <div class="gutter_text_right"><a name="153571">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106592', '');" name="153576">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="145855">Connection Pooling</a></div> <div class="gutter_text_right"><a name="145856">Attribute</a></div> <div class="Body_attr"><a name="145858">Pooling (POOL)</a></div> <div class="gutter_text_right"><a name="145859">Description</a></div> <div class="Body"><a name="352678">Specifies whether to use the driverâ??s connection pooling.</a></div> <div class="Body"><a name="352679">NOTE: The application must be thread-enabled to use connection pooling.</a></div> <div class="Body"><a name="352826">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="162511">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="145864">Valid Values</a></div> <div class="Body"><a name="352683">0 | 1</a></div> <div class="Body"><a name="352684">If set to 1 (Enabled), the driver uses connection pooling. </a></div> <div class="Body"><a name="352685">If set to 0 (Disabled), the driver does not use connection pooling.</a></div> <div class="gutter_text_right"><a name="145871">Default</a></div> <div class="Body"><a name="145872">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="145873">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109106', '');" name="145878">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="145880">Connection Reset</a></div> <div class="gutter_text_right"><a name="145881">Attribute</a></div> <div class="Body_attr"><a name="145883">ConnectionReset (CR)</a></div> <div class="gutter_text_right"><a name="145884">Description</a></div> <div class="Body"><a name="352689">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="162602">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="145889">Valid Values</a></div> <div class="Body"><a name="352693">0 | 1</a></div> <div class="Body"><a name="352694">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="352695">If set to 0 (Disabled), the state of connections is not reset.</a></div> <div class="gutter_text_right"><a name="145896">Default</a></div> <div class="Body"><a name="145897">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="145898">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109106', '');" name="145903">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="113193">Connection Retry Count</a></div> <div class="gutter_text_right"><a name="127723">Attribute</a></div> <div class="Body_attr"><a name="127725">ConnectionRetryCount (CRC)</a></div> <div class="gutter_text_right"><a name="127726">Description</a></div> <div class="Body"><a name="352255">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="352256">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="127732">Valid Values</a></div> <div class="Body"><a name="352260">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352261">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="352262">If set to 0, the driver does not try to connect after the initial unsuccessful attempt.</a></div> <div class="Body"><a name="352263">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="113203">Default</a></div> <div class="Body"><a name="113204">0</a></div> <div class="gutter_text_right"><a name="120983">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="113212">Failover tab</a></span> </div> <div class="head_2_no_TOC"><a name="113213">Connection Retry Delay</a></div> <div class="gutter_text_right"><a name="113214">Attribute</a></div> <div class="Body_attr"><a name="113215">ConnectionRetryDelay (CRD)</a></div> <div class="gutter_text_right"><a name="121836">Description</a></div> <div class="Body"><a name="352456">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="352457">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="118941">Valid Values</a></div> <div class="Body"><a name="352233">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352234">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="352235">If set to 0, there is no delay between retries.</a></div> <div class="Body"><a name="352236">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="113222">Default</a></div> <div class="Body"><a name="113223">3</a></div> <div class="gutter_text_right"><a name="120989">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="113231">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="113232">Cursor Positioning for Raiserror</a></div> <div class="gutter_text_right"><a name="113233">Attribute</a></div> <div class="Body_attr"><a name="113234">RaiseErrorPositionBehavior (REPB)</a></div> <div class="gutter_text_right"><a name="121830">Description</a></div> <div class="Body"><a name="113235">Determines whether the driver returns raiserrors when the next statement is executed or </a>handles them separately.</div> <div class="gutter_text_right"><a name="118952">Valid Values</a></div> <div class="Body"><a name="118953">0 | 1</a></div> <div class="Body"><a name="122104">If set to 0 (Default), raiserrors are handled separately from surrounding statements. The </a>error is returned when a raiserror is processed (for example, resulting from SQLExecute, SQLExecDirect, or SQLMoreResults). The result set is empty.</div> <div class="Body"><a name="122105">If set to 1 (Microsoft compatible), raiserrors are returned when the next statement is </a>processed, and the cursor is positioned on the first row of the subsequent result set. This could result in multiple raiserrors being returned on a single execute.</div> <div class="gutter_text_right"><a name="113238">Default</a></div> <div class="Body"><a name="113239">0 (Default)</a></div> <div class="gutter_text_right"><a name="120998">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113248">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="113250">Data Source Name</a></div> <div class="gutter_text_right"><a name="113251">Attribute</a></div> <div class="Body_attr"><a name="113253">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="121824">Description</a></div> <div class="Body"><a name="352461">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="118959">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="352228">string</a></span> </div> <div class="Body"><a name="352229">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="127606">Default</a></div> <div class="Body"><a name="127608">None</a></div> <div class="gutter_text_right"><a name="122154">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106324', '');" name="122159">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="122160">Database List</a></div> <div class="gutter_text_right"><a name="113271">Attribute</a></div> <div class="Body_attr"><a name="113272">n/a</a></div> <div class="gutter_text_right"><a name="121604">Description</a></div> <div class="Body"><a name="113273">A list of database names that will appear in the drop-down list of the logon dialog box (see </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106720', '');">â??Using a Logon Dialog Boxâ??</a></span> for a description).</div> <div class="gutter_text_right"><a name="118966">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="127467">database_list</a></span></div> <div class="Body"><a name="127468">where </a><span class="EquationVariables">database_list</span> is a comma-separated list of database names that will appear in the drop-down list of the logon dialog box.</div> <div class="gutter_text_right"><a name="113274">Default</a></div> <div class="Body"><a name="113275">None</a></div> <div class="gutter_text_right"><a name="121010">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106547', '');" name="212446">Connection tab</a></span> </div> <div class="head_2_no_TOC"><a name="113285">Database Name</a></div> <div class="gutter_text_right"><a name="113286">Attribute</a></div> <div class="Body_attr"><a name="113287">Database (DB)</a></div> <div class="gutter_text_right"><a name="136362">Description</a></div> <div class="Body"><a name="352224">The name of the database to which you want to connect.</a></div> <div class="gutter_text_right"><a name="136369">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="352348">database_name</a></span> </div> <div class="Body"><a name="352349">where </a><span class="EquationVariables">database_name</span> is the name of a valid database.</div> <div class="gutter_text_right"><a name="136375">Default</a></div> <div class="Body"><a name="136376">None</a></div> <div class="gutter_text_right"><a name="121016">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106324', '');" name="113299">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="113300">Description</a></div> <div class="gutter_text_right"><a name="136423">Attribute</a></div> <div class="Body_attr"><a name="136425">Description (n/a)</a></div> <div class="gutter_text_right"><a name="136426">Description</a></div> <div class="Body"><a name="352220">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="136431">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="352353">string</a></span> </div> <div class="Body"><a name="352354">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="136437">Default</a></div> <div class="Body"><a name="136438">None</a></div> <div class="gutter_text_right"><a name="121023">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106324', '');" name="113314">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="113315">Default Buffer Size for Long/LOB Columns (in Kb)</a></div> <div class="gutter_text_right"><a name="113316">Attribute</a></div> <div class="Body_attr"><a name="113317">DefaultLongDataBuffLen (DLDBL)</a></div> <div class="gutter_text_right"><a name="121554">Description</a></div> <div class="Body"><a name="352469">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="144252">This option also applies to binding long parameters in chunks. The driver truncates any data </a>passed in a Long/LOB SQL_DATA_AT_EXEC parameter to the size specified.</div> <div class="Body"><a name="144225">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="119053">Valid Values</a></div> <div class="Body"><a name="352585">An integer in multiples of 1024</a></div> <div class="Body"><a name="352586">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="113323">Default</a></div> <div class="Body"><a name="113324">1024</a></div> <div class="gutter_text_right"><a name="121032">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="337292">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="337303">Distributed Transaction Model</a></div> <div class="gutter_text_right"><a name="337304">Attribute</a></div> <div class="Body_attr"><a name="113339">DistributedTransactionModel (DTM)</a></div> <div class="gutter_text_right"><a name="121540">Description</a></div> <div class="Body"><a name="113340">The model to use for distributed transaction support. The driver supports two different </a>models: XA Protocol and Native OLE.</div> <div class="gutter_text_right"><a name="244256">Valid Values</a></div> <div class="Body"><a name="244257">0 | 1</a></div> <div class="table_text"><a name="244258">Specify the appropriate distributed transaction protocol, either </a><span style="font-size: 11.0pt;">0 (XA Protocol) or 1 </span><span style="font-size: 11.0pt;">(Native</span><span style="font-size: 11.0pt;"> </span><span style="font-size: 11.0pt;">OLE)</span></div> <div class="gutter_text_right"><a name="113341">Default</a></div> <div class="Body"><a name="113342">0 (XA Protocol)</a></div> <div class="gutter_text_right"><a name="121038">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113350">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="146129">Enable Bulk Load</a></div> <div class="gutter_text_right"><a name="146130">Attribute</a></div> <div class="Body_attr"><a name="146132">EnableBulkLoad (EBL)</a></div> <div class="gutter_text_right"><a name="146133">Description</a></div> <div class="Body"><a name="352699">Specifies the bulk load method. </a></div> <div class="Body"><a name="163375">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="146138">Valid Values</a></div> <div class="Body"><a name="352703">0 | 1</a></div> <div class="Body"><a name="352704">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="352705">If set to 0 (Disabled), the driver uses standard parameter arrays.</a></div> <div class="gutter_text_right"><a name="146145">Default</a></div> <div class="Body"><a name="146147">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="146148">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109199', '');" name="146153">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="113351">Enable Describe Parameter</a></div> <div class="gutter_text_right"><a name="113352">Attribute</a></div> <div class="Body_attr"><a name="113353">EnableDescribeParam (EDP)</a></div> <div class="gutter_text_right"><a name="121530">Description</a></div> <div class="Body"><a name="113354">Determines whether the driver supports the SQLDescribeParam function, which allows an </a>application to describe parameters in SQL statements and in stored procedure calls. </div> <div class="gutter_text_right"><a name="119086">Valid Values</a></div> <div class="Body"><a name="119087">0 | 1</a></div> <div class="Body"><a name="137417">If set to 1 (Enabled), the driver supports SQLDescribeParam. The Prepare Method option </a>must be set to 0 or 1, and the SQL statement must not include long parameters. If using Microsoft Remote Data Objects (RDO) to access data, you must use this value.</div> <div class="Body"><a name="137459">If set to 0 (Disabled), the driver does not support SQLDescribeParam.</a></div> <div class="gutter_text_right"><a name="113355">Default</a></div> <div class="Body"><a name="113356">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="121055">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113364">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="113365">Enable Quoted Identifiers</a></div> <div class="gutter_text_right"><a name="113366">Attribute</a></div> <div class="Body_attr"><a name="113367">EnableQuotedIdentifiers (EQI)</a></div> <div class="gutter_text_right"><a name="121520">Description</a></div> <div class="Body"><a name="113368">Determines whether the driver supports the use of quoted identifiers. </a></div> <div class="gutter_text_right"><a name="127045">Valid Values</a></div> <div class="Body"><a name="127046">0 | 1</a></div> <div class="Body"><a name="137714">If set to 1 (Enabled), the driver supports the use of quoted identifiers. Double quotation </a>marks (") must be used to enclose identifiers, such as column and table names. Character strings must be enclosed in single quotation marks, for example:</div> <div class="syntax_first"><a name="137715">SELECT "au_id"</a></div> <div class="syntax"><a name="137716">FROM "authors"</a></div> <div class="syntax"><a name="137707">WHERE "au_lname" = 'O''Brien'</a></div> <div class="Body"><a name="113372">If set to 0 (Disabled), the driver does not support the use of quoted identifiers and generates </a>an error when quoted identifiers are encountered.</div> <div class="gutter_text_right"><a name="113373">Default</a></div> <div class="Body"><a name="113374">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="121186">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113382">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="113383">Encryption Method</a></div> <div class="gutter_text_right"><a name="113384">Attribute</a></div> <div class="Body_attr"><a name="113385">EncryptionMethod (EM)</a></div> <div class="gutter_text_right"><a name="121514">Description</a></div> <div class="Body"><a name="352473">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="123198">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="119100">Valid Values</a></div> <div class="Body"><a name="231883">0 | 1</a></div> <div class="Body"><a name="352590">If set to 0 (No Encryption), data is not encrypted.</a></div> <div class="Body"><a name="352591">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="126949">This option can only be set to 1 when Authentication</a> Method is set to 0 or 1.</div> <div class="gutter_text_right"><a name="113392">Default</a></div> <div class="Body"><a name="113393">0 (No Encryption)</a></div> <div class="gutter_text_right"><a name="121195">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="113405">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="144849">Failover Granularity</a></div> <div class="gutter_text_right"><a name="144850">Attribute</a></div> <div class="Body_attr"><a name="144852">FailoverGranularity (FG)</a></div> <div class="gutter_text_right"><a name="144853">Description</a></div> <div class="Body"><a name="352595">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="352596">This option applies only when Failover Mode is set to 1 (Extended Connection) or 2 </a>(Select). </div> <div class="Body"><a name="352597">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="144860">Valid Values</a></div> <div class="Body"><a name="352601">0 | 1 | 2 | 3</a></div> <div class="Body"><a name="352602">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="352603">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="352604">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="352605">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="144869">Default</a></div> <div class="Body"><a name="144871">0 (Non-Atomic)</a></div> <div class="gutter_text_right"><a name="144872">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="144877">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="144879">Failover Mode</a></div> <div class="gutter_text_right"><a name="144880">Attribute</a></div> <div class="Body_attr"><a name="144882">FailoverMode (FM)</a></div> <div class="gutter_text_right"><a name="144883">Description</a></div> <div class="Body"><a name="352609">Specifies the type of failover method the driver uses. </a></div> <div class="Body"><a name="352610">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="162919">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="144889">Valid Values</a></div> <div class="Body"><a name="352614">0 | 1 | 2</a></div> <div class="Body"><a name="352615">If set to 0 (Connection), the driver provides failover protection for new connections only. </a></div> <div class="Body"><a name="352616">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="352617">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="144897">Default</a></div> <div class="Body"><a name="144899">0 (Connection)</a></div> <div class="gutter_text_right"><a name="144900">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="144905">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="144907">Failover Preconnect</a></div> <div class="gutter_text_right"><a name="144908">Attribute</a></div> <div class="Body_attr"><a name="144910">FailoverPreconnect (FP)</a></div> <div class="gutter_text_right"><a name="144911">Description</a></div> <div class="Body"><a name="352621">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="352622">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="352623">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="144918">Valid Values</a></div> <div class="Body"><a name="352627">0 | 1</a></div> <div class="Body"><a name="352628">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="352629">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="144925">Default</a></div> <div class="Body"><a name="144927">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="144928">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="144933">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="113406">Fetch Array Size</a></div> <div class="gutter_text_right"><a name="113407">Attribute</a></div> <div class="Body_attr"><a name="113408">ArraySize (AS)</a></div> <div class="gutter_text_right"><a name="121508">Description</a></div> <div class="Body"><a name="144766">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. This connection option can affect performance.</div> <div class="Body"><a name="145183">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="119136">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="119137">x</a></span></div> <div class="Body"><a name="137829">where </a><span class="EquationVariables">x</span> is a positive integer specifying the number of rows.</div> <div class="gutter_text_right"><a name="113413">Default</a></div> <div class="Body"><a name="113414">50</a></div> <div class="gutter_text_right"><a name="121201">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106592', '');" name="113423">Performance tab</a></span> </div> <div class="head_2_no_TOC"><a name="291941">Fetch TWFS as Time</a></div> <div class="gutter_text_right"><a name="291948">Attribute</a></div> <div class="Body_attr"><a name="291964">FetchTWFSasTime (FTWFSAT)</a></div> <div class="gutter_text_right"><a name="292513">Description</a></div> <div class="Body"><a name="292514">Determines which ODBC data type the driver uses to return column values with the </a>BIGTIME data type.</div> <div class="Body"><a name="293275">NOTE: The BIGTIME data type is supported in Sybase 15.5 and higher.</a></div> <div class="gutter_text_right"><a name="292127">Valid Values</a></div> <div class="Body"><a name="292140">0 | 1</a></div> <div class="Body"><a name="292400">If set to 1, the driver returns column values for the BIGTIME data type as the ODBC data </a>type SQL_TYPE_TIME. The fractional seconds portion of the value is truncated.</div> <div class="Body"><a name="292402">If set to 0, the driver returns column values for the BIGTIME data type as the ODBC data </a>type SQL_TYPE_TIMESTAMP. When a timestamp is returned for BIGTIME, the Year, Month and Day parts of the timestamp must be set to zero.</div> <div class="gutter_text_right"><a name="292163">Default</a></div> <div class="Body"><a name="292174">1</a></div> <div class="gutter_text_right"><a name="292181">GUI Tab</a></div> <div class="Body"><a name="292273">Advanced</a></div> <div class="head_2_no_TOC"><a name="310083">Field Delimiter</a></div> <div class="gutter_text_right"><a name="310084">Attribute</a></div> <div class="Body_attr"><a name="310086">BulkLoadFieldDelimiter (BLFD)</a></div> <div class="gutter_text_right"><a name="310087">Description</a></div> <div class="Body"><a name="352088">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="310092">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="352290">x</a></span></div> <div class="Body"><a name="352291">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="352292">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="352293">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="310100">Default</a></div> <div class="Body"><a name="310101">None</a></div> <div class="gutter_text_right"><a name="310102">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109199', '');" name="310107">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="113424">GSS Client Library</a></div> <div class="gutter_text_right"><a name="113425">Attribute</a></div> <div class="Body_attr"><a name="113426">GSSClient (GSSC)</a></div> <div class="gutter_text_right"><a name="121502">Description</a></div> <div class="Body"><a name="352484">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="352485">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="119143">Valid Values</a></div> <div class="Body"><a name="352477">native | </a><span class="EquationVariables">client_library</span></div> <div class="Body"><a name="352478">where </a><span class="EquationVariables">client_library</span> is a GSS client library installed on the client.</div> <div class="Body"><a name="352479">If set to </a><span class="EquationVariables">client_library</span>, the driver uses the specified GSS client library.</div> <div class="Body"><a name="352480">If set to native, the driver uses the GSS client shipped with the operating system.</a></div> <div class="gutter_text_right"><a name="113434">Default</a></div> <div class="Body"><a name="113435">native</a></div> <div class="gutter_text_right"><a name="121207">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="113443">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="113444">HA Failover Server Connection Information/Network </a>Address</div> <div class="gutter_text_right"><a name="113445">Attribute</a></div> <div class="Body_attr"><a name="113446">FailoverNetworkAddress (FNA)</a></div> <div class="gutter_text_right"><a name="121496">Description</a></div> <div class="Body"><a name="113447">The network address of the High Availability (HA) Failover server to be used in the event of </a>a connection loss. The driver detects the dropped connection and automatically reconnects to the specified HA Failover server. This option is valid only for Sybase 12 and higher servers that have the High Availability Failover feature enabled.</div> <div class="gutter_text_right"><a name="126817">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="113448">IP_</a></span><span class="EquationVariables">address</span><span class="Syntax">, </span><span class="EquationVariables">port_number | pipe_address</span><span class="Syntax">, </span><span class="EquationVariables">port_number</span> <span class="EquationVariables">| server_name</span><span class="Syntax">, </span><span class="EquationVariables">port_number</span></div> <div class="Body"><a name="138231">where</a></div> <div class="Body"><span class="EquationVariables"><a name="138318">IP_ address</a></span> is the IP address that uniquely identifies the HA Failover server. </div> <div class="Body"><span class="EquationVariables"><a name="138331">port_number</a></span> is the port number assigned to the listener process on the HA Failover server.</div> <div class="Body"><span class="EquationVariables"><a name="138345">server_name</a></span> is a name that uniquely identifies the HA Failover server. You can use this format if your environment supports named servers.</div> <div class="Body"><span class="EquationVariables"><a name="138797">pipe_address</a></span> is the pipe address of the HA Failover server. This format is required if using NamedPipes as the network protocol.</div> <div class="Body"><a name="113450">NOTE: The HA Failover Server Connection Information option and the Alternate Servers </a>option are mutually exclusive.</div> <div class="gutter_text_right"><a name="138296">Example</a></div> <div class="Body" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="138300">199.226.224.34, 5000</a></span></div> <div class="Body"><a name="138403">or </a></div> <div class="Body" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="139107">\\machine1\sybase\pipe\query, 5000</a></span></div> <div class="Body"><a name="139102">or</a></div> <div class="Body" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="138417">Sybaseserver, 5000</a></span></div> <div class="gutter_text_right"><a name="113451">Default</a></div> <div class="Body"><a name="113452">None</a></div> <div class="gutter_text_right"><a name="121213">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="113460">Failover tab</a></span> </div> <div class="head_2_no_TOC"><a name="113461">Host Name In Certificate</a></div> <div class="gutter_text_right"><a name="113462">Attribute</a></div> <div class="Body_attr"><a name="113463">HostNameInCertificate (HNIC)</a></div> <div class="gutter_text_right"><a name="121490">Description</a></div> <div class="Body"><a name="352489">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="119157">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="352633">host_name | #SERVERNAME#</a></span> </div> <div class="Body"><a name="352634">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="352635">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="352636">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="352637">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="113472">Default</a></div> <div class="Body"><a name="113473">None</a></div> <div class="gutter_text_right"><a name="121219">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="325461">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="325472">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="325473">Attribute</a></div> <div class="Body_attr"><a name="113487">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="121484">Description</a></div> <div class="Body"><a name="352493">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="352501">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="352502">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="352503">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="352504">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="352505">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="352506">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="119172">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="352641">IANA_code_page</a></span> </div> <div class="Body"><a name="352643">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="125990">Default</a></div> <div class="Body"><a name="125992">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="161267">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="161271">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="161273">Initialization String</a></div> <div class="gutter_text_right"><a name="113517">Attribute</a></div> <div class="Body_attr"><a name="113518">InitializationString (IS)</a></div> <div class="gutter_text_right"><a name="139414">Description</a></div> <div class="Body"><a name="352408">A SQL command that is issued immediately after connecting to the database to manage </a>session settings. </div> <div class="Body"><a name="352409">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="352421">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="352422">SQL_command</a></span></div> <div class="Body"><a name="352423">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="232690">Example</a></div> <div class="Body"><a name="139426">To allow delimited identifiers, specify:</a></div> <div class="syntax_first"><a name="139427">Initialization String=set QUOTED_IDENTIFIER on</a></div> <div class="gutter_text_right"><a name="139429">Default</a></div> <div class="Body"><a name="139430">None</a></div> <div class="gutter_text_right"><a name="121231">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113529">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="113533">Interfaces File</a></div> <div class="gutter_text_right"><a name="113534">Attribute</a></div> <div class="Body_attr"><a name="113535">InterfacesFile (IF)</a></div> <div class="gutter_text_right"><a name="121458">Description</a></div> <div class="Body"><a name="113536">The directory to the Interfaces file. </a></div> <div class="Body"><a name="113537">NOTE: This option and the Network Address option are mutually exclusive.</a></div> <div class="gutter_text_right"><a name="119186">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="119187">file_dir</a></span></div> <div class="Body"><a name="139865">where </a><span class="EquationVariables">file_dir</span> is the directory to the Interfaces file.</div> <div class="Body"><a name="139864">If unspecified and a value is specified for the Server Name option, the driver looks for the </a>path name of the Interfaces file in the Registry under <span style="font-size: 10.5pt;">HKEY_LOCAL_MACHINE\SOFTWARE\DataDirect\InterfacesFile</span>. If this Registry value is empty, the driver will try to open the SQL.INI file found in the same directory where the driver is located and use it as the Interfaces file.</div> <div class="gutter_text_right"><a name="113538">Default</a></div> <div class="Body"><a name="113539">None</a></div> <div class="gutter_text_right"><a name="121237">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106324', '');" name="113548">General tab</a></span></div> <div class="head_2_no_TOC"><a name="113549">Language</a></div> <div class="gutter_text_right"><a name="113550">Attribute</a></div> <div class="Body_attr"><a name="113551">Language (LANG)</a></div> <div class="gutter_text_right"><a name="121452">Description</a></div> <div class="Body"><a name="113552">The national character set installed on the Sybase server. </a></div> <div class="gutter_text_right"><a name="119193">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="119194">charset</a></span></div> <div class="Body"><a name="139882">where </a><span class="EquationVariables">charset</span> is the national character set installed on the Sybase server.</div> <div class="gutter_text_right"><a name="113553">Default</a></div> <div class="Body"><a name="113554">None (English)</a></div> <div class="gutter_text_right"><a name="121243">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106547', '');" name="212415">Connection tab</a></span> </div> <div class="head_2_no_TOC"><a name="146502">Load Balance Timeout</a></div> <div class="gutter_text_right"><a name="146503">Attribute</a></div> <div class="Body_attr"><a name="146505">LoadBalanceTimeout (LBT)</a></div> <div class="gutter_text_right"><a name="146506">Description</a></div> <div class="Body"><a name="352451">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="352452">NOTE: The Min Pool Size option may cause some connections to ignore this value.</a></div> <div class="Body"><a name="352834">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="162651">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="146512">Valid Values</a></div> <div class="Body"><a name="352510">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352511">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="352512">If set to 0, inactive connections are kept open.</a></div> <div class="Body"><a name="352513">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="146520">Default</a></div> <div class="Body"><a name="146522">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="146523">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109106', '');" name="146528">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="146530">Load Balancing</a></div> <div class="gutter_text_right"><a name="146531">Attribute</a></div> <div class="Body_attr"><a name="146533">LoadBalancing (LB)</a></div> <div class="gutter_text_right"><a name="146534">Description</a></div> <div class="Body"><a name="352745">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="146539">Valid Values</a></div> <div class="Body"><a name="352749">0 | 1</a></div> <div class="Body"><a name="352750">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="352751">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="352752">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="146546">Default</a></div> <div class="Body"><a name="146548">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="146549">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106641', '');" name="146554">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="146665">Login Timeout</a></div> <div class="gutter_text_right"><a name="146666">Attribute</a></div> <div class="Body_attr"><a name="146668">LoginTimeout (LT)</a></div> <div class="gutter_text_right"><a name="146669">Description</a></div> <div class="Body"><a name="352756">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="146674">Valid Values</a></div> <div class="Body"><a name="352760">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352761">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="352762">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="352763">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="352764">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="146683">Default</a></div> <div class="Body"><a name="146685">15</a></div> <div class="gutter_text_right"><a name="146686">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="146691">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="173904">Max Pool Size</a></div> <div class="gutter_text_right"><a name="146828">Attribute</a></div> <div class="Body_attr"><a name="146830">MaxPoolSize (MXPS)</a></div> <div class="gutter_text_right"><a name="146831">Description</a></div> <div class="Body"><a name="352782">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="162759">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="146836">Valid Values</a></div> <div class="Body"><a name="352786">An integer from 1 to 65535</a></div> <div class="Body"><a name="352787">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="146842">Default</a></div> <div class="Body"><a name="146844">100</a></div> <div class="gutter_text_right"><a name="146845">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109106', '');" name="146850">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="146852">Min Pool Size</a></div> <div class="gutter_text_right"><a name="146853">Attribute</a></div> <div class="Body_attr"><a name="146855">MinPoolSize (MNPS)</a></div> <div class="gutter_text_right"><a name="146856">Description</a></div> <div class="Body"><a name="352791">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="162784">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="146861">Valid Values</a></div> <div class="Body"><a name="352795">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352796">where </a><span class="EquationVariables">x</span> is an integer from 1 to 65535.</div> <div class="Body"><a name="352797">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="352798">If set to 0, no connections are opened in addition to the current existing connection.</a></div> <div class="gutter_text_right"><a name="146867">Default</a></div> <div class="Body"><a name="146869">0</a></div> <div class="gutter_text_right"><a name="146870">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109106', '');" name="146875">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="114184">Network Address</a></div> <div class="gutter_text_right"><a name="113585">Attribute</a></div> <div class="Body_attr"><a name="113586">NetworkAddress (NA)</a></div> <div class="gutter_text_right"><a name="140104">Description</a></div> <div class="Body"><a name="140105">A unique identifier assigned to the Sybase server machine.</a></div> <div class="Body"><a name="140190">NOTE: This option is mutually exclusive with the Interfaces File and the Server Name </a>option.</div> <div class="gutter_text_right"><a name="140106">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="140107">server_name</a></span> | <span class="EquationVariables">IP_address</span></div> <div class="Body"><a name="227692">where </a></div> <div class="Body"><span class="EquationVariables"><a name="229386">server_name</a></span> is the Sybase server name specified as: <span class="EquationVariables">named_server</span>, <span class="EquationVariables">port_number</span>. For example, you can enter <span class="Syntax">SSserver, 5000</span>.</div> <div class="Body"><span class="EquationVariables"><a name="352431">IP_address</a></span> is the Sybase server address specified as: <span class="EquationVariables">IP_address</span>, <span class="EquationVariables">port_number</span>. For example, you can enter <span class="Syntax">199.226.224.34, 5000</span>. The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two. 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="270992">Default</a></div> <div class="Body"><a name="140117">None</a></div> <div class="gutter_text_right"><a name="121249">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106324', '');" name="113604">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="113605">Packet Size</a></div> <div class="gutter_text_right"><a name="113606">Attribute</a></div> <div class="Body_attr"><a name="113607">PacketSize (PS)</a></div> <div class="gutter_text_right"><a name="229934">Description</a></div> <div class="Body"><a name="352768">Determines the number of bytes for each database protocol packet that is transferred from </a>the database server to the client machine. Adjusting the packet size can improve performance. The optimal value depends on the typical size of data that is inserted, updated, or returned by the application and the environment in which it is running. Typically, larger packet sizes work better for large amounts of data. For example, if an application regularly returns character values that are 10,000 characters in length, using a value of 32 (16 KB) typically results in improved performance. </div> <div class="Body"><a name="352769">NOTE: The ODBC connection option SQL_PACKET_SIZE provides the same functionality </a>as the Packet Size option; however SQL_PACKET SIZE and the Packet Size option are mutually exclusive. If Packet Size is specified, the driver returns the message <span class="Syntax">Driver Not </span><span class="Syntax">Capable</span> if an application attempts to call SQL_PACKET_SIZE. If you do not set the Packet Size option, application calls to SQL_PACKET_SIZE are accepted by the driver.</div> <div class="Body"><a name="145197">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="352773">Valid Values</a></div> <div class="Body"><a name="352774">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352775">If set to -1, the driver uses the maximum packet size that is set by the database server. </a></div> <div class="Body"><a name="352776">If set to 0, the driver uses the default packet size that is used by the database server. </a></div> <div class="Body"><a name="352777">If set to </a><span class="EquationVariables">x</span>, an integer from 1 to 127, the driver uses a packet size that is a multiple of 512 bytes. For example, PacketSize=8 means to set the packet size to 8 * 512 bytes (4096 bytes).</div> <div class="Body"><a name="352778">NOTE: IF SSL encryption is used, the driver must use the packet size that is specified by </a>the server. Any value set for this option or the SQL_PACKET_SIZE connect option is ignored if SSL encryption is used.</div> <div class="gutter_text_right"><a name="113617">Default</a></div> <div class="Body"><a name="126186">0</a></div> <div class="gutter_text_right"><a name="126188">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106592', '');" name="113627">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="113628">Password</a></div> <div class="gutter_text_right"><a name="113629">Attribute</a></div> <div class="Body_attr"><a name="113631">Password (PWD)</a></div> <div class="gutter_text_right"><a name="140721">Description</a></div> <div class="Body"><a name="352517">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="140726">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="352541">pwd</a></span> </div> <div class="Body"><a name="352542">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="140732">Default</a></div> <div class="Body"><a name="140733">None</a></div> <div class="gutter_text_right"><a name="219772">GUI Tab</a></div> <div class="Body"><a name="219790">n/a</a></div> <div class="head_2_no_TOC"><a name="113644">Prepare Method</a></div> <div class="gutter_text_right"><a name="113645">Attribute</a></div> <div class="Body_attr"><a name="113646">OptimizePrepare (OP)</a></div> <div class="gutter_text_right"><a name="121434">Description</a></div> <div class="Body"><a name="113647">Determines whether stored procedures are created on the server for calls to SQLPrepare.</a></div> <div class="Body"><a name="145208">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="119273">Valid Values</a></div> <div class="Body"><a name="119274">0 | 1 | 2 | 3</a></div> <div class="Body"><a name="122833">If set to 0 - None, stored procedures are created for every call to SQLPrepare. This setting </a>can result in decreased performance when processing statements that do not contain parameters.</div> <div class="Body"><a name="122834">If set to 1 - Partial, the driver creates stored procedures only if the statement contains </a>parameters. Otherwise, the statement is cached and run directly at the time of SQLExecute. </div> <div class="Body"><a name="122835">If set to 2 - Full, stored procedures are never created. The driver caches the statement, </a>executes it directly at the time of SQLExecute, and reports any syntax or similar errors at the time of SQLExecute.</div> <div class="Body"><a name="122836">If set to 3 - Full at Prepare, stored procedures are never created. This is identical to value 2 </a>except that any syntax or similar errors are returned at the time of SQLPrepare instead of SQLExecute. Use this setting only if you must have syntax errors reported at the time of SQLPrepare.</div> <div class="gutter_text_right"><a name="113652">Default</a></div> <div class="Body"><a name="113653">1 (Partial)</a></div> <div class="gutter_text_right"><a name="121267">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106592', '');" name="113662">Performance tab</a></span></div> <div class="head_2_no_TOC"><a name="147057">Query Timeout</a></div> <div class="gutter_text_right"><a name="147058">Attribute</a></div> <div class="Body_attr"><a name="147060">QueryTimeout (QT)</a></div> <div class="gutter_text_right"><a name="147061">Description</a></div> <div class="Body"><a name="352802">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="147066">Valid Values</a></div> <div class="Body"><a name="352806">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="352807">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="352808">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="352809">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="352810">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="147075">Default</a></div> <div class="Body"><a name="147077">0</a></div> <div class="gutter_text_right"><a name="147078">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="147083">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="310206">Record Delimiter</a></div> <div class="gutter_text_right"><a name="310207">Attribute</a></div> <div class="Body_attr"><a name="310209">BulkLoadRecordDelimiter (BLRD)</a></div> <div class="gutter_text_right"><a name="310210">Description</a></div> <div class="Body"><a name="352709">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="310215">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="352713">x</a></span></div> <div class="Body"><a name="352714">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="352715">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="352716">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="310223">Default</a></div> <div class="Body"><a name="310224">None</a></div> <div class="gutter_text_right"><a name="310225">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#109199', '');" name="310230">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="113663">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="113664">Attribute</a></div> <div class="Body_attr"><a name="113665">ReportCodepageConversionErrors (RCCE)</a></div> <div class="gutter_text_right"><a name="140915">Description</a></div> <div class="Body"><a name="352521">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="352522">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="140922">Valid Values</a></div> <div class="Body"><a name="352546">0 | 1 | 2</a></div> <div class="Body"><a name="352547">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="352548">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="352549">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="140930">Default</a></div> <div class="Body"><a name="140932">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="121273">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113683">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="113684">Select Method</a></div> <div class="gutter_text_right"><a name="113685">Attribute</a></div> <div class="Body_attr"><a name="113686">SelectMethod (SM)</a></div> <div class="gutter_text_right"><a name="121418">Description</a></div> <div class="Body"><a name="113687">Determines whether database cursors are used for Select statements.</a></div> <div class="Body"><a name="154044">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.05.html#113089', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="119342">Valid Values</a></div> <div class="Body"><a name="119343">0 | 1</a></div> <div class="Body"><a name="123047">If set to 0 (Cursor), database cursors are used. In some cases performance degradation </a>can occur when performing large numbers of sequential Select statements because of the amount of overhead associated with creating database cursors.</div> <div class="Body"><a name="123048">If set to 1 (Direct), Select statements are run directly without using database cursors, and </a>the data source is limited to one active statement. </div> <div class="gutter_text_right"><a name="113690">Default</a></div> <div class="Body"><a name="113691">0 (Cursor)</a></div> <div class="gutter_text_right"><a name="121279">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106592', '');" name="113700">Performance tab</a></span> </div> <div class="head_2_no_TOC"><a name="113701">Server Name</a></div> <div class="gutter_text_right"><a name="113702">Attribute</a></div> <div class="Body_attr"><a name="113703">InterfacesFileServerName (IFSN)</a></div> <div class="gutter_text_right"><a name="121409">Description</a></div> <div class="Body"><a name="113704">The name of the section in the Interfaces file containing the network connection information </a>for the Sybase server. Typically, the section name is the host name of the Sybase server.</div> <div class="Body"><a name="113705">NOTE: The Network Address option and the Server Name option are mutually exclusive.</a></div> <div class="gutter_text_right"><a name="119353">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="119354">section_name</a></span></div> <div class="Body"><a name="141485">where </a><span class="EquationVariables">section_name</span> is a section in the Interfaces file containing the network connection information for the Sybase server.</div> <div class="gutter_text_right"><a name="113706">Default</a></div> <div class="Body"><a name="113707">None</a></div> <div class="gutter_text_right"><a name="121285">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106324', '');" name="113716">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="113717">Service Principal Name</a></div> <div class="gutter_text_right"><a name="113718">Attribute</a></div> <div class="Body_attr"><a name="113719">ServicePrincipalName (SPN)</a></div> <div class="gutter_text_right"><a name="121403">Description</a></div> <div class="Body"><a name="113720">The service principal name to be used by driver for Kerberos authentication.</a></div> <div class="gutter_text_right"><a name="119366">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="141533">servicePrincipalName</a></span></div> <div class="Body"><a name="141588">where </a><span class="EquationVariables">servicePrincipalName</span> is a valid service principal name.</div> <div class="Body"><a name="141751">If unspecified, the value of the Network Address option is used as the service principal </a>name. If Authentication Method is set to 0 or 1, the value of the Service Principal Name option is ignored.</div> <div class="gutter_text_right"><a name="113724">Default</a></div> <div class="Body"><a name="113725">None</a></div> <div class="gutter_text_right"><a name="121291">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="113733">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="113734">Tightly Coupled Distributed Transactions</a></div> <div class="gutter_text_right"><a name="113735">Attribute</a></div> <div class="Body_attr"><a name="113736">TightlyCoupledDistributedTransactions (TCDT)</a></div> <div class="gutter_text_right"><a name="121389">Description</a></div> <div class="Body"><a name="113737">Sybase 12 or higher server only. Determines whether the driver ensures that multiple </a>connections within the same distributed transaction obey otherâ??s locks.</div> <div class="gutter_text_right"><a name="119373">Valid Values</a></div> <div class="Body"><a name="119374">0 | 1</a></div> <div class="Body"><a name="142052">If set to 1 (Enabled), the driver uses tightly coupled distributed transactions. Multiple </a>connections within the same distributed transaction obey otherâ??s locks.</div> <div class="Body"><a name="142029">If set to 0 (Disabled), the driver does not use tightly coupled distributed transactions. </a>Multiple connections within the same distributed transaction may hang each other because the connections do not obey otherâ??s locks. This value can provide better performance if concurrency of data is not needed.</div> <div class="gutter_text_right"><a name="113740">Default</a></div> <div class="Body"><a name="113741">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="119528">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113749">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="113750">Truncate Time Type Fractions</a></div> <div class="gutter_text_right"><a name="113751">Attribute</a></div> <div class="Body_attr"><a name="113752">TruncateTimeTypeFractions (TTTF)</a></div> <div class="gutter_text_right"><a name="121375">Description</a></div> <div class="Body"><a name="113753">Sybase 12.5.1 and higher only. Determines whether the driver sets fractional seconds to </a>zero (0) when converting data from the TIME data type to TIMESTAMP, CHAR, or WCHAR data types.</div> <div class="gutter_text_right"><a name="119395">Valid Values</a></div> <div class="Body"><a name="119396">0 | 1</a></div> <div class="Body"><a name="142317">If set to 1 (Enabled), the driver converts fractional seconds to zero when converting the </a>TIME data type.</div> <div class="Body"><a name="142318">If set to 0 (Disabled), the driver does not set fractional seconds to</a> zero when converting the TIME data type.</div> <div class="gutter_text_right"><a name="113755">Default</a></div> <div class="Body"><a name="113756">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="119519">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113764">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="113765">Truststore</a></div> <div class="gutter_text_right"><a name="113766">Attribute</a></div> <div class="Body_attr"><a name="113767">Truststore (TS)</a></div> <div class="gutter_text_right"><a name="121365">Description</a></div> <div class="Body"><a name="352526">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="352527">NOTE: The truststore and keystore files may be the same file.</a></div> <div class="gutter_text_right"><a name="142348">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="352553">truststore_directory\filename</a></span> </div> <div class="Body"><a name="352554">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="142354">Default</a></div> <div class="Body"><a name="142355">None</a></div> <div class="gutter_text_right"><a name="119509">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="113782">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="113783">Truststore Password</a></div> <div class="gutter_text_right"><a name="113784">Attribute</a></div> <div class="Body_attr"><a name="113785">TruststorePassword (TSP)</a></div> <div class="gutter_text_right"><a name="121355">Description</a></div> <div class="Body"><a name="352531">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="352532">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="142407">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="352558">truststore_password</a></span></div> <div class="Body"><a name="352559">where </a><span class="EquationVariables">truststore_password</span> is a valid password for the truststore file.</div> <div class="gutter_text_right"><a name="142413">Default</a></div> <div class="Body"><a name="142414">None</a></div> <div class="gutter_text_right"><a name="119500">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="113800">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="113801">User Name</a></div> <div class="gutter_text_right"><a name="113802">Attribute</a></div> <div class="Body_attr"><a name="113803">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="121349">Description</a></div> <div class="Body"><a name="352650">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="142422">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="352563">userid</a></span></div> <div class="Body"><a name="352564">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="142428">Default</a></div> <div class="Body"><a name="142429">None</a></div> <div class="gutter_text_right"><a name="119490">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="113814">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="113815">Validate Server Certificate</a></div> <div class="gutter_text_right"><a name="113816">Attribute</a></div> <div class="Body_attr"><a name="113817">ValidateServerCertificate (VSC)</a></div> <div class="gutter_text_right"><a name="121343">Description</a></div> <div class="Body"><a name="352536">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="352537">Truststore information is specified using the Trust Store and Trust Store Password options. </a></div> <div class="gutter_text_right"><a name="142452">Valid Values</a></div> <div class="Body"><a name="352572">0 | 1</a></div> <div class="Body"><a name="352573">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="352575">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="142463">Default</a></div> <div class="Body"><a name="142465">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="119431">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106485', '');" name="113835">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="113836">Workstation ID</a></div> <div class="gutter_text_right"><a name="113837">Attribute</a></div> <div class="Body_attr"><a name="113838">WorkstationID (WKID)</a></div> <div class="gutter_text_right"><a name="113839">Description</a></div> <div class="Body"><a name="121296">An identifier for the client machine.</a></div> <div class="gutter_text_right"><a name="119438">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="119439">ID</a></span></div> <div class="Body"><a name="142546">where </a><span class="EquationVariables">ID</span> is workstation ID use by the client machine.</div> <div class="gutter_text_right"><a name="113840">Default</a></div> <div class="Body"><a name="113841">None</a></div> <div class="gutter_text_right"><a name="119469">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106547', '');" name="113850">Connection tab</a></span> </div> <div class="head_2_no_TOC"><a name="113851">XA Open String Parameters</a></div> <div class="gutter_text_right"><a name="113852">Attribute</a></div> <div class="Body_attr"><a name="113853">XAOpenStringParameters (XAOSP)</a></div> <div class="gutter_text_right"><a name="121333">Description</a></div> <div class="Body"><a name="113854">Determines the name of trace files generated for XA open string parameters.</a></div> <div class="gutter_text_right"><a name="119445">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="119446">-Ltrace_</a></span><span class="EquationVariables">filename</span></div> <div class="Body"><a name="142718">where </a><span class="Syntax">trace_</span><span class="EquationVariables">filename</span> is a string that identifies trace files generated for XA open string parameters. If specified, two trace files are created. The first trace file traces all XA call activities and is named exactly as specified. The second trace file traces any enlistment and unenlistment procedures and is named as specified with a "driver" extension.</div> <div class="gutter_text_right"><a name="142631">Example</a></div> <div class="Body"><a name="142646">If you specify </a><span class="Syntax">-LXAtrace</span>, the driver creates two trace files: XAtrace and XAtrace.driver.</div> <div class="gutter_text_right"><a name="113855">Default</a></div> <div class="Body"><a name="113856">None</a></div> <div class="gutter_text_right"><a name="113864">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106372', '');" name="113865">Advanced tab</a></span> </div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de