Yes, it works for me. Thank you very much! and I have another problem as describe in follow post. Could you please give me some suggestion? Especially about whether the filter should be parsed by the data provider in some cases? If so, maybe you can post a new ticket to MGOS or FDO Project for MS SQL Server 2008. Thank you!
http://www.nabble.com/MapGuide-SQL2008-Provider%3A-can%27t-support-geometry-method--td20056020.html Kenneth Skovhede, GEOGRAF A/S wrote: > > Hi Carl. > > Thank you for finding this problem. > There were another problem with the multiple schemas, namely that all > tables would be assigned to the very first schema. > I have included you fix, the fix for multiple schemas, and the fix for > the unmapped datatypes in r3392. > On my simple test setup, I can now use MsSql Spatial data, let me know > if it works for you too. > > Regards, Kenneth Skovhede, GEOGRAF A/S > > > > Carl skrev: >> Exactly, the returned XML based on the new version of SQLSpatialProvider >> covers all tables. >> But now the root node name is changed to 'fdo:DataStore', and Maestro >> check >> that the root node name must be 'xs:schema'. (as follows) >> >> /////////////////////////////////// >> public class FeatureSourceDescription >> { >> private FeatureSourceSchema[] m_schemas; >> >> public FeatureSourceDescription(System.IO.Stream stream) >> { >> XmlDocument doc = new XmlDocument(); >> doc.Load(stream); >> >> if (doc.FirstChild.Name != "xml") >> throw new Exception("Bad document"); >> >> if (doc.ChildNodes.Count != 2 || doc.ChildNodes[1].Name >> != >> "xs:schema") >> throw new Exception("Bad document"); >> >> XmlNamespaceManager mgr = new >> XmlNamespaceManager(doc.NameTable); >> mgr.AddNamespace("xs", >> "http://www.w3.org/2001/XMLSchema";); >> mgr.AddNamespace("gml", "http://www.opengis.net/gml";); >> mgr.AddNamespace("fdo", "http://fdo.osgeo.org/schemas";); >> >> XmlNodeList lst = >> doc.SelectNodes("xs:schema/xs:[EMAIL PROTECTED]'false']", mgr); >> m_schemas = new FeatureSourceSchema[lst.Count]; >> for(int i = 0;i<lst.Count;i++) >> m_schemas[i] = new FeatureSourceSchema(lst[i], >> doc, mgr); >> } >> ...... >> >> /////////////////// >> >> Then I changed the Maestro to fit the new version >> 1. Check the root node name : 'fdo:DataStore' >> 2. Modify the line >> XmlNodeList lst = >> doc.SelectNodes("xs:schema/xs:[EMAIL PROTECTED]'false']", mgr); >> >> as >> >> XmlNodeList lst = >> doc.SelectNodes("fdo:DataStore/xs:schema/xs:[EMAIL PROTECTED]'false']", >> mgr); >> >> OK. It works well. all tables are listed, and the table containing a >> geometry field is shown as default. >> >> >> Brent Robinson-5 wrote: >> >>> One clarification. The fix is specific to the handling of varchar(max) >>> and >>> nvarchar(max). It likely doesn't address the problem mentioned at >>> http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p19994687.html >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of Brent >>> Robinson >>> Sent: Wednesday, October 15, 2008 12:37 PM >>> To: MapGuide Users Mail List >>> Subject: RE: [mapguide-users] Maestro: can't find the table containing >>> the >>> geometry field with SQLServerSpatial >>> >>> This is a known defect that was fixed in July. The fix provides almost >>> full support for the varchar(max) and nvarchar(max) columns. There's one >>> limitation: when selecting from these columns, values longer than 16000 >>> characters are truncated. >>> >>> The FDO 3.3.2 SQLServerSpatial provider should have the fix. It can be >>> obtained from the Windows SDK download at >>> http://fdo.osgeo.org/content/fdo-332-downloads. You'd just need to >>> extract >>> the following DLL's: >>> >>> SQLServerSpatialProvider.dll >>> SQLServerSpatialOverrides.dll >>> OSGeo.FDO.Providers.SQLServerSpatial.Overrides.dll >>> >>> to MapGuide's FDO bin directories: >>> >>> Program Files\Autodesk\MapGuideEnterprise2009\Server\Bin\FDO >>> Program Files\Autodesk\MapGuideStudio2009\FDO (if present) >>> >>> I'd recommend saving copies of your current versions of these DLL's >>> before >>> extracting, just in case. >>> >>> I have MG enterprise on my machine so your directories might look a bit >>> different. >>> >>> If you get a chance to try this out, please let me know if it fixes the >>> problem. >>> >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of Carl >>> Sent: Wednesday, October 15, 2008 10:28 AM >>> To: mapguide-users@lists.osgeo.org >>> Subject: RE: [mapguide-users] Maestro: can't find the table containing >>> the >>> geometry field with SQLServerSpatial >>> >>> >>> yes >>> >>> >>> Brent Robinson-5 wrote: >>> >>>> Hi Carl, >>>> >>>> Do any of your tables have a varchar(max) column? >>>> >>>> Brent. >>>> >>>> >>>> >>>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p19994687.html >>> Sent from the MapGuide Users mailing list archive at Nabble.com. >>> >>> _______________________________________________ >>> 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 >>> _______________________________________________ >>> 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 > > -- View this message in context: http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p20056975.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
