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

[open_saucer]

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.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[Bernhard Maehler]

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.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[Jérôme Touré]

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

Le 14/05/2017 à 08:54, open_saucer a écrit :

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!





--
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
mapguide-users@lists.osgeo.org
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

<>___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[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! 
 
 



--
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
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[Martin Morrison]

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
martin.morri...@edsi.com

 
www.edsi.com

-Original Message-
From: mapguide-users [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf 
Of open_saucer
Sent: Wednesday, May 3, 2017 11:27 PM
To: mapguide-users@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-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[open_saucer]

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.  

 
 
 



--
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.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[Jackie Ng]

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.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[open_saucer]

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.

 
 
 



--
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-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[Gord McKenzie]

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-boun...@lists.osgeo.org] On Behalf 
Of open_saucer
Sent: Wednesday, May 03, 2017 11:45 AM
To: mapguide-users@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-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[mark]

You also need to update the providers.xml, in /server/fdo/bin, to include the 
king dll.
null___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[gom]

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 you may
wish to copy the supporting Oracle dlls to your fdo folder.

Hope that points you in the right direction. 




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

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

[open_saucer]

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? 

 



--
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-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[Jackie Ng]

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.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[open_saucer]

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.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[padmini godavarthi]

 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




Kenneth Skovhede, GEOGRAF A/S wrote:
 
 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
 
 
 
 Simon Pelicon skrev:
 Hi!
 If you are using MapGuide Open source, you have to install King Oracle 
 provider.
 Link for for installation instructions: 
 http://www.sl-king.com/fdooracle/download/README.txt
 Regards,
 Simon

 padmini godavarthi wrote:
 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
 mapguide-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapguide-users
   
 
 ___
 mapguide-users mailing list
 mapguide-users@lists.osgeo.org
 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.

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

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

[Kenneth Skovhede, GEOGRAF A/S]

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



Simon Pelicon skrev:

Hi!
If you are using MapGuide Open source, you have to install King Oracle 
provider.
Link for for installation instructions: 
http://www.sl-king.com/fdooracle/download/README.txt

Regards,
Simon

padmini godavarthi wrote:

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
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
  
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

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

[Simon Pelicon]

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

padmini godavarthi wrote:

  

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
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users