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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- Zac Spitzer http://zacster.blogspot.com/ +61 405 847 168 (aussie moible) _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
