Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\unixenv.07.4.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>Data Source Configuration</title> <link rel="StyleSheet" href="css/unixenv.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="unixenv.07.1.html#108296">4 Configuring the Product on UNIX/Linux</a> : Data Source Configuration</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="108296">Data Source Configuration</a></div> <div class="Body"><a name="127849">In the UNIX and Linux environments, a system information file is used to store data source </a>information. Setup installs a default version of this file, called odbc.ini, in the product installation directory (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.2.html#106226', '');">â??ODBCINIâ??</a></span> for details about relocating and renaming this file). This is a plain text file that contains data source definitions. If you have a Motif graphical user interface (GUI) in your Linux environment, you can use the DataDirect ODBC Data Source Administrator for Linux (the Linux ODBC Administrator) to create or modify data source definitions in this file (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106311', '');">â??Configuration Through the Administratorâ??</a></span> for details). If you do not, see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106368', '');">â??Configuration Through the System Information (odbc.ini) Fileâ??</a></span> and follow the instructions for configuring the file.</div> <div class="Body"><a name="127833">NOTE: The Linux ODBC Administrator is currently supported only on Linux for x86 and x64 </a>processors with Motif 2.0.3 and higher. It is not supported on Linux for Itanium II or other UNIX platforms.</div> <div class="Body"><a name="106294">On Linux, you can determine if you are using Motif through the following command:</a></div> <div class="syntax_first"><a name="106298">rpm â??qa |grep motif</a></div> <div class="Body"><a name="106299">The rpm command returns output similar to:</a></div> <div class="syntax_first"><a name="106300">nc-linuxqa3[/home2/users/mike] rpm -qa |grep motif </a></div> <div class="syntax"><a name="106301">openmotif-2.2.2-124</a></div> <div class="syntax"><a name="106302">openmotif-devel-2.2.2-124</a></div> <div class="Body"><a name="106304">If you are not using a GUI, you can use any text editor to create or modify data source </a>definitions directly in the odbc.ini file. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106368', '');">â??Configuration Through the System Information (odbc.ini) Fileâ??</a></span> for details.</div> <div class="head_2"><a name="106311">Configuration Through the Administrator</a></div> <div class="Body"><a name="106312">The Linux ODBC Administrator is located in the /tools directory of the product installation </a>directory. For example,</div> <div class="syntax_first"><a name="106313">/opt/odbc/tools/odbcadmin</a></div> <div class="Body"><a name="135825">The following drivers can be configured with the Linux ODBC Administrator:</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="135826">DB2 Wire Protocol</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="135827">dBASE</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="135846">Greenplum Wire Protocol</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="135832">Informix Wire Protocol</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="135684">Oracle</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="135693">Oracle Wire Protocol</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="135839">PostgreSQL Wire Protocol</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="135702">SQL Server Legacy Wire Protocol</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="135717">Sybase Wire Protocol</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="135725">The Driver for Teradata</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="135853">Text</a></div> </td> </tr> </table> </div> <div class="Body"><a name="135799">Note that all of the drivers included in your odbc.ini file are shown in the User Data Sources </a>list box, even though some of them cannot be used with the Linux ODBC Administrator.</div> <div class="hanging_label_head"><a name="135650">To configure a data source:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="127982">To start the Linux ODBC Administrator, change to the </a><span class="EquationVariables">install_dir</span>/tools directory, where <span class="EquationVariables">install_dir</span> is the path to the product installation directory. At a command prompt, enter:</div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="127983">./odbcadmin</a></div> <div class="Body_Indent"><a name="127984">The Administrator dialog box appears.</a></div> <div class="picture"><a name="143652"><img class="procedure" src="images/unixadminuser.gif" width="548" height="476" style="display: block; float: none; left: 0.0; top: 0.0;" alt="The User DSN tab of the UNIX ODBC Administrator" /></a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106327">Click either the </a><span class="Action_bold">User DSN</span> or <span class="Action_bold">File DSN</span> tab to display a list of data sources.</div> </td> </tr> </table> </div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><span class="Action_bold"><a name="106328">User DSN</a></span>: If you are configuring an existing user data source, select the appropriate data source name and click <span class="Action_bold">Configure</span> to display the driver Setup dialog box.</div> </td> </tr> </table> </div> <div class="Body_Indent_Sub"><a name="106329">If you are configuring a new user data source, click </a><span class="Action_bold">Add</span> to display a list of installed drivers. Select the appropriate driver and click <span class="Action_bold">Finish</span> to display the driver Setup dialog box.</div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><span class="Action_bold"><a name="106330">File DSN</a></span>: If you are configuring an existing file data source, select the appropriate data source file and click <span class="Action_bold">Configure</span> to display the driver Setup dialog box.</div> </td> </tr> </table> </div> <div class="Body_Indent_Sub"><a name="106331">To configure a new file data source, click </a><span class="Action_bold">Add</span> to display a list of installed drivers. Select the appropriate driver and click <span class="Action_bold">Advanced </span>to specify attributes; otherwise, click <span class="Action_bold">Next</span> to proceed. Specify a name for the data source and click <span class="Action_bold">Next</span>. Verify the data source information; then, click <span class="Action_bold">Finish</span> to display the driver Setup dialog box.</div> <div class="Body_Indent_Sub"><a name="106332">NOTE: If you want to set a default directory for File DSNs, select the directory from </a>the Directories list; then, click <span class="Action_bold">Set Directory</span>. The next time that you open the Administrator, it displays data source files from this directory.</div> <div class="Body_Indent"><a name="106333">The General tab of the driver Setup dialog box appears by default.</a></div> <div class="Body"><a name="106334">See the individual driver chapters for specific information about the driver Setup dialog. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'quikstart.04.1.html#106107', '');">Chapter 1 â??Quick Start Connectâ??</a></span><span class="Cross_ref_"> </span>for an explanation of different types of data sources.</div> <div class="head_3"><a name="106338">Drivers</a></div> <div class="Body"><a name="106339">The Drivers tab shows a list of all installed ODBC drivers.</a></div> <div class="head_3"><a name="106342">Tracing</a></div> <div class="Body"><a name="106343">The Tracing tab allows you to trace calls to ODBC drivers and create a log of the traces for </a>troubleshooting purposes.</div> <div class="Body"><a name="144523">To specify the path and name of the trace log file, type the path and name in the Trace File </a>field or click <span class="Action_bold">Browse</span> to select a log file. If no location is specified, the trace log resides in the working directory of the application you are using.</div> <div class="Body"><a name="144524">DataDirect ships an enhanced library to perform tracing. This library appears by default in </a>the Trace Library field. If you want to use a custom library instead, type the path and name of the library in the Trace Library field or click <span class="Action_bold">Browse</span> to select a library. </div> <div class="Body"><a name="144525">To enable tracing, select the </a><span class="Action_bold">Enable Tracing</span> check box on the Trace tab of the Administrator. Clear the check box to disable tracing. Tracing continues until you disable it. Be sure to turn off tracing when you are finished reproducing the issue because tracing decreases the performance of your ODBC application. </div> <div class="Body"><a name="144526">After making changes on the Trace tab, click </a><span class="Action_bold">Apply</span> for them to take effect.</div> <div class="Body"><a name="127455">For a more complete discussion of tracing, refer to </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.2.html#106157', '');">â??ODBC Traceâ??</a></span> in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.1.html#108583', '');">Chapter 1</a></span> of the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Troubleshooting Guide</span>.</div> <div class="Body"><a name="106364">When you are finished with the Linux ODBC Administrator, click </a><span class="Action_bold">OK</span> or <span class="Action_bold">Cancel</span>. If you click <span class="Action_bold">OK</span>, any changes you have made to the Trace tab are accepted and the Administrator closes. If you click <span class="Action_bold">Cancel</span>, the Administrator closes without saving any changes.</div> <div class="head_2"><a name="106368">Configuration Through the System Information (odbc.ini) </a>File</div> <div class="Body"><a name="106369">To configure a data source manually, you edit the odbc.ini file with a text editor. The content </a>of this file is divided into three sections.</div> <div class="Body"><a name="106370">At the beginning of the file is a section named </a><span class="Syntax">[ODBC Data Sources]</span> containing <span class="EquationVariables">data_source_name=installed-driver</span><span class="Emphasis" style="color: #000000; font-size: 10pt; font-weight: normal;"> </span>pairs, for example:</div> <div class="syntax_first"><span class="Syntax"><a name="106371">Oracle Wire Protocol=DataDirect Oracle Wire Protocol</a></span>.</div> <div class="Body"><a name="106372">The driver uses this section to match a data source to the appropriate installed driver.</a></div> <div class="Body"><a name="106373">The </a><span class="Syntax">[ODBC Data Sources]</span> section also includes data source definitions. The default odbc.ini contains a data source definition for each driver. Each data source definition begins with a data source name in square brackets, for example, <span class="Syntax">[Oracle Wire Protocol 2]</span>. The data source definitions contain connection string <span class="Emphasis">attribute=value</span> pairs with default values. You can modify these values as appropriate for your system. Descriptions of these attributes are in each individual driver chapter. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106443', '');">â??Sample Default odbc.ini Fileâ??</a></span> for sample data sources.</div> <div class="Body"><a name="106374">The second section of the file is named </a><span class="Syntax">[ODBC File DSN]</span> and includes one keyword:</div> <div class="syntax_first"><a name="106375">[ODBC File DSN]</a></div> <div class="syntax"><a name="106376">DefaultDSNDir=</a></div> <div class="Body"><a name="106377">This keyword defines the path of the default location for file data sources (see </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.8.html#114136', '');">â??File Data Sourcesâ??</a></span>).</div> <div class="Body"><a name="106381">NOTE: This section is not included in the default odbc.ini file that is installed by the product </a>installer. You can add this section manually or, if you are using the Linux ODBC Administrator, it will be added automatically when you click <span class="Action_bold">Set Directory</span> on the File DSN tab (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106327', '');">Step 2</a></span> under <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106311', '');">â??Configuration Through the Administratorâ??</a></span>).</div> <div class="Body"><a name="106388">The third section of the file is named </a><span class="Syntax">[ODBC]</span> and includes several keywords, for example:</div> <div class="syntax_first"><a name="106389">[ODBC]</a></div> <div class="syntax"><a name="106390">IANAAppCodePage=4</a></div> <div class="syntax"><a name="106391">InstallDir=/opt/odbc</a></div> <div class="syntax"><a name="106393">Trace=0</a></div> <div class="syntax"><a name="106394">TraceFile=odbctrace.out</a></div> <div class="syntax"><a name="106395">TraceDll=/opt/odbc/lib/ivtrc26.so</a></div> <div class="syntax"><a name="126974">ODBCTraceMaxFileSize=102400</a></div> <div class="syntax"><a name="126975">ODBCTraceMaxNumFiles=10</a></div> <div class="Body"><a name="106396">The IANAAppCodePage keyword defines the default value that all UNIX/Linux drivers use if </a>individual data sources have not specified a different value. See the individual driver chapters and refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'appcodepage.03.1.html#108909', '');">Chapter 1 â??Code Page Valuesâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span> for details. The default value is 4.</div> <div class="Body"><a name="106403">The InstallDir keyword must be included in this section. The value of this keyword is the </a>path to the installation directory under which the /lib and /locale directories are contained. The installation process automatically writes your installation directory to the default odbc.ini file.</div> <div class="Body"><a name="106404">For example, if you choose an installation location of /opt/odbc, then the following line is </a>written to the <span class="Syntax">[ODBC]</span> section of the default odbc.ini:</div> <div class="syntax_first"><a name="106405">InstallDir=/opt/odbc</a></div> <div class="Body"><a name="106406">NOTE: If you are using only DSN-less connections through an odbcinst.ini file and do not </a>have an odbc.ini file, then you must provide <span class="Syntax">[ODBC]</span> section information in the <span class="Syntax">[ODBC]</span> section of the odbcinst.ini file. The drivers and Driver Manager always check first in the <span class="Syntax">[ODBC]</span> section of an odbc.ini file. If no odbc.ini file exists or if the dbc.ini file does not contain an <span class="Syntax">[ODBC]</span> section, they check for an <span class="Syntax">[ODBC]</span> section in the odbcinst.ini file. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.7.html#107137', '');">â??DSN-less Connectionsâ??</a></span> for details.</div> <div class="Body"><a name="106413">ODBC tracing allows you to trace calls to ODBC drivers and create a log of the traces for </a>troubleshooting purposes. The following keywords all control tracing: Trace, TraceFile, TraceDLL, ODBCTraceMaxFileSize, and ODBCTraceMaxNumFiles.</div> <div class="Body"><a name="106428">For a complete description of these keywords and discussion of tracing, refer to </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.2.html#106157', '');">â??ODBC Traceâ??</a></span> in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.1.html#108583', '');">Chapter 1</a></span> of the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Troubleshooting Guide</span>.</div> <div class="head_3"><a name="106443">Sample Default odbc.ini File</a></div> <div class="Body"><a name="106444">The following is a sample odbc.ini file that Setup installs in the installation directory. All </a>occurrences of ODBCHOME are replaced with your installation directory path during installation of the file. Values that you must supply are enclosed by angle brackets (< >). If you are using the installed odbc.ini file, you must supply the values and remove the angle brackets before that data source section will operate properly. Commented lines are denoted by the # symbol. This sample shows 32-bit drivers with file names beginning with iv. A 64-bit driver file would be identical except that driver names would begin with dd and the list of data sources would include only the 64-bit drivers.</div> <div class="syntax_first"><a name="113514">[ODBC Data Sources]</a></div> <div class="syntax"><a name="113515">DB2 Wire Protocol=DataDirect 7.0 DB2 Wire Protocol</a></div> <div class="syntax"><a name="142496">dBASE=DataDirect 7.0 dBASEFile(*.dbf)</a></div> <div class="syntax"><a name="142497">FoxPro3=DataDirect 7.0 dBASEFile(*.dbf)</a></div> <div class="syntax"><a name="142498">Greenplum Wire Protocol=DataDirect 7.0 Greenplum Wire Protocol</a></div> <div class="syntax"><a name="142499">Informix Wire Protocol=DataDirect 7.0 Informix Wire Protocol</a></div> <div class="syntax"><a name="142500">MySQL Wire Protocol=DataDirect 7.0 MySQL Wire Protocol</a></div> <div class="syntax"><a name="113521">Oracle Wire Protocol=DataDirect 7.0 Oracle Wire Protocol</a></div> <div class="syntax"><a name="142505">PostgreSQL Wire Protocol=DataDirect 7.0 PostgreSQL Wire Protocol</a></div> <div class="syntax"><a name="142506">Progress OpenEdge Wire Protocol=DataDirect 7.0 Progress OpenEdge Wire Protocol</a></div> <div class="syntax"><a name="135443">Salesforce=DataDirect 7.0 Salesforce</a></div> <div class="syntax"><a name="123726">SQLServer Wire Protocol=DataDirect 7.0 SQL Server Wire Protocol</a></div> <div class="syntax"><a name="142511">Sybase Wire Protocol=DataDirect 7.0 Sybase Wire Protocol</a></div> <div class="syntax"><a name="142512">Sybase IQ Wire Protocol=DataDirect 7.0 Sybase IQ Wire Protocol</a></div> <div class="syntax"><a name="142513">Teradata=DataDirect 7.0 Teradata</a></div> <div class="syntax"><a name="142514">Text=DataDirect 7.0 TextFile(*.*)</a></div> <div class="syntax"><a name="142515">Informix=DataDirect 7.0 Informix</a></div> <div class="syntax"><a name="124388">Oracle=DataDirect 7.0 Oracle</a></div> <div class="syntax"><a name="124382">SQLServ Legacy Wire Protocol=DataDirect 7.0 SQL Server Legacy Wire Protocol</a></div> <div class="syntax"><a name="113530"> </a></div> <div class="syntax"><a name="106462">[DB2 Wire Protocol]</a></div> <div class="syntax"><a name="106463">Driver=ODBCHOME/lib/ivdb226</a><span class="Emphasis">.</span>so</div> <div class="syntax"><a name="142520">Description=DataDirect 7.0 DB2 Wire Protocol</a></div> <div class="syntax"><a name="142521">AccountingInfo=</a></div> <div class="syntax"><a name="142522">AddStringToCreateTable=</a></div> <div class="syntax"><a name="142523">AlternateID=</a></div> <div class="syntax"><a name="142524">AlternateServers=</a></div> <div class="syntax"><a name="142525">ApplicationName=</a></div> <div class="syntax"><a name="142526">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142527">AuthenticationMethod=0</a></div> <div class="syntax"><a name="142528">BulkBinaryThreshold=32</a></div> <div class="syntax"><a name="130759">BulkCharacterThreshold=-1</a></div> <div class="syntax"><a name="142534">BulkLoadBatchSize=1024</a></div> <div class="syntax"><a name="142539">BulkLoadFieldDelimiter=</a></div> <div class="syntax"><a name="142544">BulkLoadRecordDelimiter=</a></div> <div class="syntax"><a name="142545">CatalogSchema=</a></div> <div class="syntax"><a name="142546">CharsetFor65535=0</a></div> <div class="syntax"><a name="142547">ClientHostName=</a></div> <div class="syntax"><a name="142548">ClientUser=</a></div> <div class="syntax"><a name="142549">#Collection applies to z/OS and iSeries only</a></div> <div class="syntax"><a name="142550">Collection=</a></div> <div class="syntax"><a name="127156">ConcurrentAccessResolution=0</a></div> <div class="syntax"><a name="142555">ConnectionReset=0</a></div> <div class="syntax"><a name="142556">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142557">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="142558">CurrentFunctionPath=</a></div> <div class="syntax"><a name="142559">#Database applies to DB2 UDB only</a></div> <div class="syntax"><a name="142560">Database=<database_name></a></div> <div class="syntax"><a name="142561">DefaultIsolationLevel=1</a></div> <div class="syntax"><a name="142562">DynamicSections=1000</a></div> <div class="syntax"><a name="142563">EnableBulkLoad=0</a></div> <div class="syntax"><a name="142564">EncryptionMethod=0</a></div> <div class="syntax"><a name="142565">FailoverGranularity=0</a></div> <div class="syntax"><a name="142566">FailoverMode=0</a></div> <div class="syntax"><a name="130783">FailoverPreconnect=0</a></div> <div class="syntax"><a name="142572">FetchTSWTZasTimestamp=0</a></div> <div class="syntax"><a name="142573">GrantAuthid=PUBLIC</a></div> <div class="syntax"><a name="142574">GrantExecute=1</a></div> <div class="syntax"><a name="142575">GSSClient=native</a></div> <div class="syntax"><a name="142576">HostNameInCertificate=</a></div> <div class="syntax"><a name="142577">IpAddress=<DB2_server_host></a></div> <div class="syntax"><a name="142578">KeyPassword=</a></div> <div class="syntax"><a name="142579">KeyStore=</a></div> <div class="syntax"><a name="142580">KeyStorePassword=</a></div> <div class="syntax"><a name="142581">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="142582">LoadBalancing=0</a></div> <div class="syntax"><a name="142583">#Location applies to z/OS and iSeries only</a></div> <div class="syntax"><a name="142584">Location=<location_name></a></div> <div class="syntax"><a name="142585">LoginTimeout=15</a></div> <div class="syntax"><a name="142586">LogonID=</a></div> <div class="syntax"><a name="142587">MaxPoolSize=100</a></div> <div class="syntax"><a name="142588">MinPoolSize=0</a></div> <div class="syntax"><a name="142589">Password=</a></div> <div class="syntax"><a name="142590">PackageCollection=NULLID</a></div> <div class="syntax"><a name="142591">PackageNamePrefix=DD</a></div> <div class="syntax"><a name="142592">PackageOwner=</a></div> <div class="syntax"><a name="142593">Pooling=0</a></div> <div class="syntax"><a name="142594">ProgramID=</a></div> <div class="syntax"><a name="142595">QueryTimeout=0</a></div> <div class="syntax"><a name="142596">ReportCodePageConversionErrors=0</a></div> <div class="syntax"><a name="142597">TcpPort=50000</a></div> <div class="syntax"><a name="142598">TrustStore=</a></div> <div class="syntax"><a name="142599">TrustStorePassword=</a></div> <div class="syntax"><a name="142600">UseCurrentSchema=1</a></div> <div class="syntax"><a name="142601">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="142602">WithHold=1</a></div> <div class="syntax"><a name="142603">XMLDescribeType=-10</a></div> <div class="syntax"><a name="125139"> </a></div> <div class="syntax"><a name="142608">[dBASE]</a></div> <div class="syntax"><a name="142609">Driver=ODBCHOME/lib/ivdbf26.so</a></div> <div class="syntax"><a name="142610">Description=DataDirect 7.0 dBASEFile(*.dbf)</a></div> <div class="syntax"><a name="142611">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142612">CacheSize=4</a></div> <div class="syntax"><a name="142613">CreateType=dBASE5</a></div> <div class="syntax"><a name="142614">Database=ODBCHOME/demo</a></div> <div class="syntax"><a name="142615">DataFileExtension=DBF</a></div> <div class="syntax"><a name="142616">ExtensionCase=UPPER</a></div> <div class="syntax"><a name="142617">FileOpenCache=0</a></div> <div class="syntax"><a name="142618">IntlSort=0</a></div> <div class="syntax"><a name="142619">LockCompatibility=dBASE</a></div> <div class="syntax"><a name="142620">Locking=RECORD</a></div> <div class="syntax"><a name="142621">UseLongNames=0</a></div> <div class="syntax"><a name="142622">UseLongQualifiers=0</a></div> <div class="syntax"><a name="142623"> </a></div> <div class="syntax"><a name="142624">[FoxPro3]</a></div> <div class="syntax"><a name="142625">Driver=ODBCHOME/lib/ivdbf26.so</a></div> <div class="syntax"><a name="142626">Description=DataDirect 7.0 dBASEFile(*.dbf)</a></div> <div class="syntax"><a name="142627">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142628">CacheSize=4</a></div> <div class="syntax"><a name="142629">CreateType=FoxPro30</a></div> <div class="syntax"><a name="142630">Database=ODBCHOME/demo</a></div> <div class="syntax"><a name="142631">DataFileExtension=DBF</a></div> <div class="syntax"><a name="142632">ExtensionCase=UPPER</a></div> <div class="syntax"><a name="142633">FileOpenCache=0</a></div> <div class="syntax"><a name="142634">IntlSort=0</a></div> <div class="syntax"><a name="142635">LockCompatibility=Fox</a></div> <div class="syntax"><a name="142636">Locking=RECORD</a></div> <div class="syntax"><a name="142637">UseLongNames=0</a></div> <div class="syntax"><a name="142638">UseLongQualifiers=0</a></div> <div class="syntax"><a name="142639"> </a></div> <div class="syntax"><a name="142640">[Greenplum Wire Protocol]</a></div> <div class="syntax"><a name="142641">Driver=ODBCHOME/lib/ivgplm26.so</a></div> <div class="syntax"><a name="142642">Description=DataDirect 7.0 Greenplum Wire Protocol</a></div> <div class="syntax"><a name="142643">AlternateServers=</a></div> <div class="syntax"><a name="142644">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142645">ConnectionReset=0</a></div> <div class="syntax"><a name="142646">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142647">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="142648">Database=<database_name></a></div> <div class="syntax"><a name="142649">DefaultLongDataBuffLen=2048</a></div> <div class="syntax"><a name="142650">EnableDescribeParam=1</a></div> <div class="syntax"><a name="144055">EnableKeysetCursors=0</a></div> <div class="syntax"><a name="142651">EncryptionMethod=0</a></div> <div class="syntax"><a name="142652">ExtendedColumnMetaData=0</a></div> <div class="syntax"><a name="142653">FailoverGranularity=0</a></div> <div class="syntax"><a name="142654">FailoverMode=0</a></div> <div class="syntax"><a name="130865">FailoverPreconnect=0</a></div> <div class="syntax"><a name="142660">FetchRefCursors=1</a></div> <div class="syntax"><a name="142661">FetchTSWTZasTimestamp=0</a></div> <div class="syntax"><a name="142662">FetchTWFSasTime=0</a></div> <div class="syntax"><a name="142663">HostName=<Greenplum_host></a></div> <div class="syntax"><a name="142664">HostNameInCertificate=</a></div> <div class="syntax"><a name="142665">InitializationString=</a></div> <div class="syntax"><a name="142666">KeyPassword=</a></div> <div class="syntax"><a name="144073">KeysetCursorOptions=0</a></div> <div class="syntax"><a name="142667">KeyStore=</a></div> <div class="syntax"><a name="142668">KeyStorePassword=</a></div> <div class="syntax"><a name="142669">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="142670">LoadBalancing=0</a></div> <div class="syntax"><a name="142671">LoginTimeout=15</a></div> <div class="syntax"><a name="142672">LogonID=</a></div> <div class="syntax"><a name="142673">MaxLongVarcharSize=</a></div> <div class="syntax"><a name="142674">MaxPoolSize=100</a></div> <div class="syntax"><a name="142675">MaxVarcharSize=</a></div> <div class="syntax"><a name="142676">MinPoolSize=0</a></div> <div class="syntax"><a name="142677">Password=</a></div> <div class="syntax"><a name="142678">Pooling=0</a></div> <div class="syntax"><a name="142679">PortNumber=<Greenplum_server_port></a></div> <div class="syntax"><a name="142680">QueryTimeout=0</a></div> <div class="syntax"><a name="142681">ReportCodepageConversionErrors=0</a></div> <div class="syntax"><a name="142682">TransactionErrorBehavior=1</a></div> <div class="syntax"><a name="142683">TrustStore=</a></div> <div class="syntax"><a name="142684">TrustStorePassword=</a></div> <div class="syntax"><a name="142685">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="142686">XMLDescribeType=-10</a></div> <div class="syntax"><a name="142687"> </a></div> <div class="syntax"><a name="142688">[Informix Wire Protocol]</a></div> <div class="syntax"><a name="142689">Driver=ODBCHOME/lib/ivifcl26.so</a></div> <div class="syntax"><a name="142690">Description=DataDirect 7.0 Informix Wire Protocol</a></div> <div class="syntax"><a name="142691">AlternateServers=</a></div> <div class="syntax"><a name="142692">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142693">CancelDetectInterval=0</a></div> <div class="syntax"><a name="142694">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142695">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="142696">Database=<database_name></a></div> <div class="syntax"><a name="142697">HostName=<Informix_host></a></div> <div class="syntax"><a name="142698">LoadBalancing=0</a></div> <div class="syntax"><a name="142699">LogonID=</a></div> <div class="syntax"><a name="142700">Password=</a></div> <div class="syntax"><a name="142701">PortNumber=<Informix_server_port></a></div> <div class="syntax"><a name="142702">ServerName=<Informix_server></a></div> <div class="syntax"><a name="142703">TrimBlankFromIndexName=1</a></div> <div class="syntax"><a name="142704">UseDelimitedIdentifiers=0</a></div> <div class="syntax"><a name="142705"> </a></div> <div class="syntax"><a name="142706">[MySQL Wire Protocol]</a></div> <div class="syntax"><a name="142707">Driver=ODBCHOME/lib/ivmysql26.so</a></div> <div class="syntax"><a name="142708">Description=DataDirect 7.0 MySQL Wire Protocol</a></div> <div class="syntax"><a name="142709">AlternateServers=</a></div> <div class="syntax"><a name="142710">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142711">ConnectionReset=0</a></div> <div class="syntax"><a name="142712">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142713">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="142714">Database=<database_name></a></div> <div class="syntax"><a name="142715">DefaultLongDataBuffLen=1024</a></div> <div class="syntax"><a name="142716">EnableDescribeParam=0</a></div> <div class="syntax"><a name="142717">EncryptionMethod=0</a></div> <div class="syntax"><a name="142718">FailoverGranularity=0</a></div> <div class="syntax"><a name="142719">FailoverMode=0</a></div> <div class="syntax"><a name="142720">FailoverPreconnect=0</a></div> <div class="syntax"><a name="142721">HostName=<MySQL_host></a></div> <div class="syntax"><a name="142722">HostNameInCertificate=</a></div> <div class="syntax"><a name="142723">InteractiveClient=0</a></div> <div class="syntax"><a name="142724">KeyPassword=</a></div> <div class="syntax"><a name="142725">Keystore=</a></div> <div class="syntax"><a name="142726">KeystorePassword=</a></div> <div class="syntax"><a name="142727">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="142728">LoadBalancing=0</a></div> <div class="syntax"><a name="142729">LoginTimeout=15</a></div> <div class="syntax"><a name="142730">LogonID=</a></div> <div class="syntax"><a name="142731">Password=</a></div> <div class="syntax"><a name="142732">MaxPoolSize=100</a></div> <div class="syntax"><a name="142733">MinPoolSize=0</a></div> <div class="syntax"><a name="142734">Pooling=0</a></div> <div class="syntax"><a name="142735">PortNumber=<MySQL_server_port></a></div> <div class="syntax"><a name="142736">QueryTimeout=0</a></div> <div class="syntax"><a name="142737">ReportCodepageConversionErrors=0</a></div> <div class="syntax"><a name="142738">TreatBinaryAsChar=0</a></div> <div class="syntax"><a name="142739">TrustStore=</a></div> <div class="syntax"><a name="142740">TrustStorePassword=</a></div> <div class="syntax"><a name="142741">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="106587"> </a></div> <div class="syntax"><a name="118638">[Oracle Wire Protocol]</a></div> <div class="syntax"><a name="118639">Driver=ODBCHOME/lib/ivora26.so</a></div> <div class="syntax"><a name="118640">Description=DataDirect 7.0 Oracle Wire Protocol</a></div> <div class="syntax"><a name="142746">AccountingInfo=</a></div> <div class="syntax"><a name="118641">Action=</a></div> <div class="syntax"><a name="142751">AlternateServers=</a></div> <div class="syntax"><a name="142752">ApplicationName=</a></div> <div class="syntax"><a name="118642">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="118643">ArraySize=60000</a></div> <div class="syntax"><a name="118644">AuthenticationMethod=1</a></div> <div class="syntax"><a name="135527">BulkLoadBatchSize=1024</a></div> <div class="syntax"><a name="118645">BulkBinaryThreshold=32</a></div> <div class="syntax"><a name="135512">BulkCharacterThreshold=-1</a></div> <div class="syntax"><a name="135553">BulkLoadFieldDelimiter=</a></div> <div class="syntax"><a name="135514">BulkLoadOptions=0</a></div> <div class="syntax"><a name="135545">BulkLoadRecordDelimiter=</a></div> <div class="syntax"><a name="118648">CachedCursorLimit=32</a></div> <div class="syntax"><a name="118649">CachedDescLimit=0</a></div> <div class="syntax"><a name="118650">CatalogIncludesSynonyms=1</a></div> <div class="syntax"><a name="118651">CatalogOptions=0</a></div> <div class="syntax"><a name="142757">ClientHostName=</a></div> <div class="syntax"><a name="142758">ClientID=</a></div> <div class="syntax"><a name="142759">ClientUser=</a></div> <div class="syntax"><a name="118652">ConnectionReset=0</a></div> <div class="syntax"><a name="118653">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="118654">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="118655">DefaultLongDataBuffLen=1024</a></div> <div class="syntax"><a name="118656">DescribeAtPrepare=0</a></div> <div class="syntax"><a name="127157">EditionName=</a></div> <div class="syntax"><a name="118657">EnableBulkLoad=0</a></div> <div class="syntax"><a name="118658">EnableDescribeParam=0</a></div> <div class="syntax"><a name="118659">EnableNcharSupport=0</a></div> <div class="syntax"><a name="118660">EnableScrollableCursors=1</a></div> <div class="syntax"><a name="135319">EnableServerResultCache=0</a></div> <div class="syntax"><a name="118661">EnableStaticCursorsForLongData=0</a></div> <div class="syntax"><a name="118662">EnableTimestampWithTimeZone=0</a></div> <div class="syntax"><a name="118663">EncryptionMethod=0</a></div> <div class="syntax"><a name="118664">FailoverGranularity=0</a></div> <div class="syntax"><a name="118665">FailoverMode=0</a></div> <div class="syntax"><a name="118666">FailoverPreconnect=0</a></div> <div class="syntax"><a name="118667">FetchTSWTZasTimestamp=0</a></div> <div class="syntax"><a name="118668">GSSClient=native</a></div> <div class="syntax"><a name="118669">HostName=<Oracle_server></a></div> <div class="syntax"><a name="118670">HostNameInCertificate=</a></div> <div class="syntax"><a name="118671">InitializationString=</a></div> <div class="syntax"><a name="118672">KeyPassword=</a></div> <div class="syntax"><a name="118673">KeyStore=</a></div> <div class="syntax"><a name="118674">KeyStorePassword</a></div> <div class="syntax"><a name="118675">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="118676">LoadBalancing=0</a></div> <div class="syntax"><a name="118677">LocalTimeZoneOffset=</a></div> <div class="syntax"><a name="118678">LockTimeOut=-1</a></div> <div class="syntax"><a name="118679">LoginTimeout=15</a></div> <div class="syntax"><a name="118680">LogonID=</a></div> <div class="syntax"><a name="118682">MaxPoolSize=100</a></div> <div class="syntax"><a name="118683">MinPoolSize=0</a></div> <div class="syntax"><a name="127260">Module=0</a></div> <div class="syntax"><a name="127562">Password=</a></div> <div class="syntax"><a name="127270">Pooling=0</a></div> <div class="syntax"><a name="118685">PortNumber=<Oracle_server_port></a></div> <div class="syntax"><a name="118686">ProcedureRetResults=0</a></div> <div class="syntax"><a name="142764">ProgramID=</a></div> <div class="syntax"><a name="118687">QueryTimeout=0</a></div> <div class="syntax"><a name="118688">ReportCodePageConversionErrors=0</a></div> <div class="syntax"><a name="118689">ReportRecycleBin=0</a></div> <div class="syntax"><a name="118690">ServerName=<server_name_in_tnsnames.ora></a></div> <div class="syntax"><a name="118691">ServerType=0</a></div> <div class="syntax"><a name="118692">ServiceName=</a></div> <div class="syntax"><a name="118693">SID=<Oracle_System_Identifier></a></div> <div class="syntax"><a name="118694">TimestampEscapeMapping=0</a></div> <div class="syntax"><a name="118695">TNSNamesFile=<tnsnames.ora_filename></a></div> <div class="syntax"><a name="118696">TrustStore=</a></div> <div class="syntax"><a name="118697">TrustStorePassword=</a></div> <div class="syntax"><a name="118698">UseCurrentSchema=1</a></div> <div class="syntax"><a name="118699">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="118700">WireProtocolMode=1</a></div> <div class="syntax"><a name="142769"> </a></div> <div class="syntax"><a name="142770">[PostgreSQL Wire Protocol]</a></div> <div class="syntax"><a name="142771">Driver=ODBCHOME/lib/ivpsql26.so</a></div> <div class="syntax"><a name="142772">Description=DataDirect 7.0 PostgreSQL Wire Protocol</a></div> <div class="syntax"><a name="142773">AlternateServers=</a></div> <div class="syntax"><a name="142774">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142775">ConnectionReset=0</a></div> <div class="syntax"><a name="142776">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142777">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="142778">Database=<database_name></a></div> <div class="syntax"><a name="142779">EnableDescribeParam=1</a></div> <div class="syntax"><a name="119898">EncryptionMethod=0</a></div> <div class="syntax"><a name="142785">ExtendedColumnMetaData=0</a></div> <div class="syntax"><a name="142786">FailoverGranularity=0</a></div> <div class="syntax"><a name="142787">FailoverMode=0</a></div> <div class="syntax"><a name="142788">FailoverPreconnect=0</a></div> <div class="syntax"><a name="142789">FetchTSWTZasTimestamp=0</a></div> <div class="syntax"><a name="142790">FetchTWFSasTime=0</a></div> <div class="syntax"><a name="142791">HostName=<PostgreSQL_host></a></div> <div class="syntax"><a name="142792">HostNameInCertificate=</a></div> <div class="syntax"><a name="142793">InitializationString=</a></div> <div class="syntax"><a name="142794">KeyPassword=</a></div> <div class="syntax"><a name="142795">Keystore=</a></div> <div class="syntax"><a name="142796">KeystorePassword=</a></div> <div class="syntax"><a name="142797">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="142798">LoadBalancing=0</a></div> <div class="syntax"><a name="142799">LoginTimeout=15</a></div> <div class="syntax"><a name="142800">LogonID=</a></div> <div class="syntax"><a name="142801">MaxLongVarcharSize=</a></div> <div class="syntax"><a name="142802">MaxPoolSize=100</a></div> <div class="syntax"><a name="142803">MaxVarcharSize=</a></div> <div class="syntax"><a name="142804">MinPoolSize=0</a></div> <div class="syntax"><a name="142805">Password=</a></div> <div class="syntax"><a name="142806">Pooling=0</a></div> <div class="syntax"><a name="142807">PortNumber=<PostgreSQL_server_port></a></div> <div class="syntax"><a name="142808">QueryTimeout=0</a></div> <div class="syntax"><a name="131009">ReportCodepageConversionErrors=0</a></div> <div class="syntax"><a name="142814">TransactionErrorBehavior</a>=1</div> <div class="syntax"><a name="142815">TrustStore=</a></div> <div class="syntax"><a name="142816">TrustStorePassword=</a></div> <div class="syntax"><a name="142817">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="142818">XMLDescribeType=-10</a></div> <div class="syntax"><a name="128276"> </a></div> <div class="syntax"><a name="132307">[Progress OpenEdge Wire Protocol]</a></div> <div class="syntax"><a name="132308">Driver=ODBCHOME/lib/ivoe26.so</a></div> <div class="syntax"><a name="142823">Description=DataDirect 7.0 Progress OpenEdge Wire Protocol</a></div> <div class="syntax"><a name="142824">AlternateServers=</a></div> <div class="syntax"><a name="132560">ArraySize=</a></div> <div class="syntax"><a name="142829">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142830">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="132563">Database=<database_name></a></div> <div class="syntax"><a name="132564">DefaultIsolationLevel=1</a></div> <div class="syntax"><a name="132565">EnableTimestampWithTimezone=1</a></div> <div class="syntax"><a name="132566">Encryption Method=0</a></div> <div class="syntax"><a name="142835">FailoverGranularity=0</a></div> <div class="syntax"><a name="142836">FailoverMode=0</a></div> <div class="syntax"><a name="142837">FailoverPreconnect=0</a></div> <div class="syntax"><a name="132570">HostName=<Progress_server></a></div> <div class="syntax"><a name="132571">HostNameInCertificate=</a></div> <div class="syntax"><a name="142842">LoadBalancing=0</a></div> <div class="syntax"><a name="142843">LoginTimeout=15</a></div> <div class="syntax"><a name="132574">PortNumber=<Progress_server_port></a></div> <div class="syntax"><a name="142848">QueryTimeout=0</a></div> <div class="syntax"><a name="132576">TrustStore=</a></div> <div class="syntax"><a name="132577">TrustStorePassword=</a></div> <div class="syntax"><a name="132578">UseWideCharacterTypes=0</a></div> <div class="syntax"><a name="132579">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="132328"> </a></div> <div class="syntax"><a name="132297">[Salesforce]</a></div> <div class="syntax"><a name="128287">Driver=ODBCHOME/lib/ivsfrc26.so</a></div> <div class="syntax"><a name="128288">Description=DataDirect 7.0 Salesforce</a></div> <div class="syntax"><a name="128289">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="128290">BulkLoadAsync=0</a></div> <div class="syntax"><a name="128291">BulkLoadBatchSize=1024</a></div> <div class="syntax"><a name="128292">BulkLoadConcurrencyMode=1</a></div> <div class="syntax"><a name="128293">BulkLoadPollInterval=10</a></div> <div class="syntax"><a name="128295">BulkLoadThreshold=4000</a></div> <div class="syntax"><a name="128296">BulkLoadTimeout=0</a></div> <div class="syntax"><a name="128297">ConnectionReset=0</a></div> <div class="syntax"><a name="128298">ConfigOptions=</a></div> <div class="syntax"><a name="128299">CreateDB=2</a></div> <div class="syntax"><a name="128301">Database=</a></div> <div class="syntax"><a name="128302">Extended Options=</a></div> <div class="syntax"><a name="128303">FetchSize=100</a></div> <div class="syntax"><a name="128304">HostName=</a></div> <div class="syntax"><a name="128305">InitializationString=</a></div> <div class="syntax"><a name="128307">JVMArgs=-Xmx256m</a></div> <div class="syntax"><a name="128308">JVMClasspath=</a></div> <div class="syntax"><a name="128309">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="128310">LogConfigFile=</a></div> <div class="syntax"><a name="128311">LogonDomain=</a></div> <div class="syntax"><a name="128312">LoginTimeout=15</a></div> <div class="syntax"><a name="128313">LogonID=</a></div> <div class="syntax"><a name="128314">MaxPoolSize=100</a></div> <div class="syntax"><a name="128315">MinPoolSize=0</a></div> <div class="syntax"><a name="128316">Password=</a></div> <div class="syntax"><a name="128317">Pooling=0</a></div> <div class="syntax"><a name="128319">ProxyHost=</a></div> <div class="syntax"><a name="128320">ProxyPassword=</a></div> <div class="syntax"><a name="128321">ProxyPort=</a></div> <div class="syntax"><a name="128322">ProxyUser=</a></div> <div class="syntax"><a name="128323">QueryTimeout=0</a></div> <div class="syntax"><a name="128324">ReportCodepageConversionErrors=0</a></div> <div class="syntax"><a name="128325">ReadOnly=0</a></div> <div class="syntax"><a name="128326">RefreshDirtyCache=0</a></div> <div class="syntax"><a name="128328">SecurityToken=</a></div> <div class="syntax"><a name="128329">StmtCallLimit=20</a></div> <div class="syntax"><a name="128330">StmtCallLimitBehavior=2</a></div> <div class="syntax"><a name="128331">TransactionMode=0</a></div> <div class="syntax"><a name="128333">WSFetchSize=0</a></div> <div class="syntax"><a name="128334">WSRetryCount=0</a></div> <div class="syntax"><a name="128277">WSTimeout=120</a></div> <div class="syntax"><a name="142868"> </a></div> <div class="syntax"><a name="123799">[SQLServer Wire Protocol]</a></div> <div class="syntax"><a name="123800">Driver=ODBCHOME/lib/ivsqls26.so</a></div> <div class="syntax"><a name="123801">Description=DataDirect 7.0 SQL Server Wire Protocol</a></div> <div class="syntax"><a name="123803">AlternateServers=</a></div> <div class="syntax"><a name="123852">AlwaysReportTriggerResults=0</a></div> <div class="syntax"><a name="123804">AnsiNPW=1</a></div> <div class="syntax"><a name="123857">ApplicationName=</a></div> <div class="syntax"><a name="142873">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142874">AuthenticationMethod=1</a></div> <div class="syntax"><a name="142875">BulkBinaryThreshold=32</a></div> <div class="syntax"><a name="142876">BulkCharacterThreshold=-1</a></div> <div class="syntax"><a name="142877">BulkLoadBatchSize=1024</a></div> <div class="syntax"><a name="136024">BulkLoadFieldDelimiter=</a></div> <div class="syntax"><a name="123951">BulkLoadOptions=2</a></div> <div class="syntax"><a name="135594">BulkLoadRecordDelimiter=</a></div> <div class="syntax"><a name="142882">ConnectionReset=0</a></div> <div class="syntax"><a name="142883">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142884">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="142885">Database=<database_name></a></div> <div class="syntax"><a name="142886">DefaultLongDataBuffLen=1024</a></div> <div class="syntax"><a name="142887">EnableBulkLoad=0</a></div> <div class="syntax"><a name="142888">EnableQuotedIdentifiers=0</a></div> <div class="syntax"><a name="142889">EncryptionMethod=0</a></div> <div class="syntax"><a name="142890">FailoverGranularity=0</a></div> <div class="syntax"><a name="142891">FailoverMode=0</a></div> <div class="syntax"><a name="142892">FailoverPreconnect=0</a></div> <div class="syntax"><a name="142893">FetchTSWTZasTimestamp=0</a></div> <div class="syntax"><a name="123965">FetchTWFSasTime=1</a></div> <div class="syntax"><a name="142899">GSSClient=native</a></div> <div class="syntax"><a name="142900">HostName=<SQL_Server_host></a></div> <div class="syntax"><a name="142901">HostNameInCertificate=</a></div> <div class="syntax"><a name="142902">InitializationString=</a></div> <div class="syntax"><a name="142903">Language=</a></div> <div class="syntax"><a name="142904">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="142905">LoadBalancing=0</a></div> <div class="syntax"><a name="142906">LoginTimeout=15</a></div> <div class="syntax"><a name="142907">LogonID=</a></div> <div class="syntax"><a name="142908">MaxPoolSize=100</a></div> <div class="syntax"><a name="142909">MinPoolSize=0</a></div> <div class="syntax"><a name="142910">PacketSize=-1</a></div> <div class="syntax"><a name="142911">Password=</a></div> <div class="syntax"><a name="142912">Pooling=0</a></div> <div class="syntax"><a name="142913">PortNumber=<SQL_Server_server_port></a></div> <div class="syntax"><a name="142914">QueryTimeout=0</a></div> <div class="syntax"><a name="142915">ReportCodePageConversionErrors=0</a></div> <div class="syntax"><a name="124002">SnapshotSerializable=0</a></div> <div class="syntax"><a name="142920">TrustStore=</a></div> <div class="syntax"><a name="142921">TrustStorePassword=</a></div> <div class="syntax"><a name="142922">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="142923">WorkStationID=</a></div> <div class="syntax"><a name="123805">XMLDescribeType=-10</a></div> <div class="syntax"><a name="142928"> </a></div> <div class="syntax"><a name="142929">[Sybase Wire Protocol]</a></div> <div class="syntax"><a name="142930">Driver=ODBCHOME/lib/ivase26.so</a></div> <div class="syntax"><a name="142931">Description=DataDirect 7.0 Sybase Wire Protocol</a></div> <div class="syntax"><a name="142932">AlternateServers=</a></div> <div class="syntax"><a name="142933">ApplicationName=</a></div> <div class="syntax"><a name="142934">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="142935">ArraySize=50</a></div> <div class="syntax"><a name="142936">AuthenticationMethod=0</a></div> <div class="syntax"><a name="142937">BulkBinaryThreshold=32</a></div> <div class="syntax"><a name="142938">BulkCharacterThreshold=-1</a></div> <div class="syntax"><a name="142939">BulkLoadBatchSize=1024</a></div> <div class="syntax"><a name="135623">BulkLoadFieldDelimiter=</a></div> <div class="syntax"><a name="135624">BulkLoadRecordDelimiter=</a></div> <div class="syntax"><a name="142944">Charset=</a></div> <div class="syntax"><a name="142945">ConnectionReset=0</a></div> <div class="syntax"><a name="142946">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="142947">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="142948">CursorCacheSize=1</a></div> <div class="syntax"><a name="142949">Database=<database_name></a></div> <div class="syntax"><a name="142950">DefaultLongDataBuffLen=1024</a></div> <div class="syntax"><a name="131112">DistributedTransactionModel=0</a></div> <div class="syntax"><a name="142955">EnableBulkLoad=0</a></div> <div class="syntax"><a name="142956">EnableDescribeParam=0</a></div> <div class="syntax"><a name="142957">EnableQuotedIdentifiers=0</a></div> <div class="syntax"><a name="142958">EncryptionMethod=0</a></div> <div class="syntax"><a name="142959">FailoverGranularity=0</a></div> <div class="syntax"><a name="142960">FailoverMode=0</a></div> <div class="syntax"><a name="142961">FailoverNetworkAddress=</a></div> <div class="syntax"><a name="142962">FailoverPreconnect=0</a></div> <div class="syntax"><a name="142963">FetchTWFSasTime=1</a></div> <div class="syntax"><a name="142964">GSSClient=native</a></div> <div class="syntax"><a name="142965">HostNameInCertificate=</a></div> <div class="syntax"><a name="142966">InitializationString=</a></div> <div class="syntax"><a name="131122">InterfacesFileServerName=</a></div> <div class="syntax"><a name="142971">Language=</a></div> <div class="syntax"><a name="142972">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="142973">LoadBalancing=0</a></div> <div class="syntax"><a name="142974">LoginTimeout=15</a></div> <div class="syntax"><a name="142975">LogonID=</a></div> <div class="syntax"><a name="142976">MaxPoolSize=100</a></div> <div class="syntax"><a name="142977">MinPoolSize=0</a></div> <div class="syntax"><a name="142978">NetworkAddress=<Sybase_host,Sybase_server_port></a></div> <div class="syntax"><a name="142979">OptimizePrepare=1</a></div> <div class="syntax"><a name="142980">PacketSize=0</a></div> <div class="syntax"><a name="142981">Password=</a></div> <div class="syntax"><a name="142982">Pooling=0</a></div> <div class="syntax"><a name="142983">QueryTimeout=0</a></div> <div class="syntax"><a name="142984">RaiseErrorPositionBehavior=0</a></div> <div class="syntax"><a name="142985">ReportCodePageConversionErrors=0</a></div> <div class="syntax"><a name="142986">SelectMethod=0</a></div> <div class="syntax"><a name="142987">ServicePrincipalName=</a></div> <div class="syntax"><a name="142988">TightlyCoupledDistributedTransactions=</a></div> <div class="syntax"><a name="142989">TruncateTimeTypeFractions=0</a></div> <div class="syntax"><a name="142990">TrustStore=</a></div> <div class="syntax"><a name="142991">TrustStorePassword=</a></div> <div class="syntax"><a name="142992">ValidateServerCertificate=1</a></div> <div class="syntax"><a name="142993">WorkStationID=</a></div> <div class="syntax"><a name="142998">XAOpenStringParameters=</a></div> <div class="syntax"><a name="119126"> </a></div> <div class="syntax"><a name="143003">[Sybase IQ Wire Protocol]</a></div> <div class="syntax"><a name="143004">Driver=ODBCHOME/lib/ivsyiq26.so</a></div> <div class="syntax"><a name="143005">Description=DataDirect 7.0 Sybase IQ Wire Protocol</a></div> <div class="syntax"><a name="143006">AlternateServers=</a></div> <div class="syntax"><a name="143007">ApplicationName=</a></div> <div class="syntax"><a name="143008">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="143009">ArraySize=50</a></div> <div class="syntax"><a name="143013">Charset=</a></div> <div class="syntax"><a name="143014">ConnectionReset=0</a></div> <div class="syntax"><a name="143015">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="143016">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="143017">CursorCacheSize=1</a></div> <div class="syntax"><a name="143018">Database=<database_name></a></div> <div class="syntax"><a name="143019">DefaultLongDataBuffLen=1024</a></div> <div class="syntax"><a name="133127">DistributedTransactionModel=0</a></div> <div class="syntax"><a name="143025">FailoverGranularity=0</a></div> <div class="syntax"><a name="131171">FailoverMode=0</a></div> <div class="syntax"><a name="143031">FailoverNetworkAddress=</a></div> <div class="syntax"><a name="131172">FailoverPreconnect=0</a></div> <div class="syntax"><a name="143037">FetchTWFSasTime=1</a></div> <div class="syntax"><a name="143038">InitializationString=</a></div> <div class="syntax"><a name="143039">InterfacesFile=</a></div> <div class="syntax"><a name="133198">InterfacesFileServerName=</a></div> <div class="syntax"><a name="143044">Language=</a></div> <div class="syntax"><a name="143045">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="143046">LoadBalancing=0</a></div> <div class="syntax"><a name="143047">LoginTimeout=15</a></div> <div class="syntax"><a name="143048">LogonID=</a></div> <div class="syntax"><a name="143049">MaxPoolSize=100</a></div> <div class="syntax"><a name="143050">MinPoolSize=0</a></div> <div class="syntax"><a name="143051">NetworkAddress=<SybaseIQ_host,SybaseIQ_server_port></a></div> <div class="syntax"><a name="143052">OptimizePrepare=1</a></div> <div class="syntax"><a name="143053">PacketSize=0</a></div> <div class="syntax"><a name="143054">Password=</a></div> <div class="syntax"><a name="143055">Pooling=0</a></div> <div class="syntax"><a name="143056">QueryTimeout=0</a></div> <div class="syntax"><a name="143057">RaiseErrorPositionBehavior=0</a></div> <div class="syntax"><a name="143058">ReportCodePageConversionErrors=0</a></div> <div class="syntax"><a name="143059">SelectMethod=0</a></div> <div class="syntax"><a name="143061">TightlyCoupledDistributedTransactions=</a></div> <div class="syntax"><a name="143062">TruncateTimeTypeFractions=0</a></div> <div class="syntax"><a name="131197">WorkStationID=</a></div> <div class="syntax"><a name="143069">XAOpenStringParameters=</a></div> <div class="syntax"><a name="143070"> </a></div> <div class="syntax"><a name="143071">[Teradata]</a></div> <div class="syntax"><a name="143072">Driver=ODBCHOME/lib/ivtera26.so</a></div> <div class="syntax"><a name="143073">Description=DataDirect 7.0 Teradata</a></div> <div class="syntax"><a name="143074">AccountString=</a></div> <div class="syntax"><a name="143075">AuthenticationDomain=</a></div> <div class="syntax"><a name="143076">AuthenticationPassword=</a></div> <div class="syntax"><a name="143077">AuthenticationUserid=</a></div> <div class="syntax"><a name="143078">CharacterSet=ASCII</a></div> <div class="syntax"><a name="143079">Database=</a></div> <div class="syntax"><a name="143080">DBCName=<Teradata_server></a></div> <div class="syntax"><a name="143081">EnableDataEncryption=0</a></div> <div class="syntax"><a name="143082">EnableExtendedStmtInfo=0</a></div> <div class="syntax"><a name="143083">EnableLOBs=1</a></div> <div class="syntax"><a name="143084">EnableReconnect=0</a></div> <div class="syntax"><a name="143085">IntegratedSecurity=0</a></div> <div class="syntax"><a name="143086">LoginTimeout=20</a></div> <div class="syntax"><a name="143087">LogonID=</a></div> <div class="syntax"><a name="143088">MapCallEscapeToExec=0</a></div> <div class="syntax"><a name="143089">MaxRespSize=8192</a></div> <div class="syntax"><a name="143090">Password=</a></div> <div class="syntax"><a name="143091">PortNumber=1025</a></div> <div class="syntax"><a name="143092">PrintOption=N</a></div> <div class="syntax"><a name="143093">ProcedureWithSplSource=Y</a></div> <div class="syntax"><a name="143094">ReportCodePageConversionErrors=0</a></div> <div class="syntax"><a name="143095">SecurityMechanism=</a></div> <div class="syntax"><a name="143096">SecurityParameter=</a></div> <div class="syntax"><a name="143097">ShowSelectableTables=1</a></div> <div class="syntax"><a name="143098">TDProfile=</a></div> <div class="syntax"><a name="143099">TDRole=</a></div> <div class="syntax"><a name="143100">TDUserName=</a></div> <div class="syntax"><a name="143101"> </a></div> <div class="syntax"><a name="143102">[Text]</a></div> <div class="syntax"><a name="143103">Driver=ODBCHOME/lib/ivtxt26.so</a></div> <div class="syntax"><a name="143104">Description=DataDirect 7.0 TextFile(*.*)</a></div> <div class="syntax"><a name="143105">AllowUpdateAndDelete=0</a></div> <div class="syntax"><a name="143106">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="143107">CacheSize=4</a></div> <div class="syntax"><a name="143108">CenturyBoundary=20</a></div> <div class="syntax"><a name="143109">Database=ODBCHOME/demo</a></div> <div class="syntax"><a name="143110">DataFileExtension=TXT</a></div> <div class="syntax"><a name="143111">DecimalSymbol=.</a></div> <div class="syntax"><a name="143112">Delimiter=,</a></div> <div class="syntax"><a name="143113">FileOpenCache=0</a></div> <div class="syntax"><a name="143114">FirstLineNames=0</a></div> <div class="syntax"><a name="143115">IntlSort=0</a></div> <div class="syntax"><a name="143116">ScanRows=25</a></div> <div class="syntax"><a name="143117">TableType=Comma</a></div> <div class="syntax"><a name="131246">UndefinedTable=GUESS</a></div> <div class="syntax"><a name="143123"> </a></div> <div class="syntax"><a name="143124">[Informix]</a></div> <div class="syntax"><a name="143125">Driver=ODBCHOME/lib/ivinf26.so</a></div> <div class="syntax"><a name="143126">Description=DataDirect 7.0 Informix</a></div> <div class="syntax"><a name="143127">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="143128">CancelDetectInterval=0</a></div> <div class="syntax"><a name="143129">CursorBehavior=0</a></div> <div class="syntax"><a name="143130">Database=<database_name></a></div> <div class="syntax"><a name="143131">EnableInsertCursors=0</a></div> <div class="syntax"><a name="143132">GetDBListFromInformix=1</a></div> <div class="syntax"><a name="143133">HostName=<Informix_host></a></div> <div class="syntax"><a name="143134">LogonID=</a></div> <div class="syntax"><a name="143135">Password=</a></div> <div class="syntax"><a name="143136">Protocol=onsoctcp</a></div> <div class="syntax"><a name="143137">ServerName=<Informix_server></a></div> <div class="syntax"><a name="143138">Service=<Informix_service_name></a></div> <div class="syntax"><a name="143139">TrimBlankFromIndexName=1</a></div> <div class="syntax"><a name="124503"> </a></div> <div class="syntax"><a name="124504">[Oracle]</a></div> <div class="syntax"><a name="124505">Driver=ODBCHOME/lib/ivor826.so</a></div> <div class="syntax"><a name="124506">Description=DataDirect 7.0 Oracle</a></div> <div class="syntax"><a name="124507">AlternateServers=</a></div> <div class="syntax"><a name="124508">ApplicationUsingThreads=1</a></div> <div class="syntax"><a name="124509">ArraySize=60000</a></div> <div class="syntax"><a name="124510">CatalogIncludesSynonyms=1</a></div> <div class="syntax"><a name="124511">CatalogOptions=0</a></div> <div class="syntax"><a name="124512">ClientVersion=9iR2 </a></div> <div class="syntax"><a name="127498">ConnectionReset=0</a></div> <div class="syntax"><a name="124513">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="124514">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="124515">DefaultLongDataBuffLen=1024</a></div> <div class="syntax"><a name="124516">DescribeAtPrepare=0</a></div> <div class="syntax"><a name="124517">EnableDescribeParam=0</a></div> <div class="syntax"><a name="124518">EnableNcharSupport=0</a></div> <div class="syntax"><a name="124519">EnableScrollableCursors=1</a></div> <div class="syntax"><a name="124520">EnableStaticCursorsForLongData=0</a></div> <div class="syntax"><a name="124521">EnableTimestampWithTimeZone=0</a></div> <div class="syntax"><a name="127502">LoadBalanceTimeout=0</a></div> <div class="syntax"><a name="124522">LoadBalancing=0</a></div> <div class="syntax"><a name="124523">LocalTimeZoneOffset=</a></div> <div class="syntax"><a name="124524">LockTimeOut=-1</a></div> <div class="syntax"><a name="124525">LogonID=</a></div> <div class="syntax"><a name="127578">MaxPoolSize=100</a></div> <div class="syntax"><a name="127579">MinPoolSize=0</a></div> <div class="syntax"><a name="127589">OptimizeLongPerformance=0</a></div> <div class="syntax"><a name="124526">Password=</a></div> <div class="syntax"><a name="127583">Pooling=0</a></div> <div class="syntax"><a name="124528">ProcedureRetResults=0</a></div> <div class="syntax"><a name="124529">ReportCodePageConversionErrors=0</a></div> <div class="syntax"><a name="124530">ReportRecycleBin=0</a></div> <div class="syntax"><a name="124531">ServerName=<Oracle_server></a></div> <div class="syntax"><a name="124532">TimestampEscapeMapping=0</a></div> <div class="syntax"><a name="124533">UseCurrentSchema=1</a></div> <div class="syntax"><a name="124615"> </a></div> <div class="syntax"><a name="124616">[SQLServ Legacy Wire Protocol]</a></div> <div class="syntax"><a name="124617">Driver=ODBCHOME/lib/ivmsss26.so</a></div> <div class="syntax"><a name="124618">Description=DataDirect 7.0 SQL Server Legacy Wire Protocol</a></div> <div class="syntax"><a name="124619">Address=<SQLServer_host, SQLServer_server_port></a></div> <div class="syntax"><a name="124620">AlternateServers=</a></div> <div class="syntax"><a name="124621">AnsiNPW=Yes</a></div> <div class="syntax"><a name="124622">ConnectionRetryCount=0</a></div> <div class="syntax"><a name="124623">ConnectionRetryDelay=3</a></div> <div class="syntax"><a name="124624">Database=<database_name></a></div> <div class="syntax"><a name="124625">FetchTSWTZasTimestamp=0</a></div> <div class="syntax"><a name="124626">FetchTWFSasTime=0</a></div> <div class="syntax"><a name="124627">LoadBalancing=0</a></div> <div class="syntax"><a name="124628">LogonID=</a></div> <div class="syntax"><a name="124629">Password=</a></div> <div class="syntax"><a name="124630">QuotedId=No</a></div> <div class="syntax"><a name="124631">ReportCodepageConversionErrors=0</a></div> <div class="syntax"><a name="124632">SnapshotSerializable=0</a></div> <div class="syntax"><a name="106799"> </a></div> <div class="syntax"><a name="106800">[ODBC]</a></div> <div class="syntax"><a name="106801">IANAAppCodePage=4</a></div> <div class="syntax"><a name="106802">InstallDir=ODBCHOME</a></div> <div class="syntax"><a name="106804">Trace=0</a></div> <div class="syntax"><a name="106805">TraceFile=odbctrace.out</a></div> <div class="syntax"><a name="106806">TraceDll=ODBCHOME/lib/iv26trc.so</a></div> <div class="syntax"><a name="127281">ODBCTraceMaxFileSize=102400</a></div> <div class="syntax"><a name="127282">ODBCTraceMaxNumFiles=10</a></div> <div class="Body"><a name="108200">To modify or create data sources in the odbc.ini file, use the following procedures.</a></div> <div class="hanging_label_head"><a name="107076">To modify a data source:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="107077">Using a text editor, open the odbc.ini file.</a></div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107078">Modify the default attributes in the data source definitions as necessary based on your </a>system specifics, for example, enter the host name and port number of your system in the appropriate location.</div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="107079">Consult the "Connection String Attributes" table of each driver chapter for other specific </a>attribute values.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107080">After making all modifications, save the odbc.ini file and close the text editor.</a></div> </td> </tr> </table> </div> <div class="Body"><a name="107081">IMPORTANT: The "Connection Option Descriptions" section of each driver chapter</a><span class="Emphasis"> </span>lists both the long and short names of the attribute. When entering attribute names into odbc.ini, you must use the long name of the attribute. The short name is not valid in the odbc.ini file.</div> <div class="hanging_label_head"><a name="107082">To create a new data source:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="107083">Using a text editor, open the odbc.ini file.</a></div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107084">Copy an appropriate existing default data source definition and paste it to another </a>location in the file.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107085">Change the data source name in the copied data source definition to a new name. The </a>data source name is between square brackets at the beginning of the definition, for example, <span class="Syntax">[Oracle Wire Protocol]</span>.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107086">Modify the attributes in the new definition as necessary based on your system specifics, </a>for example, enter the host name and port number of your system in the appropriate location.</div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="123620">Consult the "Connection String Attributes" table of each driver chapter for other specific </a>attribute values.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">5 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107088">In the </a><span class="Syntax">[ODBC]</span> section at the beginning of the file, add a new <span class="Emphasis">data_source_name=</span><span class="Emphasis">installed-driver</span> pair containing the new data source name and the appropriate installed driver name.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">6 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107089">After making all modifications, save the odbc.ini file and close the text editor.</a></div> </td> </tr> </table> </div> <div class="Body"><a name="107090">IMPORTANT: The "Connection String Attributes" table of each driver chapter</a><span class="Emphasis"> </span>lists both the long and short name of the attribute. When entering attribute names into odbc.ini, you must use the long name of the attribute. The short name is not valid in the odbc.ini file.</div> <div class="head_3"><a name="107092">Translators</a></div> <div class="Body"><a name="107093">Progress DataDirect provides a sample translator named "OEM to ANSI" that provides a </a>framework for coding a translation library. Refer to the readme.trn file in the /samples/src/trn subdirectory in the product installation directory for details.</div> <div class="Body"><a name="107094">To perform a translation with a particular driver, you must include the </a>TranslationSharedLibrary keyword in that driverâ??s data source definition in the odbc.ini file. The TranslationSharedLibrary keyword represents the full path to the translation library.</div> <div class="Body"><a name="107109">For example, the </a>32-bit DB2 driver would be:</div> <div class="syntax_first"><a name="107110">[DB2]</a></div> <div class="syntax"><a name="107111">Driver=ODBCHOME/lib/ivdb226.so</a></div> <div class="syntax"><a name="107112">Description=DataDirect 7.0 DB2 Wire Protocol</a></div> <div class="syntax"><a name="107113">TranslationSharedLibrary=ODBCHOME/lib/ivtrn26.so</a></div> <div class="Body"><a name="107114">The TranslationOption keyword is the ASCII representation of the 32-bit integer translation </a>option. Use of the TranslationOption keyword is optional.</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