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: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ 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
