[mapguide-users] ODBC problem...

[Andy Morsell]

There is currently a change request in pending status that should address
many of the join problems people are having.  Please see this page:
http://wiki.osgeo.org/index.php/MapGuide_RFCs.  Discussions on these topics,
and the ultimate approval by the Project Steering Committee (PSC,
https://mapguide.osgeo.org/psc.html) can be followed by subscribing to the
mapguide-dev mailing list.  Nabble groups were also recently added at
http://www.nabble.com/MapGuide-f16610.html 

As an aside, I've found that Access joins only work (by that, I mean will
display geometry) if your join key field is an integer.


Andy Morsell, P.E.
Spatial Integrators, Inc.
http://www.SpatialGIS.com

-----Original Message-----
From: James Card [mailto:James.Card at calcad.com] 
Sent: Tuesday, November 07, 2006 11:35 AM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] ODBC problem...

On Tue, 07 Nov 2006 11:20:55 -0800, Andrew DeMerchant
<andrew.demerchant at gemtec.ca> wrote:

> Ok, so I decided to give the ODBC FDO another chance...to see if it's 
> any faster / better now than it was back in v1.0....It does seems to 
> be a bit better, only I can't seem to get it to work completely.
>
> I can see the list of my tables...I can pick my geometry fields, etc.
> But I can't seem to get it to actually work. Either it's not reading 
> my X and Y columns, or else it's reading them, but discarding the data 
> for some reason....When I preview my layer, I see nothing. I've tried 
> everything that I can think of...I've tried changing the field type 
> (double, single, integer), I've tried various coord systems, I even 
> tried deleting all records in my table that have empty X / Y 
> fields.......Anyone have a solution? I've looked at the FDO docs, but 
> don't see anything that can help me.

This is exactly what were experiencing with MapGuide Enterprise SP1 when
trying to join DB tables to our SDF layers. We can see all the fields from
the database but we get only empty maps. All works well when reading only
from the SDF.

It looks like we will have to continue placing all our data inside the SDF
for a while longer.

--
James Card
California CAD Solutions, Inc.
209 578-5580

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org