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

[miansi]

Kenneth,

Yet another time I uninstall all MG-related components and install:
1. MgServerSetup-2.0.2.3011.exe
2. MgWebServerExtensionsSetup-2.0.2.3011.exe
3. Copied OSGeo.FDO.Providers.SQLServerSpatial.Overrides.dll,
SQLServerSpatialOverrides.dll, SQLServerSpatialProvider.dll from
fdosdk-win32-3.3.2
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
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\mapping\MappingUtil.cpp
Failed to stylize layer: MY_TABLE
An unclassified exception occurred.
<2009-02-01T14:58:00> 	Ajax Viewer	10.34.32.118	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.