<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div style="font-family:Calibri, Arial, Helvetica, sans-serif; font-size:12.0pt; line-height:1.3; color:#1F497D" id="nine_body_n1838a9-68852" class="nine_body" dir="auto">
<div class="nine-pg" dir="auto">Make sure that the system variable "oracle_home" is set to the root folder of Oracle client, and that Oracle client's bin folder is in the "path" system variable.</div>
<div class="nine-pg blank sign" dir="auto"><br>
</div>
<div id="nine-sign-n1838a9-68852" class="nine_signature nine-pg" dir="auto">
<div class="nine-pg" dir="auto"><br>
</div>
</div>
<div class="nine-pg blank msg" dir="auto"><br>
</div>
</div>
<div id="quoted_header_n1838a9-68852" class="quoted_header_editor" dir="auto">
<hr style="border:none; height:1px; color:#E1E1E1; background-color:#E1E1E1;">
<div style="border:none; padding:3.0pt 0cm 0cm 0cm" dir="auto" class="nine-pg">
<div class="nine-pg" dir="auto"><span style="font-size:11.0pt;font-family:Calibri, Arial, Helvetica, sans-serif"><b>From:</b> Gunter Becker <gunter.becker@csoinfo.de><br>
<b>Sent:</b> Friday, 30 September 2022 12:51 am<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> Re: [mapguide-users] Cannot connect MapGuide 3.1.2 to OrcaleClient<br>
</span></div>
</div>
</div>
<div id="quoted_body_n1838a9-68852" class="quoted_body_editor mceEditable" dir="auto">
<div class="nine-pg" dir="auto"><br type="attribution">
</div>
<style id="quoted_style_n1838a9-68852">p.MsoNormal, li.MsoNormal, div.MsoNormal { margin:0cm; }</style><style id="quoted_style_n1838a9-68852_0">
/* modified by nine */
@font-face { font-family: "Cambria Math"; }
@font-face { font-family: Calibri; }
@font-face { font-family: Consolas; }
#nine_body_n1838a9-68852 + div + div p.MsoNormal, #nine_body_n1838a9-68852 + div + div li.MsoNormal, #nine_body_n1838a9-68852 + div + div div.MsoNormal { margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; }
#nine_body_n1838a9-68852 + div + div a:link, #nine_body_n1838a9-68852 + div + div span.MsoHyperlink { color: rgb(5, 99, 193); text-decoration: underline; }
#nine_body_n1838a9-68852 + div + div p.MsoPlainText, #nine_body_n1838a9-68852 + div + div li.MsoPlainText, #nine_body_n1838a9-68852 + div + div div.MsoPlainText { margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; }
#nine_body_n1838a9-68852 + div + div span.NurTextZchn { font-family: Consolas; }
#nine_body_n1838a9-68852 + div + div span.E-MailFormatvorlage24 { font-family: Calibri, sans-serif; color: windowtext; }
#nine_body_n1838a9-68852 + div + div .MsoChpDefault { font-size: 10pt; }
@page WordSection1 { margin: 70.85pt 70.85pt 2cm; }
#nine_body_n1838a9-68852 + div + div div.WordSection1 { }
</style>
<div lang="DE" style="word-wrap:break-word" dir="auto">
<div class="WordSection1">
<div class="nine-pg MsoNormal" dir="auto">Hi Giovanni,</div>
<div class="nine-pg MsoNormal" dir="auto"> </div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB">I’ve already checked this. MapGuide is 64-bit and so is the Oracle client. I’ve also tried the 32-bit Oracle client but then I got an even worse error: MapGuide could’nt load the dll's at all.</span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB"> </span></div>
<div class="nine-pg MsoNormal" dir="auto">Thanks, Gunter</div>
<div class="nine-pg MsoNormal" dir="auto"> </div>
<div>
<div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm">
<div class="nine-pg MsoNormal" dir="auto"><b>Von:</b> mapguide-users <mapguide-users-bounces@lists.osgeo.org>
<b>Im Auftrag von </b>Giovanni Tommasi<br>
<b>Gesendet:</b> Donnerstag, 29. September 2022 16:21<br>
<b>An:</b> MapGuide Users Mail List <mapguide-users@lists.osgeo.org><br>
<b>Betreff:</b> [mapguide-users] R: Cannot connect MapGuide 3.1.2 to OrcaleClient</div>
</div>
</div>
<div class="nine-pg MsoNormal" dir="auto"> </div>
<div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB">Hi,</span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB">in other similar context you have to use Oracle client 32-bit for 32-bit application and Oracle client 64-bit for 64-bit application.</span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB">You can also install both client, in the worst case :)</span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB"> </span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB">Could you check the version of MapGuide installed and the Oracle client?</span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB"> </span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB">Best regards</span></div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-GB">Giovanni</span></div>
</div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="EN-US"> </span></div>
<div>
<div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm">
<div class="nine-pg MsoNormal" dir="auto"><b><span lang="IT">Da:</span></b><span lang="IT"> mapguide-users <<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>>
<b>Per conto di </b>Gunter Becker<br>
<b>Inviato:</b> giovedì 29 settembre 2022 16:13<br>
<b>A:</b> MapGuide Users Mail List <<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>><br>
<b>Oggetto:</b> [mapguide-users] Cannot connect MapGuide 3.1.2 to OrcaleClient</span></div>
</div>
</div>
<div class="nine-pg MsoNormal" dir="auto"><span lang="IT"> </span></div>
<p class="MsoPlainText"><span lang="EN-GB">Hi,</span></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span></p>
<p class="MsoPlainText"><span lang="EN-GB">I have to reinstall our WebMapping-Application on a Windows Server 2019 but have no luck in connecting MapGuide to an Oracle Database.</span></p>
<p class="MsoPlainText"><span lang="EN-GB">The error I get is: </span></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span></p>
<p class="MsoPlainText"><span lang="EN-GB">ORA-12154 - TNS:could not resolve the connect identifier specified</span></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span></p>
<p class="MsoPlainText"><span lang="EN-GB">I'va already installed Orcale client (v12) and confirmed that it connects correctly to he DB (v11) via tnsping and SQLPlus.
</span></p>
<p class="MsoPlainText"><span lang="EN-GB">Additionally I also tested the connection with the newest version of FDO Toolbox which works just fine.</span></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span></p>
<p class="MsoPlainText"><span lang="EN-GB">I'm also aware of newer dll's for client v12 that I found on osgeo.org and I replaced the old ones for oracle client v11.
</span></p>
<p class="MsoPlainText"><span lang="EN-GB">And I also tried the dll from FDO Toolbox.
</span></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span></p>
<p class="MsoPlainText"><span lang="EN-GB">So I'm running out of ideas how I can resolve the connction problem.</span></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span></p>
<p class="MsoPlainText"><span lang="EN-GB">Any help is highly appreciatedMapGuide.</span></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span></p>
<p class="MsoPlainText">Thanks, Gunter</p>
<div class="nine-pg MsoNormal" dir="auto"> </div>
</div>
</div>
</div>
</body>
</html>