[mapguide-users] Cannot connect MapGuide 3.1.2 to OrcaleClient

[Gunter Becker]

Hi,

I got it!

The settings in system variables has been already correct.

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.

Thanks all for your support,
Gunter

Von: mapguide-users <mapguide-users-bounces at lists.osgeo.org> Im Auftrag von mark volz
Gesendet: Donnerstag, 29. September 2022 20:54
An: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Betreff: Re: [mapguide-users] Cannot connect MapGuide 3.1.2 to OrcaleClient

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.



________________________________
From: Gunter Becker <gunter.becker at csoinfo.de<mailto:gunter.becker at csoinfo.de>>
Sent: Friday, 30 September 2022 12:51 am
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Cannot connect MapGuide 3.1.2 to OrcaleClient

Hi Giovanni,

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.

Thanks, Gunter

Von: mapguide-users <mapguide-users-bounces at lists.osgeo.org<mailto:mapguide-users-bounces at lists.osgeo.org>> Im Auftrag von Giovanni Tommasi
Gesendet: Donnerstag, 29. September 2022 16:21
An: MapGuide Users Mail List <mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>>
Betreff: [mapguide-users] R: Cannot connect MapGuide 3.1.2 to OrcaleClient

Hi,
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.
You can also install both client, in the worst case :)

Could you check the version of MapGuide installed and the Oracle client?

Best regards
Giovanni

Da: mapguide-users <mapguide-users-bounces at lists.osgeo.org<mailto:mapguide-users-bounces at lists.osgeo.org>> Per conto di Gunter Becker
Inviato: giovedì 29 settembre 2022 16:13
A: MapGuide Users Mail List <mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>>
Oggetto: [mapguide-users] Cannot connect MapGuide 3.1.2 to OrcaleClient


Hi,



I have to reinstall our WebMapping-Application on a Windows Server 2019 but have no luck in connecting MapGuide to an Oracle Database.

The error I get is:



ORA-12154 - TNS:could not resolve the connect identifier specified



I'va already installed Orcale client (v12) and confirmed that it connects correctly to he DB (v11) via tnsping and SQLPlus.

Additionally I also tested the connection with the newest version of FDO Toolbox which works just fine.



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.

And I also tried the dll from FDO Toolbox.



So I'm running out of ideas how I can resolve the connction problem.



Any help is highly appreciatedMapGuide.



Thanks, Gunter

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20220930/f7d95e8e/attachment.htm>