[mapguide-users] ODBC problem...

[Warren Medernach]

Hey James,

This is exactly what we were experiencing as well on this particular map
we were trying to Join to SQL Server.  What I realized after a while is
that it appeared like MapGuide was working to display the data, but with
the all of these extra fields it would just chug away and not show
anything....  I then set a lower scale range, zoomed in, and voila...
The graphics and joined data appeared...

But it was extremely frustrating as the 'hour glass' stopped in the
preview which leads you to believe it's done working...  When in
reality, I think it's still working away... But there is too much for it
to handle.  Zoom in, or set a smaller scale range and it works.

Just some thoughts.

Warren Medernach


-----Original Message-----
From: James Card [mailto:James.Card at calcad.com] 
Sent: Tuesday, November 07, 2006 1:35 PM
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