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 <[EMAIL PROTECTED]> 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: [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 > > mapguide-users@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > mapguide-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
