mdb file uploaded, but the geometry gone.

connect via ODBC provider:

I use RawConnectionString and then this code to connect to my *.mdb file

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=Partition:\DIrectory\*.mdb

however, there is a Problem. The geometry will not available. The data treated as non-spatial data.

when i validate the connection, those heads up coming out as result:

Information - OSGeo.MapGuide.ObjectModels.FeatureSource_1_0_0.FeatureSourceType: No primary key defined for class: Fdo:Langkawi_poi_Shape_Index, features will not be selectable and feature joins on this class may produce unexpected results

but its ok. i think, i will try to edit the xml coding as shown in Jackie's post entitled FDO Schema Overrides

and i will update the progress.

pee ass: i think, if these succeed, i can join both data and the mission accomplished! :)

how to load non-spatial table and then join it with spatial data in mapguide? (unresolved yet)

ok. here's the thing.

i want to do a map that has external table.

why? the data condition doesnt permit me to do one-one relationship mapping.

so, i want to it this way (look at image below. ive done it using arcgis)

i tried to imply the same concept in Opensource Mapguide, but it seems like i met with failure each way.

the 1st problem is, i failed to load dbf file using SHP provider. the program recognize the absence of geometry as error.

so, i try to convert the data into *.mdb and manage to connect the data.

however the geometry properties is gone, gone and gone. aarrghh the sky is falling.

but nvm lah. i think i jz can re-load the with-geometry data using shp provider and relate both data.

so, i move on to create layer for the external table.

another road-block. error again since the data doesnt hv geometry.

get it? layer = geometry properties.

owh. so how? is there any resource in mapguide that allow user to create "table", or anything that allow the non-spatial table to be view and joined with spatial data?

i've already sent an email to jackie ng. I hope he is in a good mood and reply to my email :(

import mysql file

this is one part of my mysql lesson.

if copy-paste the database folder from directory of c:xampp/mysql/data/destinationfolder is not working for other laptop, try to export the database into .mysql using localhost/phpmyadmin

-end-