[mapguide-users] Re: An exception occurred in FDO component

[Dave Wilson]

If you have a shp file with the geometry you connect to the SHP file using the SHP provider. If you have data in a separate database then you would have to make a connection to that database using ODBC then define a Join on the SHP connection.

This is not going to perform well. If possible it would make more sense to combine the Access table data with the SHP dbf file and connect to just the SHP. If that's not an option you may not be happy with the Join results.

ODBC for geometry only renders point data based on coordinate values stored in 2 columns either Lat/Long or X/Y.

Regards,
Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of JamesDudden
Sent: Friday, November 12, 2010 9:21 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Re: An exception occurred in FDO component


I don't quite understand what you are trying to achieve so could you explain
a little further?

Are you trying to display data in an Acess dataabse as a layer? If so what
data/table structure do you have?

Or, are you trying to connect an Access database to another datasource i.e.
.shp?
Again it would be helpful to know your table structure.



-----
http://www.software-matters.co.uk Software Matters  - 
http://www.software-matters.co.uk/bespoke-database-design.html Bespoke
Database  and Software Solutions
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/An-exception-occurred-in-FDO-component-tp5727051p5732913.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