ODBC connection with MGOS 2.2: Faulty configuration document in Maestro 4?

[janvw]

Problem: I have connected to a SQL server 2000 database using the ODBC provider. I have configured the tables in order to get the right columns for the X and Y values. After creating a layer using this feature source, the points should show up in my map, but they don't (MGOS 2.2 / Maestro 4). In the server error log I have the following entry: <2012-03-15T15:41:00> 1712 Ajax Viewer 127.0.0.1 Administrator

Error: Failed to stylize layer: test

An exception occurred in FDO component. Internal error

StackTrace:

• MgMappingUtil.StylizeLayers() line 831 file c:\builds\mg22win32\mgdev\server\src\services\mapping\MappingUtil.cpp

Workaround: I used Maestro 2.1 for setting up the dataconnection. The preview of the feature source still didn't work (error message: "Argument ist null"), but I could create a new layer and show the X/Y coordinates as points.

Attached: Two configuration documents: 1 produced by Maestro 2.1 (works), 1 by Maestro 4 (doesn't work).

[jng]

I think I know why.

I've been doing these configuration document changes against a trunk version of MapGuide, so FDO must've slipped in some breaking changes to how configuration documents are rendered and interpreted, so Maestro 4.0 creates configuration documents that would be valid for MapGuide 2.4, but not for 2.2 and older releases.

If you have time, download the 2.4 preview here (​http://download.osgeo.org/mapguide/releases/2.4.0/Test/) and create the same configured feature source using Maestro 4.0.

If this configured feature source works, then I'd have to think of how to generate compatible configuration documents for various versions of MapGuide (ugh!)

[janvw]

I'll check out the 2.4 preview.

One thing I don't understand: If Maestro 4.0 creates configuration documents valid for MapGuide 2.4, why is there a reference to the 3.2 ODBC provider (Line 159)?

<SchemaMapping provider="OSGeo.ODBC.3.2" xmlns:rdb="http://fdordbms.osgeo.org/schemas" xmlns="​http://fdoodbc.osgeo.org/schemas" name="dbo">

In the Maestro 2.1 configuration document the ODBC 3.5 provider is mentioned instead.

[janvw]

I tried to check out the 2.4 preview.

I connected to the ODBC feature source in Maestro 4.0 (Test Connection was true). When trying to edit the schema for specifying the X/Y columns I get two errors: First a popup saying "The value is outside the expected range" and then a Maestro error message (see attached file). So I couldn't get to the point where Maestro is generating the configuration document.

[jng]

Fixed trunk (r6750) and 4.0.x (r6752)