[mapguide-users] MG Studio 2009 - MGOS 2.0.1 - FdoKingOracle - nogeometry is rendered

Thu Jul 10 06:08:57 EDT 2008

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: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] 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 <simon at sl-king.com>
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
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 <simon at sl-king.com> <mailto:simon at sl-king.com> 
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
<mailto:mapguide-users at lists.osgeo.org> 
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 <djonio at miami-airport.com>
<mailto:djonio at miami-airport.com> 
To: mapguide-users at lists.osgeo.org
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
mapguide-users at lists.osgeo.org
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
mapguide-users at lists.osgeo.org
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
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

________________________________

E-mails are automatically scanned for viruses using McAfee. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080710/f23e385a/attachment.html