Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\troubleshooting\trblshooting.5.2.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>Setup/Connection Issues</title> <link rel="StyleSheet" href="css/trblshooting.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="trblshooting.5.1.html#106133">3 Troubleshooting</a> : Setup/Connection Issues</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106133">Setup/Connection Issues</a></div> <div class="Body"><a name="106134">You are experiencing a setup/connection issue if you are encountering an error or hang </a>while you are trying to make a database connection with the ODBC driver or are trying to configure the ODBC driver.</div> <div class="Body"><a name="106135">Some common errors that are returned by the ODBC driver if you are experiencing a </a>setup/connection issue include:</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><span class="Syntax"><a name="106136">Specified driver could not be loaded.</a></span> </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"><span class="Syntax"><a name="106137">Data source name not found and no default driver specified.</a></span> </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"><span class="Syntax"><a name="106138">Cannot open shared library: libodbc.sl. </a></span></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"><span class="Syntax"><a name="106139">ORA-12203: Unable to connect to destination. </a></span></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"><span class="Syntax"><a name="106140">ORA-01017: invalid username/password; logon denied. </a></span></div> </td> </tr> </table> </div> <div class="head_2"><a name="106141">Troubleshooting the Issue</a></div> <div class="Body"><a name="106142">Some common reasons that setup/connection issues occur are:</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="106143">The library path environment variable is not set correctly.</a></div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="107915">NOTE: The 32-bit and 64-bit Salesforce driver require that you set the library path </a>environment for your operating system to the directory containing your 32-bit JVMâ??s libjvm.so [sl | a] file, and that directoryâ??s parent directory before using the driver.</div> <div class="Body_Indent"><a name="108121">HP-UX ONLY: </a></div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><a name="108122">When setting the library path environment variable on HP-UX operating systems, </a>specifying the parent directory is not required.</div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><a name="108123">You also must set the LD_PRELOAD environment variable to the fully qualified path </a>of the libjvm.so[sl].</div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="108095">The library path environment variable is:</a></div> <div class="Body_Indent"><span class="Action_bold"><a name="106589">32-bit Drivers</a></span> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><a name="106144">PATH on Windows</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="108009">LD_LIBRARY_PATH on Solaris, Linux and HP-UX Itanium</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="108010">SHLIB_PATH on HP-UX PA_RISC </a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="106594">LIBPATH on AIX </a></div> </td> </tr> </table> </div> <div class="Body_Indent"><span class="Action_bold"><a name="108018">64-bit Drivers</a></span> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><a name="106595">PATH on Windows</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="106596">LD_LIBRARY_PATH on Solaris, HP-UX, and Linux</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="106597">LIBPATH on AIX</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="106149">The database and/or listener are not started.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="106150">The ODBCINI environment variable is not set correctly for the ODBC drivers on UNIX </a>and Linux.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="106777">The ODBC driverâ??s connection attributes are not set correctly in the system information </a>file on UNIX and Linux (refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#108296', '');">â??Data Source Configurationâ??</a></span> in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.1.html#116869', '');">Chapter 4</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;"> Userâ??s Guide</span>). For example, the host name or port number are not correctly configured. Refer to individual driver chapters 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;"> Userâ??s Guide</span> for a list of connection string attributes that are required for each driver to connect properly to the underlying database.</div> </td> </tr> </table> </div> <div class="Body"><a name="106800">For UNIX and Linux users: Refer to </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.1.html#116869', '');">Chapter 4 â??Configuring the Product on UNIX/Linuxâ??</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;"> Userâ??s Guide</span> for more information. See also <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.3.html#107494', '');">â??The Test Loading Toolâ??</a></span> for information about a helpful diagnostic tool.</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