Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\salesforce.27.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/salesforce.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="salesforce.27.01.html#917084">21 The Salesforce Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="917084">Connection Option Descriptions</a></div> <div class="Body"><a name="1650900">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. For example:</div> <div class="hanging_label_head"><a name="1650901">Application Using Threads</a></div> <div class="gutter_text_right"><a name="1650902">Attribute</a></div> <div class="Body"><a name="1650904">ApplicationUsingThreads (AUT)</a></div> <div class="Body"><a name="1650905">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="1650906">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', 'salesforce.27.04.html#1234692', '');" name="1234682">Table 21-1</a></span> lists the connection string attributes supported by the Salesforce driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 21-1. <a name="1234692">Salesforce 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="1234696">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="1234698">Default</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1233121', '');" name="1234738">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="1234740">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1236567', '');" name="1234745">BulkLoadAsync (BLA)</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="1234747">0 (unselected)</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', 'salesforce.27.04.html#1236703', '');" name="1234766">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="1234768">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', 'salesforce.27.04.html#1236732', '');" name="1234773">BulkLoadConcurrencyMode (BLCM)</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="1234775">1 (Parallel)</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', 'salesforce.27.04.html#1568555', '');" name="1569969">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="1569971">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', 'salesforce.27.04.html#1236793', '');" name="1234780">BulkLoadPollInterval (BLPI)</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="1234782">10</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', 'salesforce.27.04.html#1568425', '');" name="1570501">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="1570503">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', 'salesforce.27.04.html#1236938', '');" name="1234787">BulkLoadThreshold (BLTH)</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="1234789">4000</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', 'salesforce.27.04.html#1236749', '');" name="1234794">BulkLoadTimeout (BLTO)</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="1234796">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1237664', '');" name="1288559">ConfigOptions (CO)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1288561">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1288343', '');" name="1234815">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="1234817">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1239243', '');" name="1234829">CreateDB (CDB)</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="1234831">2 (NotExist)</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', 'salesforce.27.04.html#1329249', '');" name="1329447">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="1329449">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', 'salesforce.27.04.html#1061996', '');" name="1244847">Database</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="1244849">The file name prefix the driver uses to </a>create or locate the set of files that define the embedded database per connection.</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', 'salesforce.27.04.html#1239585', '');" name="1234878">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="1234880">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1225622', '');" name="1234885">ExtendedOptions (XO)</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="1234887">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1240495', '');" name="1234892">FetchSize (FS)</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="1234894">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" 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', 'salesforce.27.04.html#1225850', '');" name="1234899">HostName (HOST)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1234901">Empty string (logs into the default </a>Salesforce instance, login.salesforce.com.</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', 'salesforce.27.04.html#1240786', '');" name="1234948">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="1234950">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1226402', '');" name="1234955">JVMArgs (JVMA)</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="1234957"> -Xmx256m</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', 'salesforce.27.04.html#1226671', '');" name="1234962">JVMClasspath (JVMC)</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"><span class="Emphasis"><a name="1234964">install_dir</a></span>\java\lib\sforce.jar</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', 'salesforce.27.04.html#1242124', '');" name="1234983">LogConfigFile (LCF)</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="1234985">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1284896', '');" name="1298707">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="1298709">15</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1298585', '');" name="1286230">LogonDomain (LD)</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="1286232">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1296702', '');" name="1235004">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="1235006">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', 'salesforce.27.04.html#1227269', '');" name="1235025">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="1235027">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" 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', 'salesforce.27.04.html#1227299', '');" name="1235032">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="1235034">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1297445', '');" name="1236356">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="1236358">0 (disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1243005', '');" name="1235039">ProxyHost (PXHN)</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="1235041">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1243037', '');" name="1235046">ProxyPassword (PXPW)</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="1244674">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1243245', '');" name="1244681">ProxyPort (PXPT)</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="1244683">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1243051', '');" name="1235053">ProxyUser (PXUN)</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="1244676">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1242877', '');" name="1236421">ReadOnly (RO)</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="1236423">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1243648', '');" name="1236433">RefreshDirtyCache (RDC)</a></span><span class="Cross_ref_"> </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="1236435">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1232784', '');" name="1235088">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="1235090">0 (Ignore Errors)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1243980', '');" name="1235095">SecurityToken (STK)</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="1235097">Empty string</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" 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', 'salesforce.27.04.html#1597135', '');" name="1603806">ServerPortNumber (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="1603808">19928</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', 'salesforce.27.04.html#1596225', '');" name="1596384">SQLEngineMode (SEM)</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="1596386">0 (Direct)</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', 'salesforce.27.04.html#1243997', '');" name="1235102">StmtCallLimit (SCL)</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="1244787">20</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', 'salesforce.27.04.html#1244032', '');" name="1235109">StmtCallLimitBehavior (SCLB)</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="1244789">1 (ErrorAlways)</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', 'salesforce.27.04.html#1244061', '');" name="1235116">TransactionMode (TM)</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="1244791">0 (No Transactions)</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', 'salesforce.27.04.html#1244351', '');" name="1236069">WSFetchSize (WSFS)</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="1244793">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1244373', '');" name="1236073">WSRetryCount (WSRC)</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="1244795">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1244388', '');" name="1236077">WSTimeout (WST)</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="1244797">120</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="1233118">Application Using Threads</a></div> <div class="gutter_text_right"><a name="1233119">Attribute</a></div> <div class="Body_attr"><a name="1233121">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="1233122">Description</a></div> <div class="Body"><a name="1650910">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="1233129">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.05.html#1058047', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="1233131">Valid Values</a></div> <div class="Body"><a name="1650914">0 | 1</a></div> <div class="Body"><a name="1650915">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="1650916">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="1233138">Default</a></div> <div class="Body"><a name="1233140">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="1233141">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1233146">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1167850">Bulk Load Asynchronous</a></div> <div class="gutter_text_right"><a name="1236566">Attribute</a></div> <div class="Body_attr"><a name="1236567">BulkLoadAsync (BLA)</a></div> <div class="gutter_text_right"><a name="1174607">Description</a></div> <div class="Body"><a name="1174608">Determines whether the driver treats bulk load operations as synchronous or asynchronous.</a></div> <div class="gutter_text_right"><a name="1174610">Valid Values</a></div> <div class="Body"><a name="1174611">0 | 1 </a></div> <div class="Body"><a name="1174612">If set to 0 (Disabled), bulk load operations are synchronous. The driver does not return from </a>the function that invoked an operation until the operation is complete or the BulkLoadTimeout period has expired. If the operation times out, the driver returns an error.</div> <div class="Body"><a name="1175115">If set to 1 (Enabled), bulk load operations are asynchronous. The driver returns from the </a>function that invoked an operation after the operation is submitted to the server. The driver does not verify the completion status of the bulk load operation.</div> <div class="gutter_text_right"><a name="1174613">Default</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="1174614">0</a></span> (Disabled)</div> <div class="gutter_text_right"><a name="1224032">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1224037">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1236666">Bulk Load Batch Size</a></div> <div class="gutter_text_right"><a name="1236702">Attribute</a></div> <div class="Body_attr"><a name="1236703">BulkLoadBatchSize (BLBS)</a></div> <div class="gutter_text_right"><a name="1236667">Description</a></div> <div class="Body"><a name="1650920">The number of rows that the driver sends to the database at a time during bulk operations. </a>This value applies to all methods of bulk loading.</div> <div class="gutter_text_right"><a name="1294513">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="1294514">x</a></span></div> <div class="Body"><a name="1236673">where </a><span class="EquationVariables">x</span> is a positive integer that specifies the number of rows to be sent.</div> <div class="gutter_text_right"><a name="1236675">Default</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="1236676">1024 </a></span></div> <div class="gutter_text_right"><a name="1224043">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1224048">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1175244">Bulk Load Concurrency Mode</a></div> <div class="gutter_text_right"><a name="1236731">Attribute</a></div> <div class="Body_attr"><a name="1236732">BulkLoadConcurrencyMode (BLCM)</a></div> <div class="gutter_text_right"><a name="1175245">Description</a></div> <div class="Body"><a name="1175246">Determines whether multiple batches associated with a bulk load operation are processed </a>by Salesforce in parallel or one at a time. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.6.html#109749', '');">â??Using DataDirect Bulk Loadâ??</a></span> for more information.</div> <div class="gutter_text_right"><a name="1175248">Valid Values</a></div> <div class="Body"><a name="1175249">0 | 1</a></div> <div class="Body"><a name="1286775">If set to </a><span class="Syntax">0 </span>(Serial), multiple batches associated with a bulk load operation are processed one at a time.</div> <div class="Body"><a name="1175250">If set to </a><span class="Syntax">1</span> (Parallel), multiple batches associated with a bulk load operation are processed in parallel. The order in which the batches are processed can vary. </div> <div class="gutter_text_right"><a name="1175251">Default</a></div> <div class="Body"><span class="Syntax"><a name="1175252">1</a></span> (Parallel) </div> <div class="gutter_text_right"><a name="1224057">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1224062">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1175525">Bulk Load Poll Interval</a></div> <div class="gutter_text_right"><a name="1236792">Attribute</a></div> <div class="Body_attr"><a name="1236793">BulkLoadPollInterval (BLPI)</a></div> <div class="gutter_text_right"><a name="1175526">Description</a></div> <div class="Body"><a name="1175527">Specifies the number of seconds the driver waits to request bulk operation status. This </a>interval is used by the driver the first time it requests status and for all subsequent status requests. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.6.html#109749', '');">â??Using DataDirect Bulk Loadâ??</a></span> for more information.</div> <div class="gutter_text_right"><a name="1175528">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="1175692">x</a></span></div> <div class="Body"><a name="1175693">where </a><span class="EquationVariables">x</span> is a positive integer that represents the number of seconds the driver waits before requesting bulk operation status. </div> <div class="gutter_text_right"><a name="1175532">Default</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="1175533">10</a></span></div> <div class="gutter_text_right"><a name="1224172">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1224177">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1167988">Bulk Load Threshold</a></div> <div class="gutter_text_right"><a name="1236937">Attribute</a></div> <div class="Body_attr"><a name="1236938">BulkLoadThreshold (BLTH)</a></div> <div class="gutter_text_right"><a name="1236939">Description</a></div> <div class="Body"><a name="1206893">Determines when the driver uses bulk load for insert, update, delete, or batch operations. If </a>the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1184416', '');">Enable Bulk Load</a></span> option is set to <span class="Syntax">True</span> and the number of rows affected by an insert, update, delete, or batch operation exceeds the threshold specified by this option, the driver uses the Salesforce Bulk API to perform the operation.</div> <div class="Body"><a name="1173540">NOTES: </a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1173556">If the </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1184416', '');">Enable Bulk Load</a></span> option is set to <span class="Syntax">false</span>, this option is ignored.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1173575">Do not set the Bulk Load Threshold option to a value greater than the Web service call </a>limit set by the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#993902', '');">Statement Call Limit</a></span> option. If the value set for Bulk Load Threshold is greater than the value of Statement Call Limit, the driver would never use the Salesforce Bulk API because the Web service call limit is reached before the driver reaches the threshold to switch to the Salesforce Bulk API.</div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="1172673">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1172674">0</a></span> | <span class="EquationVariables">x</span></div> <div class="Body"><a name="1172675">where </a><span class="EquationVariables">x</span> is a positive integer that represents a threshold (number of rows). </div> <div class="Body"><a name="1172717">If set to </a><span class="Syntax">0</span>, the driver always uses bulk load to execute insert, update, delete, or batch operations.</div> <div class="Body"><a name="1172731">If set to </a><span class="EquationVariables">x</span>, the driver only uses bulk load if the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1184416', '');">Enable Bulk Load</a></span> option is set to a value of True and the number of rows to be updated by an insert, update, delete, or batch operation exceeds the threshold. If the operation times out, the driver returns an error.</div> <div class="gutter_text_right"><a name="1172676">Default</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="1172677">4000</a></span></div> <div class="gutter_text_right"><a name="1224190">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1224195">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1224254">Bulk Load Timeout</a></div> <div class="gutter_text_right"><a name="1236748">Attribute</a></div> <div class="Body_attr"><a name="1236749">BulkLoadTimeout (BLTO)</a></div> <div class="gutter_text_right"><a name="1224255">Description</a></div> <div class="Body"><a name="1224256">The time, in seconds, that the driver waits for a Salesforce bulk job to complete. A value of </a>zero means there is no timeout.</div> <div class="gutter_text_right"><a name="1224257">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="1224258">x</a></span></div> <div class="Body"><a name="1224259">where </a><span class="EquationVariables">x</span> is a positive integer that represents a number of seconds the driver waits before requesting bulk operation status. </div> <div class="gutter_text_right"><a name="1224260">Default</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="1224261">0</a></span></div> <div class="gutter_text_right"><a name="1224264">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1224269">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="982269">Config Options</a></div> <div class="gutter_text_right"><a name="1237663">Attribute</a></div> <div class="Body_attr"><a name="1237664">ConfigOptions (CO)</a></div> <div class="gutter_text_right"><a name="1237665">Description</a></div> <div class="Body"><a name="982271">Determines how the embedded database and the mapping of the remote data model to the </a>relational data model is configured, customized, and updated. </div> <div class="Body"><a name="1044861">NOTE: This option is primarily used for initial configuration of the driver for a particular user. </a>It is not intended for use with every connection. By default, the driver configures itself and this option is normally not needed. If Config Options is specified on a connection after the initial configuration, the values specified for Config Options must match the values specified for the initial configuration. The preferred method for setting the configuration options for a particular user is through the database configuration file. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.13.html#1349232', '');">â??Database Configuration Fileâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="982272">Valid Values</a></div> <div class="syntax_first"><a name="1022885">(</a><span class="EquationVariables">key=value</span>[;<span class="EquationVariables"> key=value</span>])</div> <div class="Body"><a name="982274">where </a><span class="EquationVariables">key</span> is one of the following values: <span class="Syntax">AuditColumns</span>, <span class="Syntax">CustomSuffix</span>, <span class="Syntax">MapSystemColumnNames</span>, <span class="Syntax">NumberFieldMapping</span>, or <span class="Syntax">UppercaseIdentifiers</span>. </div> <div class="Body"><a name="1288766">The value is a set of key value pairs separated by a semicolon (;). The value must be </a>enclosed in parentheses. For example:</div> <div class="syntax_first"><span class="Syntax"><a name="1288767">(AuditColumns=AuditOnly;UppercaseIdentifiers=false)</a></span></div> <div class="Body"><span class="Action_bold"><a name="1288768">AuditColumns</a></span>: Determines whether the driver includes audit fields, which Salesforce adds to all objects defined in a Salesforce instance, as table columns when it defines the remote data model to relational table mapping.</div> <div class="Body"><a name="1170798">The audit columns added by Salesforce are:</a></div> <div class="Body"><a name="1170799">IsDeleted</a><br />CreatedById<br />CreatedDate<br />LastModifiedById<br />LastModifiedDate<br />SystemModestamp</div> <div class="Body"><a name="1170800">Salesforce also adds the field MasterRecordId.</a></div> <div class="Body"><a name="1170823">Valid values for AuditColumns are:</a></div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1170804">Value</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1170806">Description</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1170808">All</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1170810">The driver includes the all of the audit columns and the master record id </a>column in its table definitions.</div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1170812">AuditOnly</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1170814">The driver adds only the audit columns in its table definitions.</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1170816">MasterOnly</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1170818">The driver adds only the MasterRecordId column in its table definitions.</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1170820">None</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1170822">The driver does not add the audit columns or the MasterRecordId column </a>in its table definitions.</div> </td> </tr> </table> <div class="Body"><a name="1170824">The default value for AuditColumns is </a><span class="Syntax">None</span>.</div> <div class="Body"><a name="1206983">In a typical Salesforce instance, not all users are granted access to the Audit or </a>MasterRecordId columns. If AuditColumns is set to a value other than <span class="Syntax">None</span> and the driver cannot include the columns requested, the connection fails and the driver generates a SQLException with a SQLState of 08001.</div> <div class="Body"><span class="Action_bold"><a name="1170825">CustomSuffix </a></span>(Custom objects and fields only): Determines whether the driver includes or strips the "__c" suffix from the table and column names when mapping the remote data model to the relational data model. Salesforce adds the suffix to all custom objects and fields. </div> <div class="Body"><a name="1170839">Valid values for CustomSuffix are:</a></div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1170828">Value </a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1170830">Description</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1170832">Include</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1170834">The driver includes the "__c" suffix.</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1170836">Strip</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1170838">The driver strips the "__c" suffix.</a></div> </td> </tr> </table> <div class="Body"><a name="1170844">The default value for CustomSuffix is </a><span class="Syntax">Strip</span>.</div> <div class="Body"><span class="Action_bold"><a name="1207226">MapSystemColumnNames</a></span>: Determines how the driver maps Salesforce system columns. Valid values for MapSystemColumnNames are:</div> <table class="Format_B" style="margin-top: 0.0pt;" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1207874">Value </a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1207876">Description</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; margin-bottom: 3.0pt; margin-top: 3.0pt; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1207878">0</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1207880">The driver does not change the names of the Salesforce system </a>columns. </div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1207882">1</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1207884">The driver changes the names of the Salesforce system columns as </a>described in the following table:</div> <div class="table_text"><span class="Action_bold"><a name="1208457">Field Name</a></span> <span class="Action_bold">Mapped Name</span></div> <div class="table_text"><a name="1531102">Id</a> ROWID<br />Name SYS_NAME<br />IsDeleted SYS_ISDELETED<br />CreatedDate SYS_CREATEDDATE<br />CreatedById SYS_CREATEDBYID<br />LastModifiedDate SYS_LASTMODIFIEDDATE<br />LastModifiedId SYS_LASTMODIFIEDID<br />SystemModstamp SYS_SYSTEMMODSTAMP<br />LastActivityDate SYS_LASTACTIVITYDATE<br />OwnerId SYS_OWNERID</div> </td> </tr> </table> <div class="Body"><a name="1052675">The default value for MapSystemColumnNames is </a><span class="Syntax">1</span>.</div> <div class="Body"><span class="Action_bold"><a name="1209038">NumberFieldMapping</a></span>: Defines how the driver maps fields defined as NUMBER in Salesforce. The Salesforce API uses DOUBLE values to transfer data to and from NUMBER fields, which can cause problems when the precision of the NUMBER field is greater than the precision of a DOUBLE value. Rounding can occur when converting large values to and from DOUBLE. By default, the driver maps smaller fields (precision of 9 or less) to the INTEGER SQL type when the scale of the NUMBER field is 0 and maps all other NUMBER fields to the DOUBLE SQL type to match the type that Salesforce transfers the value to or from the driver. This key can be used to direct the driver to map all NUMBER fields to DOUBLE regardless of the precision of the field.</div> <div class="Body"><a name="1209052">Valid values for NumberFieldMapping are:</a></div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1209041">Value </a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1209043">Description</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1290063">1</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1290065">The driver maps NUMBER fields with a precision of 9 or less and a scale of 0 </a>to the INTEGER SQL type and maps all other NUMBER fields to the DOUBLE SQL type.</div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; margin-bottom: 3.0pt; margin-top: 3.0pt; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1209045">2</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1209047">The driver maps NUMBER fields to the DOUBLE SQL type. </a></div> </td> </tr> </table> <div class="Body"><a name="1209053">The default value for NumberFieldMapping is </a><span class="Syntax">1</span>.</div> <div class="Body"><span class="Action_bold"><a name="1052838">UppercaseIdentifiers</a></span>: Defines how the driver maps identifiers. By default, the driver maps all identifier names to uppercase.</div> <div class="Body"><a name="1207185">NOTE: Do not change the value of UppercaseIdentifiers unless the data source you are </a>connecting to has objects with names that differ only by case.</div> <div class="Body"><a name="1052813">Valid values for UppercaseIdentifiers are:</a></div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1052802">Value </a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1052804">Description</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; margin-bottom: 3.0pt; margin-top: 3.0pt; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1052806">true</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1052808">The driver maps identifiers to uppercase. </a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Syntax"><a name="1052810">false</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1053442">The driver maps identifiers to the mixed case name of the object being </a>mapped. If mixed case identifiers are used, SQL statements must enclose those identifiers in double quotes, and the case of the identifier, must exactly match the case of the identifier name.</div> <div class="table_text"><a name="1053443">For example, if UppercaseIdentifiers=false, to query the Account table </a>you specify:</div> <div class="table_text_syntax"><a name="1053444">SELECT "id", "name" FROM "Account"</a></div> </td> </tr> </table> <div class="Body"><a name="1037599">The default value for UppercaseIdentifiers is </a><span class="Syntax">true</span>.</div> <div class="gutter_text_right"><a name="1207206">Default</a></div> <div class="syntax_first"><a name="1207199">AuditColumns=none;CustomSuffix=strip;MapSystemColumnNames=1;</a><br />NumberFieldMapping=1;UppercaseIdentifiers=true</div> <div class="gutter_text_right"><a name="1437263">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1437268">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1297442">Connection Pooling</a></div> <div class="gutter_text_right"><a name="1297443">Attribute</a></div> <div class="Body_attr"><a name="1297445">Pooling (POOL)</a></div> <div class="gutter_text_right"><a name="1297446">Description</a></div> <div class="Body"><a name="1650924">Specifies whether to use the driverâ??s connection pooling.</a></div> <div class="Body"><a name="1650925">NOTE: The application must be thread-enabled to use connection pooling.</a></div> <div class="Body"><a name="1297454">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.05.html#1058047', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="1297456">Valid Values</a></div> <div class="Body"><a name="1650929">0 | 1</a></div> <div class="Body"><a name="1650930">If set to 1 (Enabled), the driver uses connection pooling. </a></div> <div class="Body"><a name="1650931">If set to 0 (Disabled), the driver does not use connection pooling.</a></div> <div class="gutter_text_right"><a name="1297463">Default</a></div> <div class="Body"><a name="1297465">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="1297466">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229238', '');" name="1297470">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="1288340">Connection Reset</a></div> <div class="gutter_text_right"><a name="1288341">Attribute</a></div> <div class="Body_attr"><a name="1288343">ConnectionReset (CR)</a></div> <div class="gutter_text_right"><a name="1288344">Description</a></div> <div class="Body"><a name="1650935">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="1288351">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.05.html#1058047', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="1288353">Valid Values</a></div> <div class="Body"><a name="1650939">0 | 1</a></div> <div class="Body"><a name="1650940">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="1650941">If set to 0 (Disabled), the state of connections is not reset.</a></div> <div class="gutter_text_right"><a name="1288360">Default</a></div> <div class="Body"><a name="1288362">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="1288363">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229238', '');" name="1288368">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="1170916">Create Database</a></div> <div class="gutter_text_right"><a name="1239242">Attribute</a></div> <div class="Body_attr"><a name="1239243">CreateDB (CDB)</a></div> <div class="gutter_text_right"><a name="1170917">Description</a></div> <div class="Body"><a name="1170918">Determines whether the driver creates a new embedded database when establishing the </a>connection. </div> <div class="gutter_text_right"><a name="1170919">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1170920">0 | 1</a></span> |<span class="Syntax"> 2</span></div> <div class="Body"><a name="1291082">If set to </a><span class="Syntax">0</span> <span class="Syntax">(No)</span>, the driver uses the current embedded database specified by DatabaseName. If one does not exist, the connection fails.</div> <div class="Body"><a name="1170928">If set to </a><span class="Syntax">1</span> <span class="Syntax">(ForceNew)</span>, the driver deletes the current embedded database specified by <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1061996', '');">Database</a></span> and creates a new one at the same location. </div> <div class="Body"><a name="1170931">WARNING: This causes all views, data caches, and map customizations defined in the </a>current database to be lost. </div> <div class="Body"><a name="1170938">If set to </a><span class="Syntax">2</span> (<span class="Syntax">NotExist</span>), the driver uses the current embedded database specified by DatabaseName. If one does not exist, the driver creates one.</div> <div class="gutter_text_right"><a name="1170946">Default</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="1170947">2</a></span> (<span class="Syntax">NotExist)</span></div> <div class="gutter_text_right"><a name="1239370">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1239375">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1329246">Data Source Name</a></div> <div class="gutter_text_right"><a name="1329247">Attribute</a></div> <div class="Body_attr"><a name="1329249">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="1329250">Description</a></div> <div class="Body"><a name="1650945">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="1329255">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="1650949">string</a></span> </div> <div class="Body"><a name="1650950">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="1329261">Default</a></div> <div class="Body"><a name="1329263">None</a></div> <div class="gutter_text_right"><a name="1329264">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228785', '');" name="1329269">General tab</a></span></div> <div class="head_2_no_TOC"><a name="1061996">Database</a></div> <div class="gutter_text_right"><a name="1239274">Attribute</a></div> <div class="Body_attr"><a name="1239275">Database (DBN)</a></div> <div class="gutter_text_right"><a name="1198972">Description</a></div> <div class="Body"><a name="1179281">Specifies the file name prefix the driver uses to create or locate the set of files that define </a>the Object mapping and the embedded database used by the connection. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.07.html#1348631', '');">â??Mapping Objects to Tablesâ??</a></span> for an explanation of embedded database.</div> <div class="gutter_text_right"><a name="1179285">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="1179286">prefix </a></span>|<span class="EquationVariables"> path+prefix</span></div> <div class="Body"><a name="1179287">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="1179288">prefix</a></span> is the file name prefix for the embedded database. For example, if Database is set to a value of <span class="Syntax">JohnQPublic</span>, the embedded database files that are created or loaded have the form <span class="Syntax">johnqpublic.</span><span class="EquationVariables">xxx</span>.</div> <div class="Body"><span class="EquationVariables"><a name="1179289">path+prefix</a></span> is a relative or absolute path appended to the file name prefix. The path defines the directory the driver uses to store the newly created database files or locate the existing database files. For example, if Database is set to a value of <span class="Syntax">C:\data\db\johnqpublic</span>, the driver either creates or looks for the database johnqpublic.xxx in the directory <span class="Syntax">C:\data\db</span>. If you do not specify a path, the current working directory is used.</div> <div class="gutter_text_right"><a name="1179290">Default</a></div> <div class="Body"><a name="1179291">The user ID specified for the connection.</a></div> <div class="Body"><a name="1179292">NOTES: </a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1645033">The driver parses the User ID value and removes all non-alphanumeric characters. For </a>example, if User ID is specified as <span class="Syntax">John.Q.Public</span>, the value used for Database is <span class="Syntax">JohnQPublic</span>.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1645060">When SQL Engine Mode is set to Server, the </a><span class="EquationVariables">path+prefix</span> value overrides the value specified by the Server DB Directory configuration setting (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.16.html#1579806', '');">â??Configuring Server Modeâ??</a></span>).</div> </td> </tr> </table> </div> <div class="head_2_no_TOC"><a name="1254997">Description</a></div> <div class="gutter_text_right"><a name="1254998">Attribute</a></div> <div class="Body_attr"><a name="1255000">Description (n/a)</a></div> <div class="gutter_text_right"><a name="1255001">Description</a></div> <div class="Body"><a name="1650954">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="1255006">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="1650958">string</a></span> </div> <div class="Body"><a name="1650959">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="1255012">Default</a></div> <div class="Body"><a name="1255013">None</a></div> <div class="gutter_text_right"><a name="1255014">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228785', '');" name="1255019">General tab</a></span></div> <div class="head_2_no_TOC"><a name="1184416">Enable Bulk Load</a></div> <div class="gutter_text_right"><a name="1239584">Attribute</a></div> <div class="Body_attr"><a name="1239585">EnableBulkLoad (EBL)</a></div> <div class="gutter_text_right"><a name="1239586">Description</a></div> <div class="Body"><a name="1272233">Specifies whether the driver can use the bulk load protocol for insert, update, delete, and </a>batch operations. Bulk load can reduce the number of Web service calls used to execute a statement when compared to statements that are executed individually and may improve performance. Whether the driver actually uses bulk load is determined by the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1167988', '');">Bulk Load Threshold</a></span> connection option.</div> <div class="gutter_text_right"><a name="1184422">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1184423">True</a></span> | <span class="Syntax">False</span></div> <div class="Body"><a name="1184424">If set to </a><span class="Syntax">True</span>, the driver can use the bulk load protocol for insert, update, delete, and batch operations.</div> <div class="Body"><a name="1184425">If set to </a><span class="Syntax">False</span>, the driver cannot use the bulk load protocol for insert, update, delete, and batch operations.</div> <div class="gutter_text_right"><a name="1184426">Default</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="1184427">False</a></span></div> <div class="gutter_text_right"><a name="1228616">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1228620">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1225619">Extended Options</a></div> <div class="gutter_text_right"><a name="1225620">Attribute</a></div> <div class="Body_attr"><a name="1225622">ExtendedOptions (XO)</a></div> <div class="gutter_text_right"><a name="1225623">Description</a></div> <div class="Body"><a name="1240505">A semi-colon separated list of connection options and their values. Use this connection </a>option to set the value of hidden connection options that are provided by Progress customer support. You can include any valid connection option in the Extended Options string. </div> <div class="Body"><a name="1438171">If the Extended Options string contains option values that are also set in the setup dialog or </a>data source, the values of the options specified in the Extended Options string take precedence.</div> <div class="Body"><a name="1240509">Options, either hidden or exposed, that are specified on a connection string override any </a>option value specified in the Extended Options string.</div> <div class="Body"><a name="1240511">Do not specify the Extended Options connection option in a connection string, or the driver </a>will return an error. Instead, applications should specify the individual hidden connection options in the connection string.</div> <div class="gutter_text_right"><a name="1225628">Valid Values</a></div> <div class="Body"><a name="1225631">A string consisting of one or more key=value pairs, for example, </a>HostName=<span class="Syntax">login.salesforce.com</span>;<span class="EquationVariables">HiddenOption1=value</span>[;<span class="EquationVariables">HiddenOption2=value</span>;]</div> <div class="gutter_text_right"><a name="1225635"> Default</a></div> <div class="Body"><a name="1225637">Empty string</a></div> <div class="gutter_text_right"><a name="1225638">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1225643">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1056795">Fetch Size</a></div> <div class="gutter_text_right"><a name="1240494">Attribute</a></div> <div class="Body_attr"><a name="1240495">FetchSize (FS)</a></div> <div class="gutter_text_right"><a name="1056896">Description</a></div> <div class="Body"><a name="1056898">The number of rows that the driver processes before returning data to the application. </a>Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory.</div> <div class="Body"><a name="1057369">FetchSize is related to, but different from, </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1045595', '');">WSFetch Size</a></span>. WS Fetch Size specifies the number of rows of raw data that the driver fetches from the remote data source, while Fetch Size specifies how many of these raw data rows the driver processes before returning data to the application. Processing the data includes converting from the remote data source data type to the driver SQL data type used by the application. If Fetch Size is greater than WS Fetch Size, the driver makes multiple round trips to the data source to get the requested number of rows before returning control to the application.</div> <div class="gutter_text_right"><a name="1056899">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1056900">0</a></span> | <span class="EquationVariables">x</span></div> <div class="Body"><a name="1057668">where </a><span class="EquationVariables">x</span> is a positive integer that specifies the number of rows that the driver processes before returning data to the application.</div> <div class="Body"><a name="1056901">If set to </a><span class="Syntax">0</span>, the driver fetches and processes all of the rows of the result before returning control to the application.</div> <div class="gutter_text_right"><a name="1056903">Default</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="1056904">100</a></span></div> <div class="gutter_text_right"><a name="1354123">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1354128">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1568552">Field Delimiter</a></div> <div class="gutter_text_right"><a name="1568553">Attribute</a></div> <div class="Body_attr"><a name="1568555">BulkLoadFieldDelimiter (BLFD)</a></div> <div class="gutter_text_right"><a name="1568556">Description</a></div> <div class="Body"><a name="1651078">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="1568561">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="1651071">x</a></span></div> <div class="Body"><a name="1651072">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="1651073">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="1651074">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="1568569">Default</a></div> <div class="Body"><a name="1568570">None</a></div> <div class="gutter_text_right"><a name="1568571">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1568576">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1225847">Host Name</a></div> <div class="gutter_text_right"><a name="1225848">Attribute</a></div> <div class="Body_attr"><a name="1225850">HostName (HOST)</a></div> <div class="gutter_text_right"><a name="1225851">Description</a></div> <div class="Body"><a name="1225854">The base Salesforce URL to use for logging in. If you are logging into a Salesforce instance </a>other than the default, you must provide the root of the Salesforce URL. </div> <div class="gutter_text_right"><a name="1225856">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="1225859">url</a></span></div> <div class="Body"><a name="1225860">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="1225861">url</a></span> is the is the root of the Salesforce URL to which you want to connect.</div> <div class="gutter_text_right"><a name="1251602">Example</a></div> <div class="Body"><a name="1251603">Suppose you have a Salesforce instance that is configured with a production instance and a </a>sandbox instance. You can specify <span class="Syntax">login.salesforce.com</span> as the value for the HostName attribute to connect to the production instance or <span class="Syntax">test.salesforce.com</span> to connect to the sandbox instance:</div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1251606">Salesforce Instance</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="1251608">URL</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1251610">Production</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1251612">login.salesforce.com</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1251614">Sandbox</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1251616">test.salesforce.com</a></div> </td> </tr> </table> <div class="gutter_text_right"><a name="1251617">Default</a></div> <div class="Body"><a name="1251618">None if you use the default Salesforce URL, login.salesforce.com</a></div> <div class="gutter_text_right"><a name="1225876">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228785', '');" name="1225881">General tab</a></span></div> <div class="head_2_no_TOC"><a name="1043315">Initialization String</a></div> <div class="gutter_text_right"><a name="1240784">Attribute</a></div> <div class="Body_attr"><a name="1240786">InitializationString (IS)</a></div> <div class="gutter_text_right"><a name="1038152">Description</a></div> <div class="Body"><a name="1038153">One or multiple SQL commands to be executed by the driver after it has established the </a>connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver returns an error indicating which SQL command or commands failed.</div> <div class="gutter_text_right"><a name="1038154">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="1038155">string</a></span></div> <div class="Body"><a name="1038156">where </a><span class="EquationVariables">string</span> is one or multiple SQL commands.</div> <div class="Body"><a name="1038157">Multiple commands must be separated by semicolons. In addition, if this option is specified </a>in a connection URL, the entire value must be enclosed in parentheses when multiple commands are specified. </div> <div class="gutter_text_right"><a name="1545658">Example</a></div> <div class="Body"><a name="1545726">Because fetching metadata and generating mapping files can significantly increase the time </a>it takes to connect to Salesforce, the driver caches this information on the client the first time the driver connects on behalf of each user. The cached metadata is used in subsequent connections made by the user instead of re-fetching the metadata from Salesforce. To force the driver to re-fetch the metadata information for a connection, use the InitializationString property to pass the REFRESH SCHEMA SFORCE command in the connection URL. For example:</div> <div class="syntax_first"><a name="1545727">DSN=Salesforce;UID={test@abccorp.com};PWD=secret;InitializationString=(REFRESH </a>SCHEMA SFORCE)</div> <div class="gutter_text_right"><a name="1038161">Default</a></div> <div class="Body"><a name="1038162">None</a></div> <div class="gutter_text_right"><a name="1293027">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1293032">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1226399">JVM Arguments</a></div> <div class="gutter_text_right"><a name="1226400">Attribute</a></div> <div class="Body_attr"><a name="1226402">JVMArgs (JVMA)</a></div> <div class="gutter_text_right"><a name="1226403">Description</a></div> <div class="Body"><a name="1226406">A string that contains the arguments that are passed to the JVM that the driver is starting. </a>The location of the JVM must be specified on the driver library path. For information on setting the location of the JVM in your environment, see:</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'quikstart.04.2.html#117365', '');" name="1487126">â??Setting the Library Path Environment Variable (Salesforce Driver on Windows)â??</a></span></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'quikstart.04.3.html#117559', '');" name="1487330">â??Setting the Library Path Environment Variable (Salesforce Driver on UNIX/Linux)â??</a></span>).</div> </td> </tr> </table> </div> <div class="Body"><a name="1486786">When specifying the heap size for the JVM, note that the JVM tries to allocate the heap </a>memory as a single contiguous range of addresses in the applicationâ??s memory address space. If the application's address space is fragmented so that there is no contiguous range of addresses big enough for the amount of memory specified for the JVM, the driver fails to load, because the JVM cannot allocate its heap. This situation is typically encountered only with 32-bit applications, which have a much smaller application address space. If you encounter problems with loading the driver in an application, try reducing the amount of memory requested for the JVM heap. If possible, switch to a 64-bit version of the application.</div> <div class="gutter_text_right"><a name="1226408">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="1226411">string</a></span></div> <div class="Body"><a name="1226412">where the string contains arguments that are defined by the JVM. Values that include </a>special characters or spaces must be enclosed in curly braces { } when used in a connection string.</div> <div class="gutter_text_right"><a name="1241323">Examples</a></div> <div class="Body"><a name="1241347">To set the heap size used by the JVM to 256 MB and the http proxy information, specify:</a></div> <div class="syntax_first"><a name="1241348">{-Xmx256m -Dhttp.proxyHost=johndoe -Dhttp.proxyPort=808}</a></div> <div class="Body"><a name="1241416">To set the heap size to 256 MB and configure the JVM for remote debugging, specify:</a></div> <div class="syntax_first"><a name="1241441">{-Xmx256m </a></div> <div class="syntax_first"><a name="1241442">-Xrunjdwp:transport=dt_socket, address=9003,server=y,suspend=n -Xdebug}</a></div> <div class="gutter_text_right"><a name="1226426">Default</a></div> <div class="Body"><a name="1226427"> </a><span class="Syntax">-Xmx256m</span></div> <div class="gutter_text_right"><a name="1226428">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228785', '');" name="1226433">General tab</a></span></div> <div class="head_2_no_TOC"><a name="1226669">JVM Classpath</a></div> <div class="gutter_text_right"><a name="1226670">Attribute</a></div> <div class="Body_attr"><a name="1226671">JVMClasspath (JVMC)</a></div> <div class="gutter_text_right"><a name="1226672">Description</a></div> <div class="Body"><a name="1241741">Specifies the CLASSPATH for the Java Virtual Machine (JVM) used by the driver. The </a>CLASSPATH is the search string the JVM uses to locate the Java jar files the driver needs. </div> <div class="gutter_text_right"><a name="1226674">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="1226675">string</a></span></div> <div class="Body"><a name="1242072">where the string specifies the CLASSPATH. Separate multiple jar files by a semi-colon on </a>Windows platforms and by a colon on Linux and UNIX platforms. CLASSPATH values with multiple jar files must be enclosed in curly braces { } when used in a connection string.</div> <div class="gutter_text_right"><a name="1356252">Example</a></div> <div class="Body"><a name="1356253">On Windows:</a></div> <div class="syntax_first"><a name="1356326">{.;c:\</a><span class="EquationVariables">install_dir</span>\java\lib\</div> <div class="syntax"><a name="1567861">}</a></div> <div class="Body"><a name="1356271">On UNIX:</a></div> <div class="syntax_first"><a name="1356296">{.:/home/user1/</a><span class="EquationVariables">install_dir</span>/java/lib/sforce.jar}</div> <div class="gutter_text_right"><a name="1242075">Default</a></div> <div class="Body"><span class="Emphasis"><a name="1226680">install_dir</a></span>\java\lib\sforce.jar</div> <div class="gutter_text_right"><a name="1226681">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228785', '');" name="1226686">General tab</a></span></div> <div class="head_2_no_TOC"><a name="1226747">LoadBalance Timeout</a></div> <div class="gutter_text_right"><a name="1226748">Attribute</a></div> <div class="Body_attr"><a name="1226750">LoadBalanceTimeout (LBT)</a></div> <div class="gutter_text_right"><a name="1226751">Description</a></div> <div class="Body"><a name="1650963">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="1650964">NOTE: The Min Pool Size option may cause some connections to ignore this value.</a></div> <div class="Body"><a name="1226759">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.05.html#1058047', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="1226761">Valid Values</a></div> <div class="Body"><a name="1650968">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="1650969">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="1650970">If set to 0, inactive connections are kept open.</a></div> <div class="Body"><a name="1650971">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="1226769">Default</a></div> <div class="Body"><a name="1226771">0</a></div> <div class="gutter_text_right"><a name="1226772">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229238', '');" name="1226777">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="1072430">Log Config File</a></div> <div class="gutter_text_right"><a name="1242122">Attribute</a></div> <div class="Body_attr"><a name="1242124">LogConfigFile (LCF)</a></div> <div class="gutter_text_right"><a name="1072431">Description</a></div> <div class="Body"><a name="1445507">Specifies the filename of the configuration file used to initialize the driver logging </a>mechanism.</div> <div class="Body"><a name="1445508">If the driver cannot locate the specified file when establishing the connection, the </a>connection fails and the driver returns an error.</div> <div class="gutter_text_right"><a name="1072434"> 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="1072435">string</a></span></div> <div class="Body"><a name="1096044">where </a><span class="EquationVariables">string</span> is the relative or fully qualified path of the configuration file used to initialize the driver logging mechanism. If the specified file does not exist, the driver continues searching for an appropriate configuration file as described in "Using Logging" in the <span class="Emphasis">DataDirect Connect Series for ODBC Reference</span>.</div> <div class="gutter_text_right"><a name="1096051">Default</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="1072438">Empty string</a></span></div> <div class="gutter_text_right"><a name="1227045">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1227049">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1284893">Login Timeout</a></div> <div class="gutter_text_right"><a name="1284894">Attribute</a></div> <div class="Body_attr"><a name="1284896">LoginTimeout (LT)</a></div> <div class="gutter_text_right"><a name="1284897">Description</a></div> <div class="Body"><a name="1650975">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="1284902">Valid Values</a></div> <div class="Body"><a name="1650979">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="1650980">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="1650981">If set to 0, inactive connections are kept open.</a></div> <div class="Body"><a name="1650982">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="1284911">Default</a></div> <div class="Body" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><a name="1285463">15 </a></div> <div class="gutter_text_right"><a name="1284916">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1284920">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1298582">Logon Domain</a></div> <div class="gutter_text_right"><a name="1298583">Attribute</a></div> <div class="Body_attr"><a name="1298585">LogonDomain (LD)</a></div> <div class="gutter_text_right"><a name="1298586">Description</a></div> <div class="Body"><a name="1298587">Specifies the domain part of the Salesforce user id. If Logon Domain is not an empty string, </a>the driver first appends the @ character to the end of the User Name value and then appends the value of Logon Domain. </div> <div class="gutter_text_right"><a name="1298588">Valid Values</a> </div> <div class="Body"><span class="EquationVariables"><a name="1298589">string</a></span></div> <div class="Body"><a name="1298590">where </a><span class="EquationVariables">string</span> is a valid user ID domain.</div> <div class="gutter_text_right"><a name="1353854">Default</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="1353855">Empty string</a></span></div> <div class="gutter_text_right"><a name="1353770">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229005', '');" name="1353774">Security tab</a></span></div> <div class="Body"><a name="1651067">Specifies how often, in seconds, the driver checks the maintenance thread. A single </a>maintenance thread is used to enforce minimum and maximum pool sizes in the connection pool. This option is not used as a runtime connection option, but does appear in the ODBC.INI section of the Registry and in the odbc.ini file.</div> <div class="head_2_no_TOC"><a name="1227266">Max Pool Size</a></div> <div class="gutter_text_right"><a name="1227267">Attribute</a></div> <div class="Body_attr"><a name="1227269">MaxPoolSize (MXPS)</a></div> <div class="gutter_text_right"><a name="1227270">Description</a></div> <div class="Body"><a name="1650986">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="1227277">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.05.html#1058047', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="1227279">Valid Values</a></div> <div class="Body"><a name="1650990">An integer from 1 to 65535</a></div> <div class="Body"><a name="1650991">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="1227285">Default</a></div> <div class="Body"><a name="1227287">100</a></div> <div class="gutter_text_right"><a name="1227288">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229238', '');" name="1227293">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="1227296">Min Pool Size</a></div> <div class="gutter_text_right"><a name="1227297">Attribute</a></div> <div class="Body_attr"><a name="1227299">MinPoolSize (MNPS)</a></div> <div class="gutter_text_right"><a name="1227300">Description</a></div> <div class="Body"><a name="1650995">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="1227307">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.05.html#1058047', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="1227309">Valid Values</a></div> <div class="Body"><a name="1650999">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="1651000">where </a><span class="EquationVariables">x</span> is an integer from 1 to 65535.</div> <div class="Body"><a name="1651001">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="1651002">If set to 0, no connections are opened in addition to the current existing connection.</a></div> <div class="gutter_text_right"><a name="1227317">Default</a></div> <div class="Body"><a name="1227319">0</a></div> <div class="gutter_text_right"><a name="1227320">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229238', '');" name="1227325">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="990089">Password</a></div> <div class="gutter_text_right"><a name="1242909">Attribute</a></div> <div class="Body_attr"><a name="1242911">Password (PWD)</a></div> <div class="gutter_text_right"><a name="990090">Description</a></div> <div class="Body"><a name="990091">Specifies the password to use to connect to your Salesforce instance. A password is </a>required. Contact your system administrator to obtain your password.</div> <div class="Body"><a name="1209449">IMPORTANT: Setting the password using a data source is not recommended. The data </a>source persists all options, including the Password option, in clear text.</div> <div class="gutter_text_right"><a name="990092">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="990093">password | password+securitytoken</a></span></div> <div class="Body"><a name="990094">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="1036262">password</a></span> is a valid password. The password is case-sensitive.</div> <div class="Body"><span class="EquationVariables"><a name="1036397">password+securitytoken</a></span> is a valid password appended by the security token required to connect to the Salesforce instance, for example, <span class="Syntax">secretXaBARTsLZReM4Px47qPLOS</span>, where <span class="Syntax">secret</span> is the password and the remainder of the value is the security token. Both the password and security token are case-sensitive.</div> <div class="Body"><a name="1171001">Optionally, you can specify the security token in the </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1185343', '');">Security Token</a></span> option. Do not specify the security token in both options.</div> <div class="gutter_text_right"><a name="990095">Default</a></div> <div class="Body"><a name="990096">None</a></div> <div class="gutter_text_right"><a name="1171006">See Also</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1185343', '');" name="1171010">â??Security Tokenâ??</a></span></div> <div class="head_2_no_TOC"><a name="1227698">Proxy Host</a></div> <div class="gutter_text_right"><a name="1243003">Attribute</a></div> <div class="Body_attr"><a name="1243005">ProxyHost (PXHN)</a></div> <div class="gutter_text_right"><a name="1227699">Description</a></div> <div class="Body"><a name="1227700">Specifies the Hostname and possibly the Domain of the Proxy Server. The value specified </a>can be a host name, a fully qualified domain name, or an IPv4 or IPv6 address.</div> <div class="gutter_text_right"><a name="1227701">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="1245707">server_name</a></span> | <span class="EquationVariables">IP_address</span></div> <div class="Body"><a name="1245708">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="1254488">server_name</a></span> is the name of the server or a fully qualified domain name to which you want to connect.</div> <div class="Body"><a name="1254698">The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two. </a>See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'usingproduct.05.05.html#107073', '');">â??Using IP Addressesâ??</a></span> for details about these formats.</div> <div class="gutter_text_right"><a name="1254489">Default</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="1254490">Empty string</a></span></div> <div class="gutter_text_right"><a name="1227714">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1309133', '');" name="1227718">Proxy tab</a></span></div> <div class="head_2_no_TOC"><a name="1227802">Proxy Password</a></div> <div class="gutter_text_right"><a name="1243035">Attribute</a></div> <div class="Body_attr"><a name="1243037">ProxyPassword (PXPW)</a></div> <div class="gutter_text_right"><a name="1227803">Description</a></div> <div class="Body"><a name="1227804">Specifies the password needed to connect to the Proxy Server.</a></div> <div class="gutter_text_right"><a name="1227805">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1227806">String</a></span></div> <div class="Body"><a name="1227807">Specifies the password to use to connect to the Proxy Server. Contact your system </a>administrator to obtain your password.</div> <div class="gutter_text_right"><a name="1227809">Default</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="1227810">Empty string</a></span></div> <div class="gutter_text_right"><a name="1227818">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1309133', '');" name="1227822">Proxy tab</a></span></div> <div class="head_2_no_TOC"><a name="1243243">Proxy Port</a></div> <div class="gutter_text_right"><a name="1243244">Attribute</a></div> <div class="Body_attr"><a name="1243245">ProxyPort (PXPT)</a></div> <div class="gutter_text_right"><a name="1243246">Description</a></div> <div class="Body"><a name="1243247">Specifies the port number where the Proxy Server is listening for HTTP and/or HTTPS </a>requests.</div> <div class="gutter_text_right"><a name="1243248">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="1246182">port_name</a></span></div> <div class="Body"><a name="1246183">where the </a><span class="EquationVariables">port_name</span> is the port number of the server listener. Check with your system administrator for the correct number.</div> <div class="gutter_text_right"><a name="1243252">Default</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="1243253">0</a></span></div> <div class="gutter_text_right"><a name="1243258">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1309133', '');" name="1243262">Proxy tab</a></span></div> <div class="head_2_no_TOC"><a name="1227867">Proxy User</a></div> <div class="gutter_text_right"><a name="1243049">Attribute</a></div> <div class="Body_attr"><a name="1243051">ProxyUser (PXUN)</a></div> <div class="gutter_text_right"><a name="1227868">Description</a></div> <div class="Body"><a name="1227869">Specifies the user name needed to connect to the Proxy Server.</a></div> <div class="gutter_text_right"><a name="1227870">Valid Values</a></div> <div class="Body"><a name="1246278">The default user ID that is used to connect to the Proxy Server. </a></div> <div class="gutter_text_right"><a name="1227874">Default</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="1227875">Empty string</a></span></div> <div class="gutter_text_right"><a name="1227883">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1309133', '');" name="1227887">Proxy tab</a></span></div> <div class="head_2_no_TOC"><a name="1242764">Read Only</a></div> <div class="gutter_text_right"><a name="1242875">Attribute</a></div> <div class="Body_attr"><a name="1242877">ReadOnly (RO)</a></div> <div class="gutter_text_right"><a name="1242765">Description</a></div> <div class="Body"><a name="1242766">Specifies whether the connection has read-only access to the data source.</a></div> <div class="gutter_text_right"><a name="1242767">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1242768">0</a></span> | <span class="Syntax">1</span></div> <div class="Body"><a name="1242769">If set to </a><span class="Syntax">1</span>, the connection has read-only access. The following commands are the only commands that you can use when a connection if read-only:</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="1242770">Call (if the procedure does not update data)</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="1242771">Explain Plan</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="1242772">Select (except Select Into)</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="1242776">Set Schema</a></div> </td> </tr> </table> </div> <div class="Body"><a name="1242777">The driver returns an error if any other command is executed.</a></div> <div class="Body"><a name="1242778">If set to </a><span class="Syntax">0</span>, the connection is opened for read/write access, and you can use all commands supported by the product.</div> <div class="gutter_text_right"><a name="1242780">Default</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="1242781">0</a></span></div> <div class="gutter_text_right"><a name="1242784">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1242788">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1568422">Record Delimiter</a></div> <div class="gutter_text_right"><a name="1568423">Attribute</a></div> <div class="Body_attr"><a name="1568425">BulkLoadRecordDelimiter (BLRD)</a></div> <div class="gutter_text_right"><a name="1568426">Description</a></div> <div class="Body"><a name="1651056">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="1568431">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="1651060">x</a></span></div> <div class="Body"><a name="1651061">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="1651062">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="1651063">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="1568439">Default</a></div> <div class="Body"><a name="1568440">None</a></div> <div class="gutter_text_right"><a name="1568441">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');" name="1568446">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="1243646">Refresh Dirty Cache</a></div> <div class="gutter_text_right"><a name="1243647">Attribute</a></div> <div class="Body_attr"><a name="1243648">RefreshDirtyCache (RDC)</a></div> <div class="gutter_text_right"><a name="1243649">Description</a></div> <div class="Body"><a name="1243650">Specifies whether the driver refreshes a dirty cache on the next fetch operation from the </a>cache. A cache is marked as dirty when a row is inserted into or deleted from a cached table or a row in the cached table is updated.</div> <div class="gutter_text_right"><a name="1243651">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1243652">1</a></span> | <span class="Syntax">0</span></div> <div class="Body"><a name="1243653">If set to </a><span class="Syntax">1 </span>(Enabled), a dirty cache is refreshed when the cache is referenced in a fetch operation. The cache state is set to initialized if the refresh succeeds.</div> <div class="Body"><a name="1243654">If set to </a><span class="Syntax">0 </span>(Disabled), a dirty cache is not refreshed when the cache is referenced in a fetch operation.</div> <div class="gutter_text_right"><a name="1243655">Default</a></div> <div class="Body"><span class="Syntax"><a name="1243656">1 </a></span>(Enabled)</div> <div class="gutter_text_right"><a name="1243659">See Also</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.08.html#1348673', '');" name="1243663">â??Refreshing Cache Dataâ??</a></span></div> <div class="gutter_text_right"><a name="1243664">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1243668">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1232781">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="1232782">Attribute</a></div> <div class="Body_attr"><a name="1232784">ReportCodepageConversionErrors (RCCE)</a></div> <div class="gutter_text_right"><a name="1232785">Description</a></div> <div class="Body"><a name="1651006">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="1651007">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="1232792">Valid Values</a></div> <div class="Body"><a name="1651011">0 | 1 | 2</a></div> <div class="Body"><a name="1651012">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="1651013">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="1651014">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="1232800">Default</a></div> <div class="Body"><a name="1232802">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="1232803">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1232808">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1185343">Security Token </a></div> <div class="gutter_text_right"><a name="1243978">Attribute</a></div> <div class="Body_attr"><a name="1243980">SecurityToken (STK)</a></div> <div class="gutter_text_right"><a name="1185344">Description</a></div> <div class="Body"><a name="1185345">Specifies the security token required to make a connection to a Salesforce instance that is </a>configured for a security token. If a security token is required and you do not supply one, the driver returns an error indicating that an invalid user or password was supplied. Contact your Salesforce administrator to find out if a security token is required.</div> <div class="Body"><a name="1209872">NOTE: When setting the security token using a data source on Windows, the Security </a>Token option is encrypted.</div> <div class="gutter_text_right"><a name="1185346">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="1185347">string</a></span></div> <div class="Body"><a name="1185348">where </a><span class="EquationVariables">string</span> is the value of the security token assigned to the user. </div> <div class="Body"><a name="1185352">Optionally, you can specify the security token in the </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#990089', '');">Password</a></span> option by appending the security token to the password, for example, <span class="Syntax">secretXaBARTsLZReM4Px47qPLOS</span>, where <span class="Syntax">secret</span> is the password and the remainder of the value is the security token. Do not specify the security token in both options.</div> <div class="gutter_text_right"><a name="1185353">Default</a></div> <div class="Body"><a name="1185354">Empty string</a></div> <div class="gutter_text_right"><a name="1228379">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229005', '');" name="1228383">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="1597132">Server Port Number</a></div> <div class="gutter_text_right"><a name="1597133">Attribute</a></div> <div class="Body_attr"><a name="1597135">ServerPortNumber (SPN)</a></div> <div class="gutter_text_right"><a name="1597136">Description</a></div> <div class="Body"><a name="1597137">Specifies a valid port on which the SQL engine listens for requests from the driver. </a></div> <div class="Body"><a name="1605758">NOTE: This option is ignored unless SQL Engine Mode is set to 1 (Server).</a></div> <div class="gutter_text_right"><a name="1597138">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="1597743">port_name</a></span></div> <div class="Body"><a name="1597744">where the </a><span class="EquationVariables">port_name</span> is the port number of the server listener. Check with your system administrator for the correct number.</div> <div class="gutter_text_right"><a name="1597142">Default</a></div> <div class="Body"><a name="1597143">19928</a></div> <div class="gutter_text_right"><a name="1597144">GUI Tab</a></div> <div class="Body"><a name="1597145">SQL Engine</a></div> <div class="head_2_no_TOC"><a name="1579541">SQL Engine Mode</a></div> <div class="gutter_text_right"><a name="1596223">Attribute</a></div> <div class="Body_attr"><a name="1596225">SQLEngineMode (SEM)</a></div> <div class="gutter_text_right"><a name="1579542">Description</a></div> <div class="Body"><a name="1579543">Specifies whether the driverâ??s SQL engine runs in the same 32-bit process as the driver </a>(direct mode) or runs in a process that is separate from the driver (server mode). You must be an administrator to modify the server mode configuration values, and to start or stop the SQL engine service.</div> <div class="gutter_text_right"><a name="1579544">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1579545">0 | 1 </a></span> </div> <div class="Body"><a name="1579546">If set to </a><span class="Syntax">0</span> (Direct), the SQL engine runs in direct mode. The driver and its SQL engine run in a single process within the same JVM.</div> <div class="Body"><a name="1579547">If set to </a><span class="Syntax">1</span> (Server), the SQL engine runs in server mode. The SQL engine operates in a separate process from the driver within its own JVM. You must start the SQL Engine service before using the driver (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.16.html#1579822', '');">â??Starting the SQL Engine Serverâ??</a></span> for more information). Multiple drivers on different clients can use the same service.</div> <div class="Body"><a name="1607637">IMPORTANT: Changes you make to the server mode configuration affect all DSNs sharing </a>the service. </div> <div class="gutter_text_right"><a name="1579548">Default</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="1579549">0 - Direct</a></span></div> <div class="gutter_text_right"><a name="1579550">GUI Tab</a></div> <div class="Body"><a name="1579551">SQL Engine</a></div> <div class="head_2_no_TOC"><a name="993902">Statement Call Limit</a></div> <div class="gutter_text_right"><a name="1243996">Attribute</a></div> <div class="Body_attr"><a name="1243997">StmtCallLimit (SCL)</a></div> <div class="gutter_text_right"><a name="1038502">Description</a></div> <div class="Body"><a name="1038483">Specifies the maximum number of Web service calls the driver can make when executing </a>any single SQL statement or metadata query.</div> <div class="gutter_text_right"><a name="1038598">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="1038619">0 | </a></span><span class="EquationVariables">x</span></div> <div class="Body"><a name="1038632">where </a><span class="EquationVariables">x</span> is a positive integer that defines the maximum number of Web service calls the driver can make when executing any single SQL statement or metadata query.</div> <div class="Body"><a name="1038636">If set to </a><span class="Syntax">0</span>, there is no limit.</div> <div class="Body"><a name="1038643">If set to </a><span class="EquationVariables">x</span>, the driver uses this value to set the maximum number of Web service calls on a single connection that can be made when executing a SQL statement. This limit can be overridden by changing the STMT_CALL_LIMIT session attribute using the ALTER SESSION statement. For example, the following statement sets the statement call limit to 10 Web service calls:</div> <div class="syntax_first"><a name="1080292">ALTER SESSION SET STMT_CALL_LIMIT=10</a></div> <div class="Body"><a name="1038647">If the Web service call limit is exceeded, the behavior of the driver depends on the value </a>specified for the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1038545', '');">Stmt Call Limit Behavior</a></span> option.</div> <div class="gutter_text_right"><a name="1038658">Default</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="1038663">20</a></span></div> <div class="gutter_text_right"><a name="1228398">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1312277', '');" name="1228402">Web Service tab</a></span></div> <div class="head_2_no_TOC"><a name="1038545">Stmt Call Limit Behavior</a></div> <div class="gutter_text_right"><a name="1244031">Attribute</a></div> <div class="Body_attr"><a name="1244032">StmtCallLimitBehavior (SCLB)</a></div> <div class="gutter_text_right"><a name="1038921">Description</a></div> <div class="Body"><a name="1038930">Specifies the behavior of the driver when the maximum Web service call limit specified by </a>the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#993902', '');">Statement Call Limit</a></span> option is exceeded.</div> <div class="gutter_text_right"><a name="1038972">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1038977">1 </a></span>| <span class="Syntax">2</span> </div> <div class="Body"><a name="1356738">If set to </a><span class="Syntax">1</span> <span class="Syntax">(ErrorAlways)</span>, the driver returns an error if the maximum Web service call limit is exceed.</div> <div class="Body"><a name="1353581">If set to </a><span class="Syntax">2</span> (<span class="Syntax">ReturnResults)</span>, the driver returns any partial results it received prior to the call limit being exceeded. The driver generates a warning that not all of the results were fetched.</div> <div class="gutter_text_right"><a name="1080380">Default</a></div> <div class="Body"><span class="Syntax"><a name="1080381">1 (ErrorAlways)</a></span></div> <div class="gutter_text_right"><a name="1228430">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1312277', '');" name="1228434">Web Service tab</a></span></div> <div class="head_2_no_TOC"><a name="1171082">Transaction Mode</a></div> <div class="gutter_text_right"><a name="1244060">Attribute</a></div> <div class="Body_attr"><a name="1244061">TransactionMode (TM)</a></div> <div class="gutter_text_right"><a name="1171089">Description</a></div> <div class="Body"><a name="1171090">Specifies how the driver handles manual transactions. </a></div> <div class="gutter_text_right"><a name="1171091">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="1171092">0 | 1 </a></span></div> <div class="table_text"><a name="1171104">If set to </a><span class="Syntax">1 - Ignore</span>, the data source does not support transactions and the driver always operates in auto-commit mode. Calls to set the driver to manual commit mode and to commit transactions are ignored. Calls to rollback a transaction cause the driver to return an error indicating that no transaction is started. Metadata indicates that the driver supports transactions and the ReadUncommitted transaction isolation level.</div> <div class="table_text"><a name="1244260">If set to </a><span class="Syntax">0</span> - <span class="Syntax">No Transactions</span>, the data source and the driver do not support transactions. Metadata indicates that the driver does not support transactions.</div> <div class="gutter_text_right"><a name="1171114">Default</a></div> <div class="Body"><span class="Syntax"><a name="1171115">0 (No Transactions)</a></span></div> <div class="gutter_text_right"><a name="1228526">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1228859', '');" name="1228530">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="1296699">User Name</a></div> <div class="gutter_text_right"><a name="1296700">Attribute</a></div> <div class="Body_attr"><a name="1296702">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="1296703">Description</a></div> <div class="Body"><a name="1651018">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="1296708">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="1651022">userid</a></span></div> <div class="Body"><a name="1651023">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="1296714">Default</a></div> <div class="Body"><a name="1296715">None</a></div> <div class="gutter_text_right"><a name="1354009">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229005', '');" name="1354013">Security tab</a></span></div> <div class="gutter_text_right"><a name="1353947">See Also</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1298582', '');" name="1353951">â??Logon Domainâ??</a></span></div> <div class="head_2_no_TOC"><a name="1045595">WSFetch Size</a></div> <div class="gutter_text_right"><a name="1244350">Attribute</a></div> <div class="Body_attr"><a name="1244351">WSFetchSize (WSFS)</a></div> <div class="gutter_text_right"><a name="1045600">Description</a></div> <div class="Body"><a name="1045641">Specifies the number of rows of data the driver attempts to fetch for each ODBC call. </a></div> <div class="gutter_text_right"><a name="1045643">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="1045655">0 | </a></span><span class="EquationVariables">x</span></div> <div class="Body"><a name="1045661">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 2000 that defines a number of rows.</div> <div class="Body"><a name="1045687">If set to </a><span class="Syntax">0</span>, the driver attempts to fetch up to a maximum of 2000 rows. This value typically provides the maximum throughput.</div> <div class="Body"><a name="1190921">If set to </a><span class="EquationVariables">x</span>, the driver attempts to fetch up to a maximum of the specified number of rows. Setting the value lower than 2000 can reduce the response time for returning the initial data. Consider using a smaller WSFetch Size for interactive applications only.</div> <div class="gutter_text_right"><a name="1353279">Default</a></div> <div class="Body"><span class="Syntax"><a name="1353280">0</a></span> (up to a maximum of 2000 rows)</div> <div class="gutter_text_right"><a name="1353281">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1312277', '');" name="1228572">Web Service tab</a></span></div> <div class="gutter_text_right"><a name="1058400">See Also</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1056795', '');" name="1058404">â??Fetch Sizeâ??</a></span></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1105606', '');" name="1211648">â??WSTimeoutâ??</a></span></div> <div class="head_2_no_TOC"><a name="1189539">WSRetry Count</a></div> <div class="gutter_text_right"><a name="1244372">Attribute</a></div> <div class="Body_attr"><a name="1244373">WSRetryCount (WSRC)</a></div> <div class="gutter_text_right"><a name="1189540">Description</a></div> <div class="Body"><a name="1189541">The number of times the driver retries a timed-out Select request. Insert, Update, and </a>Delete requests are never retried. The timeout period is specified by the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1105606', '');">WSTimeout</a></span> connection option.</div> <div class="gutter_text_right"><a name="1189545">Valid Values</a></div> <div class="Body"><span class="Syntax"><a name="1189546">0</a></span> | <span class="EquationVariables">x</span></div> <div class="Body"><a name="1189547">where </a><span class="EquationVariables">x</span> is a positive integer.</div> <div class="Body"><a name="1189548">If set to </a><span class="Syntax">0</span>, the driver does not retry timed-out requests after the initial unsuccessful attempt.</div> <div class="Body"><a name="1189549">If set to </a><span class="EquationVariables">x</span>, the driver retries the timed-out request the specified number of times.</div> <div class="gutter_text_right"><a name="1189550">Default</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="1189551">0</a></span></div> <div class="gutter_text_right"><a name="1228580">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1312277', '');" name="1228584">Web Service tab</a></span></div> <div class="gutter_text_right"><a name="1189554">See Also</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1105606', '');" name="1189558">â??WSTimeoutâ??</a></span></div> <div class="head_2_no_TOC"><a name="1105606">WSTimeout</a></div> <div class="gutter_text_right"><a name="1244387">Attribute</a></div> <div class="Body_attr"><a name="1244388">WSTimeout (WST)</a></div> <div class="gutter_text_right"><a name="1093800">Description</a></div> <div class="Body"><a name="1064073">Specifies the time, in seconds, that the driver waits for a response to a Web service request. </a></div> <div class="gutter_text_right"><a name="1064074">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="1064075">0 | </a></span><span class="EquationVariables">x</span></div> <div class="Body"><a name="1064076">where </a><span class="EquationVariables">x</span> is a positive integer that defines the number of seconds the driver waits for a response to a Web service request.</div> <div class="Body"><a name="1064077">If set to </a><span class="Syntax">0</span>, the driver waits indefinitely for a response; there is no timeout.</div> <div class="Body"><a name="1064410">If set to </a><span class="EquationVariables">x</span>, the driver uses the value as the default timeout for any statement created by the connection.</div> <div class="Body"><a name="1064375">If a Select request times out and </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1189539', '');">WSRetry Count</a></span> is set to retry timed-out requests, the driver retries the request the specified number of times.</div> <div class="gutter_text_right"><a name="1064079">Default</a></div> <div class="Body"><span class="Syntax"><a name="1064080">120</a></span> (seconds)</div> <div class="gutter_text_right"><a name="1228590">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1312277', '');" name="1228594">Web Service tab</a></span></div> <div class="gutter_text_right"><a name="1080481">See Also</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1189539', '');" name="1209390">â??WSRetry Countâ??</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