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: [email protected] [mailto:[email protected]] On Behalf Of JamesDudden Sent: Friday, November 12, 2010 9:21 AM To: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
