[mapguide-users] Mapguide and ODBC

[gom]

I have migrated and Access database to SQL Server.  I am trying to create a
feature join from an sdf file to a sql server table using a string column. 
I can create the datasources and the join without too much difficulty.  If I
use the preview function on the datasource I can see the record count on the
sdf side of the join and I can preview thae data.  I can do likewise on the
extended class and the record count matches.  However, when I view the data
only about 15 percent of the records join properly.  The rest show blank or
null values from the SQL Server table side of the join.

It is a single table, single column join.  No leading or trailing spaces are
obvious in the sdf or the table as far as I can see.  Hard to identify the
cause.  I read in the archives that text doesn't work well for joins but
that message was years old.

Is ODBC joining still a problematic approach to managing data in Mapguide or
am I missing something.

Mapguide is 2.5.1 but this problem shows up in Maestro 5 and 6 and in
Mapguide Studio.

Thanks



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODBC-tp5202365.html
Sent from the MapGuide Users mailing list archive at Nabble.com.