[mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

[Brent Robinson]

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: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] 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: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Carl
Sent: Wednesday, October 15, 2008 10:28 AM
To: mapguide-users at 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 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