Hello Tom, 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.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. Thanks and Best regards,Kiran
From: [email protected] To: [email protected]; [email protected] Subject: RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial Date: Mon, 25 Apr 2011 21:33:12 +0000 Also, make sure your ORACLE_HOME environment variable is set to the install location of your oracle client. Mine happens to be: ORACLE_HOME=D:\oracle\product\10.2.0\client_1 The oracle literature indicates that this is no longer required but I’ve found that it’s still frequently referenced. 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 D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora (at least on my machine) It’s a text file so you can check if maybe you’re referencing a bad name. Hope this helps a little Tom From: [email protected] [mailto:[email protected]] On Behalf Of Kiran Korde Sent: Monday, April 25, 2011 1:12 PM To: [email protected]; MapGuide OpenSource Subject: RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial Hello Martin, 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 However I am getting this new error while trying to test the connection The remote server returned an error: (559) MgFdoException.: An exception occurred in FDO component. ORA-12154: TNS:could not resolve the connect identifier specified 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 The remote server returned an error: (559) MgFdoException. 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. Any help would be appreciated. Is there a step by step guide/process to configure Oracle Spatial Data to display using MapGuide? Best regards, Kiran From: [email protected] To: [email protected]; [email protected] Date: Mon, 25 Apr 2011 12:40:04 -0400 Subject: RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial Make sure they are located in your system path. Martin Morrison Application Engineer Engineering Design Systems, Inc. 3780 Peters Creek Rd Ext SW Roanoke, VA 24018 540.345.1410 gis.edsi.com From: [email protected] [mailto:[email protected]] On Behalf Of Kiran Korde Sent: Monday, April 25, 2011 12:32 PM To: [email protected]; MapGuide OpenSource Subject: RE: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial Hello Zac, I have installed Oracle 10.2.0.1 client. After running the depends.exe, the result came back with 2 missing dlls. mscvr80.dll and msvcp80.dll. Should these part of the application package that I had downloaded? I searched these files and they were found under C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.1433_x-ww_5cf844d2. I copied them to \bin and \fdo folder and I still getting the same error. Thanks, Kiran From: [email protected] Date: Sat, 23 Apr 2011 12:20:27 +1000 Subject: Re: [mapguide-users] RE: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial To: [email protected]; [email protected] what version of oracle libs are you running? have you tried running depends.exe on the KingOracleProvider.dll ? (search the list archives if you need more info about depends.exe) On Sat, Apr 23, 2011 at 1:00 AM, Kiran Korde <[email protected]> wrote: Hello Group, 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. 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. This is recommended in the documentation. <FeatureProvider> <Name>King.Oracle.3.3</Name> <DisplayName>King Provider for Oracle</DisplayName> <Description>Read/write access to spatial and attribute data in an Oracle Spatial.</Description> <IsManaged>False</IsManaged> <Version>3.3.0.0</Version> <FeatureDataObjectsVersion>3.3.0.0</FeatureDataObjectsVersion> <LibraryPath>C:\Program Files\MapGuideOpenSource2.0\Server\Bin\FDO\KingOracleProvider.dll</LibraryPath> </FeatureProvider> Here I have replaced the version number. <FeatureProvider> <Name>King.Oracle.3.3</Name> <DisplayName>King Provider for Oracle</DisplayName> <Description>Read/write access to spatial and attribute data in an Oracle Spatial.</Description> <IsManaged>False</IsManaged> <Version>0.8.13.0</Version> <FeatureDataObjectsVersion>0.8.13.0</FeatureDataObjectsVersion> <LibraryPath>C:\Program Files\MapGuideOpenSource2.0\Server\Bin\FDO\KingOracleProvider.dll</LibraryPath> </FeatureProvider> Is there a step-by-step guide to configure and view Oracle Spatial data using Mapguide? Best regards, Kiran > From: [email protected] > CC: [email protected] > Date: Fri, 15 Apr 2011 14:03:24 +0000 > Subject: Re: [mapguide-trac] #1667: MapGuide Maestro and Oracle Spatial > > #1667: MapGuide Maestro and Oracle Spatial > ---------------------+------------------------------------------------------ > Reporter: kkorde | Owner: > Type: defect | Status: closed > Priority: high | Milestone: Maestro-3.0 > Component: General | Version: 2.0.2 > Severity: major | Resolution: wontfix > Keywords: | External_id: > ---------------------+------------------------------------------------------ > Changes (by jng): > > * status: new => closed > * resolution: => wontfix > > > Comment: > > This error has nothing to do with Maestro and everything with how you've > set up the FDO provider. Check the following: > > 1. The King.Oracle provider you have downloaded is for FDO 3.3.x (this is > the version of FDO your MapGuide 2.0.2 is using) > 2. You have installed the Oracle Instant Client and that the King.Oracle > provider can correctly locate these libraries (OCI.dll). Loading > KingOracleProvider.dll into depends.exe can help determine if it can > locate these dlls. > > Please use the mailing list for problems like this in the future. > > -- > Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1667#comment:1> > MapGuide Open Source <http://mapguide.osgeo.org/> > MapGuide Open Source Internals _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168
<<attachment: image002.png>>
<<attachment: image003.png>>
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
