IMHO, take a long deep breath and forget MG and KOP for the moment.
Download instantclient 10.2 from the Oracle site. Install it. Config TNSNAMES.ora (although not necessary I would recommend that you set the environmental variables as described: LD_LIB_PATH, TNS_ADMIN and PATH) Use the following to contact the db: TNSPING <sid> When you get this working FdoKingOracle works great (as Haris K., et.al. describe) ... 1) copy the 3 dll's 2) update providers.xml dennis ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rahul Sent: Thursday, July 10, 2008 5:29 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] MG Studio 2009 - MGOS 2.0.1 - FdoKingOracle - nogeometry is rendered Hi , I installed only King Oracle Provider for Oracle Instant Client for both the cases - MGOS1.2.0 - v0_7_3(King Oracle Provider for Oracle Instant Client) MGOS2.0.1 - v0_7_4(King Oracle Provider for Oracle Instant Client) Max !! ----- Original Message ---- From: Simon Pelicon <[EMAIL PROTECTED]> To: MapGuide Users Mail List <[email protected]> Sent: Thursday, July 10, 2008 4:01:18 PM Subject: Re: [mapguide-users] MG Studio 2009 - MGOS 2.0.1 - FdoKingOracle - no geometry is rendered Hi, What i meant is taht you have oracle client on Windows Server 2003 (not XP). Sorry. If you use Oracle Instant Client than you should use King Oracle Provider for Oracle Instant Client. link: http://www.sl-king.com/fdooracle/download/FdoKingOracle_Win32_Instant_FD O_3_3_v0_7_4.zip Simon Rahul wrote: Hi, Nops i installed Oracle Instant Client in Windows Server 2003,Do i need to install oracle instant client in the MapGuide Studio 2009 FDO Directory? Max ----- Original Message ---- From: Simon Pelicon <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> To: MapGuide Users Mail List <[email protected]> <mailto:[email protected]> Sent: Thursday, July 10, 2008 3:34:05 PM Subject: Re: [mapguide-users] MG Studio 2009 - MGOS 2.0.1 - FdoKingOracle - no geometry is rendered Hi, Do you have Oracle client installed on Windows XP machine? Simon Rahul wrote: Hi, Intresting ,How you able to view the Connection Properties Boxes, As I am using Windows Server 2003 with MGOS 2.0.1 and then on another machine Windows XP having MapGuide Studio 2009,I downloaded FdoKingOracle_Win32_FDO_3_3_v0_7_4 as well as necessary files for the oracle Instant Client in the \Server\Bin\FDO Folder. Once I connect to the MapGuide Studio and try to open connection i use to see the configuration setting for King Oracle FDO Provider but have nothing in the connection string, so i unable to enter the Property and the corresponding values.It use to work well on my machine having MGOS1.2.0 Windows XP with MGS 2008. Thks Max !! ----- Original Message ---- From: djonio <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, July 9, 2008 7:43:08 PM Subject: [mapguide-users] MG Studio 2009 - MGOS 2.0.1 - FdoKingOracle - no geometry is rendered Howdy, Windows XP MGOS 2.0.1 MG Studio 2009 with FdoKingOracle_Win32_FDO_3_3_v0_7_4 Entry from providers.xml: <FeatureProvider> <Name>King.Oracle.0.1.1</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.1.1.0</Version> <FeatureDataObjectsVersion>3.3.0.0</FeatureDataObjectsVersion> <LibraryPath>C:\Program Files\MapGuideOpenSource2.0\Server\Bin\FDO\KingOracleProvider.dll</Libra ryPath> </FeatureProvider> Oracle instantclient_10.2 on the box. No issues with connection. All seems to work well in terms of collecting the schema and attribute information. When creating a Layer ... Layer Preview never seems to render any geometry ... This error: <2008-07-08T16:20:19> Fusion Viewer Administrator Error: Failed to stylize layer: test_KOP The coordinate system is invalid. Could not create coordinate system forward transformation with specified coordinate systems. StackTrace: - MgMappingUtil.StylizeLayers line 775 file d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server \src\services\mapping\MappingUtil.cpp Failed to stylize layer: test_KOP The coordinate system is invalid. Could not create coordinate system forward transformation with specified coordinate systems. I am using SRID = 2236. select srid, cs_name, auth_srid from MDSYS.CS_SRS where srid = 2236; 2236 NAD83 / Florida East (ftUS) 2236 ... Now today .... When attempting to create new layer using the above provider I get this: An exception occurred in FDO component. ORA-32102: invalid OCI handle Seems pretty "flacky" to me because when I "Configure a Feature Resource using Generic Editor " Connection test is successful AND when I do the "Preview -> Refresh" it pulls down all of my classes (appox. 20 in this case) "View Data" works .. great!! "View Feature" retrieves the correct feature count. ... however nothing renders!!! Just spins ... Anyone aware of any fix for any of this? dennis -- View this message in context: http://www.nabble.com/MG-Studio-2009---MGOS-2.0.1---FdoKingOracle---no-g eometry-is-rendered-tp18360497p18360497.html Sent from the MapGuide Users mailing list archive at Nabble.com <http://nabble.com/> . _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users No virus found in this incoming message. Checked by AVG - http://www.avg.com <http://www.avg.com/> Version: 8.0.138 / Virus Database: 270.4.7/1543 - Release Date: 9.7.2008 18:32 ________________________________ _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users No virus found in this incoming message. Checked by AVG - http://www.avg.com <http://www.avg.com/> Version: 8.0.138 / Virus Database: 270.4.7/1543 - Release Date: 9.7.2008 18:32 ________________________________ _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users ________________________________ E-mails are automatically scanned for viruses using McAfee.
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
