[mapguide-users] Mapguide and ODBC

[Gord McKenzie]

Here is the scoop.

When the SQL Database has a string like 'xxx123' and the sdf has a string like 'XXX123' then the records don't match and that is the substance of the problem.  In AutoCAD Map, each id that is mismatched by case is still missing it's joined attributes.  However record matching continues with just the few case based mismatches.  When Mapguide does this, it hits the first mismatch and nothing else is matched after that.

In SQL Server, by default it has no trouble joining on xxx and XXX.

Gordon McKenzie
GIS Coordinator

T: 403.269.8887 / 1.800.478.6162 
E: Gord.Mckenzie at canam.com    canam.com 
900, 340 - 12th Avenue SW Calgary, AB T2R 1L5


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
Sent: Sunday, April 26, 2015 8:56 PM
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] Mapguide and ODBC

I'm afraid at this point, we'll need a small reproducible sample of this problematic SDF/SQL Server join in order to look at this issue any further.
Something that is 50-100 rows on either side with the sensitive information (except for the joining keys) sanitized/replaced should be sufficient.

IIRC MapGuide and AutoCAD Map share the same Feature Join engine. I'd be interested to know if this SDF <-> SQL Server join looks the same in AutoCAD Map 2013 or newer should you have access to such a version.

- Jackie



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODBC-tp5202365p5203003.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