[mapguide-users] How to connect oracle by using Mapguide Maestro

Discussion:

padmini godavarthi

2008-11-11 06:57:10 UTC

hI,
iam using mapguide opensource 2.0( With .Net 2.0 + IIS)
I want to create one mgp by using oracle spatial data
Now my problem is that i could not found to connect orascle data by using
mapguide maestro.

If anybody knows plz help me

Thanks and Regards,
Padmini

--
View this message in context: http://www.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp20434439p20434439.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

Simon Pelicon

2008-11-11 07:32:16 UTC

Permalink

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi! 
If you are using MapGuide Open source, you have to install King Oracle
provider. 
Link for for installation instructions: <a
href="http://www.sl-king.com/fdooracle/download/README.txt">http://www.sl-king.com/fdooracle/download/README.txt</a><span
class="Apple-style-span"
style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'times new roman'; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"> 
Regards, 
Simon 
 
padmini godavarthi wrote:
<blockquote cite="mid:***@talk.nabble.com" type="cite">
<pre wrap="">

hI,
iam using mapguide opensource 2.0( With .Net 2.0 + IIS)
I want to create one mgp by using oracle spatial data
Now my problem is that i could not found to connect orascle data by using
mapguide maestro.

If anybody knows plz help me

Thanks and Regards,
Padmini
</pre>
</blockquote>
</body>
</html>

Kenneth Skovhede, GEOGRAF A/S

2008-11-11 09:13:12 UTC

Permalink

I have put up instructions for installing extra providers here:
http://trac.osgeo.org/mapguide/wiki/maestro/UserGuides/UpdatingFDOInstallation

And basic setup for a database connection is here:
http://trac.osgeo.org/mapguide/wiki/maestro/UserGuides/RDBMSFeatureSource

There is some background info and more here:
http://trac.osgeo.org/mapguide/wiki/maestro/UserGuide

Regards, Kenneth Skovhede, GEOGRAF A/S

Post by Simon Pelicon
Hi!
If you are using MapGuide Open source, you have to install King Oracle
provider.
http://www.sl-king.com/fdooracle/download/README.txt
Regards,
Simon

Post by padmini godavarthi
hI,
iam using mapguide opensource 2.0( With .Net 2.0 + IIS)
I want to create one mgp by using oracle spatial data
Now my problem is that i could not found to connect orascle data by using
mapguide maestro.
If anybody knows plz help me
Thanks and Regards,
Padmini

------------------------------------------------------------------------
_______________________________________________
mapguide-users mailing list
http://lists.osgeo.org/mailman/listinfo/mapguide-users

padmini godavarthi

2008-11-13 09:52:26 UTC

Permalink

Hi Kenneth ,
Thanks for u r reply.
I followed these links,its was really very helpful to me.
I was created one mgp by using mapguide maestro with oracle 10g spatial( by
using OSGeo FDO Provider for oracle) , but while seeing it in browser by
using map view ajax application by using tis url

http://localhost/mapguide/mapviewerajax/ajaxviewer.aspx/?WEBLAYOUT=Library%3a%2f%2fSamples%2fOracle%2fLayouts%2fOraclemap.WebLayout

iam unable to see the map .its displays only layot without displaying the
map.

if anybody is aware of this plz help me

Regards,
Padmini

Post by Kenneth Skovhede, GEOGRAF A/S
http://trac.osgeo.org/mapguide/wiki/maestro/UserGuides/UpdatingFDOInstallation
http://trac.osgeo.org/mapguide/wiki/maestro/UserGuides/RDBMSFeatureSource
http://trac.osgeo.org/mapguide/wiki/maestro/UserGuide
Regards, Kenneth Skovhede, GEOGRAF A/S

Post by Simon Pelicon
Hi!
If you are using MapGuide Open source, you have to install King Oracle
provider.
http://www.sl-king.com/fdooracle/download/README.txt
Regards,
Simon

_______________________________________________
mapguide-users mailing list
http://lists.osgeo.org/mailman/listinfo/mapguide-users

--
View this message in context: http://www.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp20434439p20477710.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

open_saucer

2017-05-03 12:12:37 UTC

Permalink

Hey guys I still cannot seem to connect to Oracle, hence bumping this old
thread.

I've downloaded the KingOracle FDO provider and extracted with a Bin folder
containing 3 dlls. I stop MG service, and I grab the 3 dlls and put it in
my C:\Program Files\OSGeo\MapGuide\Server\Fdo folder. Start the MG service
again and went into Maestro and click on Feature Source, the dialog window
pop up with all the usual option providers but No Oracle.

Should I also install a Oracle Client on the MG's machine as well?

Machine 1: MG Open Source 2.6 and Maestro
Machine 2: Oracle 11g r2

Thanks guys!

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319237.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

Jackie Ng

2017-05-03 12:53:57 UTC

Permalink

Yes, you need the Oracle client on the machine w/ the FDO provider.

Putting OCI.dll and friends on in the same FDO directory where the FDO
provider dll is and restarting the MapGuide Server should do it.

- Jackie

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319242.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

open_saucer

2017-05-03 17:44:44 UTC

Permalink

Thanks Jackie,
What do you mean OCI.dll? when I extract the tar.gz I only get three dlls.
Is there some other files or dlls that I have to have?

<Loading Image...

>

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319309.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

gom

2017-05-03 19:43:16 UTC

Permalink

Gord McKenzie

2017-05-03 18:46:49 UTC

Permalink

You should download and install the Oracle Instant client from Oracle's website. You will need to create a user account with Oracle. There are 32 and 64 bit versions of the client as well as for different versions of Oracle. If the oci.dll folder is on your path it should work but like a lot of these things you may have to experiment a little to get things to work.

Hope that points you in the right direction.

-----Original Message-----
From: mapguide-users [mailto:mapguide-users-***@lists.osgeo.org] On Behalf Of open_saucer
Sent: Wednesday, May 03, 2017 11:45 AM
To: mapguide-***@lists.osgeo.org
Subject: Re: [mapguide-users] How to connect oracle by using Mapguide Maestro

Thanks Jackie,
What do you mean OCI.dll? when I extract the tar.gz I only get three dlls.
Is there some other files or dlls that I have to have?

<http://osgeo-org.1560.x6.nabble.com/file/n5319309/dlls.png>

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319309.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-***@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

mark

2017-05-03 20:08:59 UTC

Permalink

You also need to update the providers.xml, in /server/fdo/bin, to include the king dll.
null

open_saucer

2017-05-04 03:27:08 UTC

Permalink

Ok still cannot get it to work. This is my workflow, if I'm leaving anything
out please let me know.

Machine 1(Windows Server 2012 R2): Oracle 11g r2 32bit installed

Machine 2(Windows Server 2008 R2: MG Open Source 2.6 and Maestro 5.1
Installed. Then install Oracle Client 32bit- full installation with
Administrator. Put in the tnsnames.ora, was able to access db on Machine 1
via sqlplus and sql Devloper. Downloaded fdokingoracle - 3.9.0 6802.tar.gz,
extracted out to a default folder named "Bin", inside there are 3
dlls.(KingOracleMessage, KingOracleOverrides,KingOracleProvider). Copy the 3
dlls into the FDO folder(see 2nd screenshot). Restart Machine 2, then start
up Maestro and Feature Source via New Resource but no Oracle Provider
present in the Select FDO Provider dialog window. I've attached some
screenshot of my MG installed path/environment

Also at Mark_Volz(LeapCAD); I can't find the "providers.xml" anywhere in my
MG path/environment.

<Loading Image...

>
<Loading Image...

>

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319332.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

Jackie Ng

2017-05-04 03:29:47 UTC

Permalink

providers.xml is there (in your 2nd screenshot).

It just missed your radar because Windows Explorer stupidly hides file
extensions by default.

- Jackie

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319333.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

open_saucer

2017-05-04 12:32:05 UTC

Permalink

Thanks Jackie, now that I've edited the xml
I got 2 errors happened after I click on Oracle Provider in the Select FDO
Provider dialog box.

<Loading Image...

>
<Loading Image...

>

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319378.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

Martin Morrison

2017-05-04 12:39:26 UTC

Permalink

Providers.xml should be in the folder where FDO dll's are.

Martin Morrison
Infrastructure Application Engineer/Systems Analyst
Engineering Design Systems, Inc.
540.345.1410
***@edsi.com

www.edsi.com

-----Original Message-----
From: mapguide-users [mailto:mapguide-users-***@lists.osgeo.org] On Behalf Of open_saucer
Sent: Wednesday, May 3, 2017 11:27 PM
To: mapguide-***@lists.osgeo.org
Subject: Re: [mapguide-users] How to connect oracle by using Mapguide Maestro

Ok still cannot get it to work. This is my workflow, if I'm leaving anything out please let me know.

Machine 1(Windows Server 2012 R2): Oracle 11g r2 32bit installed

Machine 2(Windows Server 2008 R2: MG Open Source 2.6 and Maestro 5.1 Installed. Then install Oracle Client 32bit- full installation with Administrator. Put in the tnsnames.ora, was able to access db on Machine 1 via sqlplus and sql Devloper. Downloaded fdokingoracle - 3.9.0 6802.tar.gz, extracted out to a default folder named "Bin", inside there are 3 dlls.(KingOracleMessage, KingOracleOverrides,KingOracleProvider). Copy the 3 dlls into the FDO folder(see 2nd screenshot). Restart Machine 2, then start up Maestro and Feature Source via New Resource but no Oracle Provider present in the Select FDO Provider dialog window. I've attached some screenshot of my MG installed path/environment

Also at Mark_Volz(LeapCAD); I can't find the "providers.xml" anywhere in my MG path/environment.

<http://osgeo-org.1560.x6.nabble.com/file/n5319332/Server.jpg>
<http://osgeo-org.1560.x6.nabble.com/file/n5319332/fdo.jpg>
<http://osgeo-org.1560.x6.nabble.com/file/n5319332/bin.jpg>

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5319332.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-***@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

open_saucer

2017-05-14 06:54:57 UTC

Permalink

Hey guys, I'm still haven't trouble connecting. I'm getting error(see
screenshot) when choosing Oracle Provider in the Select FDO Provider dialog
box. Please any pointers would help. Thanks!
<Loading Image...

>
<Loading Image...

>

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5320464.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

Jérôme Touré

2017-05-15 13:41:32 UTC

Permalink

Did you install the King Oracle provider for MapGuide Open Source ?
http://www.sl-king.com/fdooracle/download/PreviousDownload.html

Post by open_saucer
Hey guys, I'm still haven't trouble connecting. I'm getting error(see
screenshot) when choosing Oracle Provider in the Select FDO Provider dialog
box. Please any pointers would help. Thanks!
<http://osgeo-org.1560.x6.nabble.com/file/n5320464/mgFDOerror.jpg>
<http://osgeo-org.1560.x6.nabble.com/file/n5320464/path.jpg>
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5320464.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
https://lists.osgeo.org/mailman/listinfo/mapguide-users

--
JÃ©rÃŽme TourÃ©
STERN
473 route des Dolines
Villantipolis 7
06560 VALBONNE
Phone : +33 4 92 96 96 01
Mobile : +33 6 27 84 04 30
Fax : +33 4 92 96 96 02

Bernhard Maehler

2017-05-15 17:28:20 UTC

Permalink

sorry, but I am a little bit confused about the description of your operating
system and version of MapGuide.

In your first post (May 03, 2017) you mentioned:
Machine 1: MG Open Source 2.6 and Maestro
Machine 2: Oracle 11g r2

Second post (May 04, 2017):
Machine 1(Windows Server 2012 R2): Oracle 11g r2 32bit installed
Machine 2(Windows Server 2008 R2): MG Open Source 2.6 and Maestro 5.1
Installed

Did you install the 32-bit or 64-bit version of MapGuide Server?
In case you have installed the 64-bit version of MapGuide Server, you also
need to install the 64-bit version of Oracle Client.

Furthermore (see third screenshot from your post on May 14, 2017), consider
that MapGuide 2.6 is built against the FDO 3.9 branch.
FDO 4.0 is not supported for MapGuide 2.6!

I am not sure but I suspect that the problem is the wrong version of the FDO
Provider or a client/server incompatibility between 32 bit and 64 bit
platforms.

Bernhard

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5320582.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

open_saucer

2017-05-16 01:12:37 UTC

Permalink

Thanks Bernhard,
you are right, it was with the 32 bit vs 64 bit Oracle client.

I originally installed oracle 32 bit client because I thought that's what I
needed due to a Oracle 32 bit database I had installed on my db server. It
is now working because of the installation of a 64 bit Oracle Client on the
MG server instead of 32.

Several of the screenshots was with different version of MG installed (2.6,
then 3.0), because I thought I'd test it out on different version of MG to
see if its working. It turns out to be the Oracle Client bit issue instead.

Sorry for the confusion!

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-connect-oracle-by-using-Mapguide-Maestro-tp4195265p5320611.html
Sent from the MapGuide Users mailing list archive at Nabble.com.