[mapguide-users] SQL 2008, MGOS 2.0.2, FDO 3.3.x - 3.4.x, Maestro 1.0.9 do not cooperate

miansi AndreiSinelnikov at SierraSystems.com
Sun Feb 1 17:24:29 EST 2009


Yet another time I uninstall all MG-related components and install:
1. MgServerSetup-
2. MgWebServerExtensionsSetup-
3. Copied OSGeo.FDO.Providers.SQLServerSpatial.Overrides.dll,
SQLServerSpatialOverrides.dll, SQLServerSpatialProvider.dll from
4. Updated providers.xml to include SQL Spatial FeatureProvider in the list.

Thank you for pointing me to the log file location.
Errors looks like this:
  - MgMappingUtil.StylizeLayers line 786 file
Failed to stylize layer: MY_TABLE
An unclassified exception occurred.
<2009-02-01T14:58:00> 	Ajax Viewer	Administrator
 Error: Failed to stylize layer: LAYER_FROM_VIEW
        An exception occurred in FDO component.
        RDBMS: Incompatible column type 

Further investigation confirmed that FDO don't like uniquieidentifier data
type. Unchecking this column in the "Properties available in viewer" on
layer tab resolved the issue - I was able to see layer on the map!

I didn't test same steps on FDO 3.4.x.

Thank you!

Kenneth Skovhede, GEOGRAF A/S wrote:
> Studio does not yet support the MSSQL server provider directly, so you 
> will get a "generic page", which is not likely to solve your problem.
> Instead, try looking at the error log:
> C:\Program Files\MapGuideOpenSource2.0\Server\Logs\Error.log
> ...

View this message in context: http://n2.nabble.com/SQL-2008%2C-MGOS-2.0.2%2C-FDO-3.3.x---3.4.x%2C-Maestro-1.0.9-do-not-cooperate-tp2247138p2255456.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

More information about the mapguide-users mailing list