<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Nur Text Zchn";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.NurTextZchn
{mso-style-name:"Nur Text Zchn";
mso-style-priority:99;
mso-style-link:"Nur Text";
font-family:Consolas;}
span.E-MailFormatvorlage21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I got it! <o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">The settings in system variables has been already correct.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Only thing I had to do was starting the MapGuide service with a more privileged account. I don’t know why I have to do this because on our old machine (Windows 2012) the „Local System“ was sufficent.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Thanks all for your support,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Gunter<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> mapguide-users <mapguide-users-bounces@lists.osgeo.org>
<b>Im Auftrag von </b>mark volz<br>
<b>Gesendet:</b> Donnerstag, 29. September 2022 20:54<br>
<b>An:</b> MapGuide Users Mail List <mapguide-users@lists.osgeo.org><br>
<b>Betreff:</b> Re: [mapguide-users] Cannot connect MapGuide 3.1.2 to OrcaleClient<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div id="nine_body_n1838a9-68852">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D">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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D"><o:p> </o:p></span></p>
</div>
<div id="nine-sign-n1838a9-68852">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D"><o:p> </o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D"><o:p> </o:p></span></p>
</div>
</div>
<div id="quoted_header_n1838a9-68852">
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" noshade="" style="color:#E1E1E1" align="center">
</div>
<div>
<div>
<p class="MsoNormal"><b>From:</b> Gunter Becker <<a href="mailto:gunter.becker@csoinfo.de">gunter.becker@csoinfo.de</a>><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<o:p></o:p></p>
</div>
</div>
</div>
<div id="quoted_body_n1838a9-68852">
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal">Hi Giovanni,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks, Gunter<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<div>
<p class="MsoNormal"><b>Von:</b> mapguide-users <<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>>
<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 <<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>><br>
<b>Betreff:</b> [mapguide-users] R: Cannot connect MapGuide 3.1.2 to OrcaleClient<o:p></o:p></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span lang="EN-GB">Hi,</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">You can also install both client, in the worst case :)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">Could you check the version of MapGuide installed and the Oracle client?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">Best regards</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">Giovanni</span><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<div>
<p class="MsoNormal"><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><o:p></o:p></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span lang="IT"> </span><o:p></o:p></p>
</div>
<p class="MsoPlainText"><span lang="EN-GB">Hi,</span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span><o:p></o:p></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><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB">The error I get is: </span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB">ORA-12154 - TNS:could not resolve the connect identifier specified</span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span><o:p></o:p></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><o:p></o:p></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><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span><o:p></o:p></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><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB">And I also tried the dll from FDO Toolbox.
</span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB">So I'm running out of ideas how I can resolve the connction problem.</span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB">Any help is highly appreciatedMapGuide.</span><o:p></o:p></p>
<p class="MsoPlainText"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoPlainText">Thanks, Gunter<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>