Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\quikstart.04.3.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>Configuring and Connecting on UNIX and Linux</title> <link rel="StyleSheet" href="css/quikstart.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="quikstart.04.1.html#106159">1 Quick Start Connect</a> : Configuring and Connecting on UNIX and Linux</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106159">Configuring and Connecting on UNIX and Linux</a></div> <div class="Body"><a name="106163">The following basic information enables you to configure a data source and test connect </a>with a driver immediately after installation. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.1.html#116869', '');">Chapter 4 â??Configuring the Product on UNIX/Linuxâ??</a></span> for detailed information about configuring the UNIX/Linux environment and data sources.</div> <div class="Body"><a name="106171">NOTE: In the following examples, </a><span class="Emphasis">xx</span> in a driver filename represents the driver level number.</div> <div class="head_2"><a name="106174">Environment Configuration</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="106175">Check your permissions: You must log in as a user with full r/w/x permissions </a>recursively on the entire product installation directory.</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="106176">From your login shell, determine which shell you are running by executing:</a></div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="106177">echo $SHELL</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">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106178">Run one of the following product setup scripts from the installation directory to set </a>variables: odbc.sh or odbc.csh. For Korn, Bourne, and equivalent shells, execute odbc.sh. For a C shell, execute odbc.csh. After running the setup script, execute:</div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="106179">env</a></div> <div class="Body_Indent"><a name="106180">to verify that the </a><span class="Emphasis">installation_directory</span>/lib directory has been added to your shared library path.</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="106181">Set the ODBCINI environment variable. The variable must point to the path from the </a>root directory to the system information file where your data source resides. The system information file can have any name, but the product is installed with a default file called odbc.ini in the product installation directory. For example, if you use an installation directory of /opt/odbc and the default system information file, from the Korn or Borne shell, you would enter:</div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="106182">ODBCINI=/opt/odbc/odbc.ini; export ODBCINI</a></div> <div class="Body_Indent"><a name="106183">From the C shell, you would enter:</a></div> <div class="syntax_embed_first"><a name="106184">setenv ODBCINI /opt/odbc/odbc.ini</a></div> <div class="head_2"><a name="106186">Test Loading the Driver</a></div> <div class="Body"><a name="119249">The ivtestlib (32-bit drivers) and ddtestlib (64-bit drivers) test loading tools are provided to </a>test load drivers and help diagnose configuration problems in the UNIX and Linux environments, such as environment variables not correctly set or missing database client components. This tool is installed in the /bin subdirectory in the product installation directory. It attempts to load a specified ODBC driver and prints out all available error information if the load fails. </div> <div class="Body"><a name="119251">For example, if the drivers are installed in /opt/odbc/lib, the following command attempts to </a>load the 32-bit Oracle Wire Protocol driver on Solaris, where <span class="EquationVariables">xx</span> represents the version number of the driver:</div> <div class="syntax_first"><a name="119252">ivtestlib /opt/odbc/lib/ivora</a><span class="EquationVariables">xx</span>.so</div> <div class="Body"><a name="119253">NOTE: On Solaris, AIX, and Linux, the full path to the driver does not have to be specified </a>for the tool. The HP-UX version, however, requires the full path.</div> <div class="Body"><a name="119254">If the load is successful, the tool returns a success message along with the version string of </a>the driver. If the driver cannot be loaded, the tool returns an error message explaining why.</div> <div class="head_2"><a name="117559">Setting the Library Path Environment Variable (Salesforce </a>Driver on UNIX/Linux)</div> <div class="Body"><a name="117862">Before you can use the Salesforce driver, you must set the library path environment variable </a>for your UNIX/Linux operating system to the directory containing your JVMâ??s libjvm.so [sl | a] file, and that directoryâ??s parent directory. </div> <div class="Body"><a name="117867">NOTE FOR HP-UX: You also must set the LD_PRELOAD environment variable to the fully </a>qualified path of the libjvm.so.</div> <div class="hanging_label_head"><a name="117562">32-bit Salesforce Driver: Library Path Environment Variable</a></div> <div class="Body"><a name="118018">Set the library path environment variable to the directory containing your 32-bit JVMâ??s </a>libjvm.so [sl | a] file, and that directoryâ??s parent directory.</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="117563">LD_LIBRARY_PATH on Solaris, Linux, and HP-UX (Itanium) </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="117564">SHLIB_PATH on HP PA-RISC</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="117565">LIBPATH on AIX </a></div> </td> </tr> </table> </div> <div class="hanging_label_head"><a name="117566">64-bit Salesforce Driver: Library Path Environment Variable</a></div> <div class="Body"><a name="118022">Set the library path environment variable to the directory containing your 64-bit JVMâ??s </a>libjvm.so [sl | a] file, and that directoryâ??s parent directory.</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="117567">LD_LIBRARY_PATH on Solaris, HP-UX (Itanium), and Linux </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="117568">LIBPATH on AIX </a></div> </td> </tr> </table> </div> <div class="head_2"><a name="106194">Configuring a Data Source</a></div> <div class="Body"><a name="116004">If you have Motif 2.0.3 or higher and one of the supported Linux operating systems, you can </a>use the DataDirect ODBC Data Source Administrator for Linux (the Linux ODBC Administrator) to configure a data source. 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> for instructions on configuring the system information file.</div> <div class="Body"><a name="115477">NOTE: The Linux ODBC Administrator is currently supported only on Linux for x86 and x64 </a>processors with Motif 2.0.3 or higher. It is not supported on Linux for Itanium II or other UNIX platforms.</div> <div class="Body"><a name="106195">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="106196">/opt/odbc/tools/odbcadmin</a></div> <div class="hanging_label_head"><a name="106197">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="115972">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="115973">./odbcadmin</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="115974">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="106201">User DSN</a></span>: 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="106202">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="106203">File DSN</a></span>: To configure a new file data source, click <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> </td> </tr> </table> </div> <div class="Body_Indent"><a name="106204">The General tab of the Setup dialog box appears by default.</a></div> <div class="Body_Indent"><a name="106205">NOTE: The General tab displays only fields that are required for creating a data source. </a>The fields on all other tabs are optional, unless noted otherwise in this book.</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="106206">The following two options appear on the General tab of all driver Setup dialog boxes:</a></div> </td> </tr> </table> </div> <div class="Body_Indent"><span class="Action_bold"><a name="106207">Data Source Name</a></span>: Type a string that identifies this data source configuration, such as Accounting.</div> <div class="Body_Indent"><span class="Action_bold"><a name="106208">Description</a></span>: Type an optional long description of a data source name, such as My Accounting Database.</div> <div class="Body_Indent"><a name="106209">Provide the requested information for all other options on the General tab; then, click </a><span class="Action_bold">Apply</span> to configure the data source.</div> <div class="head_2"><a name="106271">Testing the Connection</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="106272">After you have configured the data source, you can click </a><span class="Action_bold">Test Connect</span> on the Setup dialog box to attempt to connect to the data source using the connection options specified in the dialog box. Some drivers immediately return a message indicating success or failure. For most drivers, a logon dialog box appears as described in each individual driver chapter.</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="106273">Supply the requested information in the logon dialog box and click </a><span class="Action_bold">OK</span>. Note that the information you enter in the logon dialog box during a test connect is not saved.</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"><a name="106274">If the driver can connect, it releases the connection and displays a </a><span class="Syntax">Connection </span><span class="Syntax">Established</span> message. Click <span class="Action_bold">OK</span>.</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"><a name="106275">If the driver cannot connect because of an incorrect environment or connection </a>value, it displays an appropriate error message. Click <span class="Action_bold">OK</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">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106276">On the driver Setup dialog box, click </a><span class="Action_bold">OK</span>. The values you have specified are saved and are the defaults used when you connect to the data source. You can change these defaults by using the previously described procedure to modify your data source. You can override these defaults by connecting to the data source using a connection string with alternate values. See individual driver chapters for information about using connection strings.</div> </td> </tr> </table> </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