The whole point with FDO is that it abstracts aways the specific database <br>and lets you simply work with the spatial datasets exposed via the<br>featureSource. <br><br>The only database specific item is the way each FDO provider names <br>
the features classes (tables in db speak) <a href="http://trac.osgeo.org/fdo/wiki/FDORfc43">http://trac.osgeo.org/fdo/wiki/FDORfc43</a> <br><br>That shouldn't be an issue for what your doing.<br><br>So once your have your Oracle FDO connection working, you simply start <br>
creating (authoring) layers and then combining them into creating maps <br><br>z<br>
<br><br><div class="gmail_quote">On Tue, Apr 26, 2011 at 11:20 AM, Kiran Korde <span dir="ltr"><<a href="mailto:kkorde@hotmail.com">kkorde@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
Hello Tom,<div> Thank you and all for guiding me through to get the setup up to establish a connection to Oracle Spatial database. I just need to document all the steps I had to implement to get it working.</div>
<div>Now I have the connection to the database, how do I create layers and then display that information in MapGuide. I may sound like a broken record, however is there a step by step process of viewing Oracle Spatial data in MapGuide? It seems like you and others who had helped me through this process has already gone through this process. I would appreciate if you could share your knowledge.</div>
<div><br></div><div>Thanks and Best regards,</div><div>Kiran</div><div><br><br><img src="" usemap="#12f8f65370061a02_555658596"><map name="12f8f65370061a02_555658596"><area shape="RECT" coords="0,165,260,177" href="http://eCode.com/c.asp" target="_blank"><area shape="RECT" coords="270,0,285,162" href="http://eCode.com/a.asp?S=KKORDE" target="_blank"><area shape="RECT" coords="91,112,194,99.5" href="http://www.charterpro.com" target="_blank"><area shape="RECT" coords="91,97,194,84.5"><area shape="RECT" coords="269,163,285,177" href="http://eCode.com/G.asp?e=KKORDE" target="_blank"><area shape="RECT" href="http://eCode.com/" coords="0,0,285,177" target="_blank"></map><br>
<br><br><br><hr>From: <a href="mailto:thoman@co.gila.az.us" target="_blank">thoman@co.gila.az.us</a><div class="im"><br>To: <a href="mailto:kkorde@hotmail.com" target="_blank">kkorde@hotmail.com</a>; <a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
</div><div class="im">Subject: RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial<br></div>Date: Mon, 25 Apr 2011 21:33:12 +0000<div><div></div><div class="h5"><br><br>
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Also, make sure your ORACLE_HOME environment variable is set to the install location of your oracle client. Mine happens to be:
</span><span style="font-size: 10pt; font-family: 'Courier New';">ORACLE_HOME=D:\oracle\product\10.2.0\client_1</span></p>
<p><span style="font-size: 10pt; font-family: 'Courier New';"> </span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);">The oracle literature indicates that this is no longer required but I’ve found that it’s still frequently referenced.</span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);">As for the TNS error, run through the Oracle configuration to generate the tnsnames.ora file found in the client directory. It’s a configuration text file found
in </span><span style="font-size: 10pt; font-family: 'Courier New';">D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
</span><span style="font-size: 11pt; color: rgb(23, 54, 93);">(at least on my machine) It’s a text file so you can check if maybe you’re referencing a bad name.</span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);">Hope this helps a little</span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);">Tom</span></p>
<p><span style="font-size: 11pt; color: rgb(23, 54, 93);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Kiran Korde<br>
<b>Sent:</b> Monday, April 25, 2011 1:12 PM<br>
<b>To:</b> <a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a>; MapGuide OpenSource<br>
<b>Subject:</b> RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial</span></p>
</div>
</div>
<p> </p>
<p style="margin-bottom: 12pt;"><span style="font-size: 10pt;">Hello Martin,<br>
I able to get around the error that I had mentioned in my earlier post by just downloading and replacing the FDO folder with contents from fdosdk-win32-3.3.1.tar.gz<br>
<br>
However I am getting this new error while trying to test the connection <br>
<br>
The remote server returned an error: (559) MgFdoException.: <br>
An exception occurred in FDO component.<br>
ORA-12154: TNS:could not resolve the connect identifier specified<br>
<br>
Exception occurred in method MgFdoConnectionManager.Open at line 858 in file d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp<br>
The remote server returned an error: (559) MgFdoException.<br>
<br>
<br>
I am able to connect to my Oracle Spatial Database from the command prompt, however I get the above mentioned error while trying to test the connection from Maestro.<br>
<br>
Any help would be appreciated. Is there a step by step guide/process to configure Oracle Spatial Data to display using MapGuide?<br>
<br>
Best regards,<br>
Kiran<br>
<br>
</span><span style="margin-left: 0px; width: 285px; min-height: 177px;"><map name="12f8f65370061a02_MicrosoftOfficeMap0"><area shape="Rect" coords="0, 165, 260, 177" href="http://ecode.com/c.asp" target="_blank"><area shape="Rect" coords="270, 0, 285, 162" href="http://ecode.com/a.asp?S=KKORDE" target="_blank"><area shape="Rect" coords="91, 100, 194, 112" href="http://www.charterpro.com/" target="_blank"><area shape="Rect" coords="91, 85, 194, 97"><area shape="Rect" coords="269, 163, 285, 177" href="http://ecode.com/G.asp?e=KKORDE" target="_blank"><area shape="Rect" coords="0, 0, 285, 177" href="http://ecode.com/" target="_blank"></map><img src="https://mail.google.com/mail/u/0/?ui=2&ik=bab9b6b23d&view=att&th=12f8f65370061a02&attid=0.0.1&disp=emb&zw" usemap="#12f8f65370061a02_MicrosoftOfficeMap0" border="0" height="177" width="285"></span><span style="font-size: 10pt;"><img src=""><br>
<br>
<br>
</span></p>
<div style="text-align: center;" align="center"><span style="font-size: 10pt;">
<hr align="center" size="2" width="100%">
</span></div>
<p style="margin-bottom: 12pt;"><span style="font-size: 10pt;">From: <a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a><br>
To: <a href="mailto:kkorde@hotmail.com" target="_blank">kkorde@hotmail.com</a>; <a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
Date: Mon, 25 Apr 2011 12:40:04 -0400<br>
Subject: RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial</span></p>
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Make sure they are located in your system path.
</span><span style="font-size: 10pt;"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span><span style="font-size: 10pt;"></span></p>
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Martin Morrison</span><span style="font-size: 10pt;"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Application Engineer</span><span style="font-size: 10pt;"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Engineering Design Systems, Inc.</span><span style="font-size: 10pt;"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">3780 Peters Creek Rd Ext SW</span><span style="font-size: 10pt;"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Roanoke, VA 24018</span><span style="font-size: 10pt;"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"><a href="tel:540.345.1410" value="+15403451410" target="_blank">540.345.1410</a></span><span style="font-size: 10pt;"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"><a href="http://gis.edsi.com" target="_blank">gis.edsi.com</a></span><span style="font-size: 10pt;"></span></p>
</div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span><span style="font-size: 10pt;"></span></p>
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0in 0in; border-color: -moz-use-text-color;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Kiran Korde<br>
<b>Sent:</b> Monday, April 25, 2011 12:32 PM<br>
<b>To:</b> <a href="mailto:zac.spitzer@gmail.com" target="_blank">zac.spitzer@gmail.com</a>; MapGuide OpenSource<br>
<b>Subject:</b> RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial</span></p>
</div>
</div>
<p><span style="font-size: 10pt;"> </span></p>
<p style="margin-bottom: 12pt;"><span style="font-size: 10pt;">Hello Zac,<br>
I have installed Oracle 10.2.0.1 client. After running the depends.exe, the result came back with 2 missing dlls.<br>
mscvr80.dll and msvcp80.dll. Should these part of the application package that I had downloaded?<br>
I searched these files and they were found under C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.1433_x-ww_5cf844d2.<br>
I copied them to \bin and \fdo folder and I still getting the same error. <br>
<br>
Thanks,<br>
Kiran<br>
<br>
</span><span style="font-size: 10pt;"><map name="12f8f65370061a02_MicrosoftOfficeMap1"><area shape="Rect" coords="0, 165, 260, 177" href="http://ecode.com/c.asp" target="_blank"><area shape="Rect" coords="270, 0, 285, 162" href="http://ecode.com/a.asp?S=KKORDE" target="_blank"><area shape="Rect" coords="91, 100, 194, 112" href="http://www.charterpro.com/" target="_blank"><area shape="Rect" coords="91, 85, 194, 97"><area shape="Rect" coords="269, 163, 285, 177" href="http://ecode.com/G.asp?e=KKORDE" target="_blank"><area shape="Rect" coords="0, 0, 285, 177" href="http://ecode.com/" target="_blank"></map><img src="https://mail.google.com/mail/u/0/?ui=2&ik=bab9b6b23d&view=att&th=12f8f65370061a02&attid=0.0.2&disp=emb&zw" usemap="#12f8f65370061a02_MicrosoftOfficeMap1" border="0" height="177" width="285"><img src=""><br>
<br>
</span></p>
<div style="text-align: center;" align="center"><span style="font-size: 10pt;">
<hr align="center" size="2" width="100%">
</span></div>
<p style="margin-bottom: 12pt;"><span style="font-size: 10pt;">From: <a href="mailto:zac.spitzer@gmail.com" target="_blank">zac.spitzer@gmail.com</a><br>
Date: Sat, 23 Apr 2011 12:20:27 +1000<br>
Subject: Re: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial<br>
To: <a href="mailto:kkorde@hotmail.com" target="_blank">kkorde@hotmail.com</a>; <a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<br>
what version of oracle libs are you running?<br>
<br>
have you tried running depends.exe on the<br>
KingOracleProvider.dll ?<br>
<br>
(search the list archives if you need more info<br>
about depends.exe)</span></p>
<div>
<p><span style="font-size: 10pt;">On Sat, Apr 23, 2011 at 1:00 AM, Kiran Korde <<a href="mailto:kkorde@hotmail.com" target="_blank">kkorde@hotmail.com</a>> wrote:</span></p>
<div>
<p><span style="font-size: 10pt;">Hello Group,<br>
I have checked the below mentioned steps and still get the error message while trying to select the King.Oracle provider attached in the document.<br>
Here is the snippet from the providers.xml one as suggested by the document and the other with actual version number of the file. None of them work.<br>
<br>
This is recommended in the documentation.<br>
<br>
<FeatureProvider><br>
<Name>King.Oracle.3.3</Name><br>
<DisplayName>King Provider for Oracle</DisplayName><br>
<Description>Read/write access to spatial and attribute data in an Oracle Spatial.</Description><br>
<IsManaged>False</IsManaged><br>
<Version>3.3.0.0</Version><br>
<FeatureDataObjectsVersion>3.3.0.0</FeatureDataObjectsVersion><br>
<LibraryPath>C:\Program Files\MapGuideOpenSource2.0\Server\Bin\FDO\KingOracleProvider.dll</LibraryPath><br>
</FeatureProvider><br>
<br>
<br>
Here I have replaced the version number.<br>
<br>
<FeatureProvider><br>
<Name>King.Oracle.3.3</Name><br>
<DisplayName>King Provider for Oracle</DisplayName><br>
<Description>Read/write access to spatial and attribute data in an Oracle Spatial.</Description><br>
<IsManaged>False</IsManaged><br>
<Version>0.8.13.0</Version><br>
<FeatureDataObjectsVersion>0.8.13.0</FeatureDataObjectsVersion><br>
<LibraryPath>C:\Program Files\MapGuideOpenSource2.0\Server\Bin\FDO\KingOracleProvider.dll</LibraryPath><br>
</FeatureProvider><br>
<br>
<br>
Is there a step-by-step guide to configure and view Oracle Spatial data using Mapguide?<br>
<br>
<br>
Best regards,<br>
Kiran<br>
<br>
</span><span style="font-size: 10pt;"><map name="12f8f65370061a02_MicrosoftOfficeMap2"><area shape="Rect" coords="0, 165, 260, 177" href="http://ecode.com/c.asp" target="_blank"><area shape="Rect" coords="270, 0, 285, 162" href="http://ecode.com/a.asp?S=KKORDE" target="_blank"><area shape="Rect" coords="91, 100, 194, 112" href="http://www.charterpro.com/" target="_blank"><area shape="Rect" coords="91, 85, 194, 97"><area shape="Rect" coords="269, 163, 285, 177" href="http://ecode.com/G.asp?e=KKORDE" target="_blank"><area shape="Rect" coords="0, 0, 285, 177" href="http://ecode.com/" target="_blank"></map><img src="https://mail.google.com/mail/u/0/?ui=2&ik=bab9b6b23d&view=att&th=12f8f65370061a02&attid=0.0.2&disp=emb&zw" usemap="#12f8f65370061a02_MicrosoftOfficeMap2" border="0" height="177" width="285"><img src="" border="0"><br>
<br>
<br>
<br>
> From: <a href="mailto:trac_mapguide@osgeo.org" target="_blank">trac_mapguide@osgeo.org</a><br>
> CC: <a href="mailto:mapguide-trac@lists.osgeo.org" target="_blank">mapguide-trac@lists.osgeo.org</a><br>
> Date: Fri, 15 Apr 2011 14:03:24 +0000<br>
> Subject: Re: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial<br>
> <br>
> #1667: MapGuide Maestro and Oracle Spatial<br>
> ---------------------+------------------------------------------------------<br>
> Reporter: kkorde | Owner: <br>
> Type: defect | Status: closed <br>
> Priority: high | Milestone: Maestro-3.0<br>
> Component: General | Version: 2.0.2 <br>
> Severity: major | Resolution: wontfix <br>
> Keywords: | External_id: <br>
> ---------------------+------------------------------------------------------<br>
> Changes (by jng):<br>
> <br>
> * status: new => closed<br>
> * resolution: => wontfix<br>
> <br>
> <br>
> Comment:<br>
> <br>
> This error has nothing to do with Maestro and everything with how you've<br>
> set up the FDO provider. Check the following:<br>
> <br>
> 1. The King.Oracle provider you have downloaded is for FDO 3.3.x (this is<br>
> the version of FDO your MapGuide 2.0.2 is using)<br>
> 2. You have installed the Oracle Instant Client and that the King.Oracle<br>
> provider can correctly locate these libraries (OCI.dll). Loading<br>
> KingOracleProvider.dll into depends.exe can help determine if it can<br>
> locate these dlls.<br>
> <br>
> Please use the mailing list for problems like this in the future.<br>
> <br>
> -- <br>
> Ticket URL: <<a href="http://trac.osgeo.org/mapguide/ticket/1667#comment:1" target="_blank">http://trac.osgeo.org/mapguide/ticket/1667#comment:1</a>><br>
> MapGuide Open Source <<a href="http://mapguide.osgeo.org/" target="_blank">http://mapguide.osgeo.org/</a>><br>
> MapGuide Open Source Internals</span></p>
</div>
<p style="margin-bottom: 12pt;"><span style="font-size: 10pt;"><br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a></span></p>
</div>
<p style="margin-bottom: 12pt;"><span style="font-size: 10pt;"><br>
<br clear="all">
<br>
-- <br>
Zac Spitzer <br>
Solution Architect / Director<br>
Ennoble Consultancy Australia<br>
<a href="http://www.ennoble.com.au" target="_blank">http://www.ennoble.com.au</a><br>
<a href="http://zacster.blogspot.com" target="_blank">http://zacster.blogspot.com</a><br>
<a href="tel:%2B61%20405%20847%20168" value="+61405847168" target="_blank">+61 405 847 168</a><br>
<br>
</span></p>
</div>
</div></div></div></div> </div>
<br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Zac Spitzer <br>Solution Architect / Director<br>Ennoble Consultancy Australia<br><a href="http://www.ennoble.com.au">http://www.ennoble.com.au</a><br><a href="http://zacster.blogspot.com">http://zacster.blogspot.com</a><br>
+61 405 847 168<br><br><br><br>