[mapguide-users] Mapguide and Oracle: The remote server returnedan error: (559) MgFdoException

[Zac Spitzer]

Harris, we swapped emails on the filter problem between august 21 -
sept 11 on this, I just forwarded you a copy so you don't have to
search.

On 10/19/07, Haris Kurtagic <haris at sl-king.com> wrote:
> King.Oracle and King.MsSqlSpatial are Open Source. Source code is in a
> FDO SVN http://svn.osgeo.org/fdo/trunk/Providers/KingOracle/.
> Memory leak is fixed.
> Layer filter problem ? I am not aware of it, If you can give me some
> more info would be great.
>
> Haris
>
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
> Sent: Wednesday, October 17, 2007 6:07 PM
> To: CDM - Federica De Martin; MapGuide Users Mail List
> Subject: Re: [mapguide-users] Mapguide and Oracle: The remote server
> returnedan error: (559) MgFdoException
>
> Be aware that there are some issues with layer filters not working
> with King.Oracle
>
> I'm not 100% sure but 0.7.3 works better with the oracle instant
> client from http://www.sl-king.com/fdooracle than the full oracle
> client, there was some issues with a memory leak.
>
> At some point Harris was going to open source King.Oracle
>
> Here is a working feature source example.
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
>    <Provider>King.Oracle</Provider>
>    <Parameter>
>       <Name>Username</Name>
>       <Value>PSMA_AUG_07</Value>
>    </Parameter>
>    <Parameter>
>       <Name>Password</Name>
>       <Value>moenkey77455secret</Value>
>    </Parameter>
>    <Parameter>
>       <Name>Service</Name>
>       <Value>ZAC</Value>
>    </Parameter>
>    <Parameter>
>       <Name>OracleSchema</Name>
>       <Value>PSMA_AUG_07</Value>
>    </Parameter>
> </FeatureSource>
>
> On 10/18/05, CDM - Federica De Martin <tecnico at gpingegneria.it> wrote:
> >
> >
> > Hi!
> > I have got some problems loading data with MapGuide Open Source. First
> of
> > all I have WindowsXP and I'm using MapGuide Studio Preview version and
> I try
> > to connect to Oracle database.
> > If I try to use:
> > "OSGEO Fdo Provider for SHP" everything's ok (Connection
> Successfull...);
> > "OSGEO Fdo Provider for Raster" Connection is Successfull  but then I
> cannot
> > view the data in a layer or map preview;
> > "OSGEO Fdo Provider for ODBC" I cannot connect to any data type (not
> only
> > Oracle) and I always get:
> >    System.Net.WebException: The remote server returned an error: (559)
> > MgFdoException.
> >       in
> >
> Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetReque
> stToString(Operation
> > operation)
> >       in
> >
> Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String
> > resourceId, String provider, String connectionString)
> >       in
> > Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
> >       in
> >
> Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.b
> uttonTestConnection_Click(Object
> > sender, EventArgs e)
> > I've controlled in
> > c:\programmi\MapGuideOpenSource\Server\Bin\FDO\provider.xml
> > and the ODBC provider is correctly listed.
> > I get the same error if I try to connect with "King provider for
> Oracle".
> > In my opinion it isn't a problem of parameters but I've tried so many
> > combination that now I'm not still so sure... it would be also useful
> > if someone can tell me how parameters had to be set. This is an
> example of
> > mine:
> >       <FeatureSource
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
> >         <Provider>OSGeo.ODBC.3.2</Provider>
> >         <Parameter>
> >           <Name>UserId</Name>
> >           <Value>gis</Value>
> >         </Parameter>
> >         <Parameter>
> >           <Name>Password</Name>
> >           <Value>gis</Value>
> >         </Parameter>
> >         <Parameter>
> >           <Name>DataSourceName</Name>
> >           <Value>ubuntuXE</Value>
> >         </Parameter>
> >         <Parameter>
> >           <Name>ConnectionString</Name>
> >           <Value></Value>
> >         </Parameter>
> >         <Parameter>
> >           <Name>GenerateDefaultGeometryProperty</Name>
> >           <Value></Value>
> >         </Parameter>
> >       </FeatureSource>
> >
> > I hope someone has already faced this problem and can help me to make
> it
> > work!
> > Thank you all.
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> >
>
>
> --
> Zac Spitzer
> http://zacster.blogspot.com/
> +61 405 847 168 (aussie moible)
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>


-- 
Zac Spitzer
http://zacster.blogspot.com/
+61 405 847 168 (aussie moible)