[ZS2] [mapguide-users] Connection on *.mdb

[Kenneth Skovhede, GEOGRAF A/S]

You need to do this:
1. Click "New"
2. Select "Dataconnection"
3. Select "OSGeo FDO provider for ODBC"
4. Select "File on the server (Unmanaged)"
5. Type the path to the .mdb file
6. Confirm the connection string
7. Click "Configure columns"
8. Select the table to the left.
9. Check the "Geometry" box
10. Select the x and y columns
11. Click OK
12. Click the "Save" button.

You now have a FeatureSource you can use in a layer, and it can display 
your points.
To theme the layer do this:
1. Click "New"
2. Select "Layer"
3. Click the "..." button and browse to your FeatureSource
4. Uncheck "Display lines" and "Display areas"
5. Click the green "+" next to the word "Rule"
6. Enter a filter, eg: 'Status' LIKE "Avalible"
7. Double click the point and select how an "Avalible" item should look.
8. Repeat for any additional states like "Busy", "Broken", etc.

Since the data is read from the database, you can update the database 
using regular sql, outside of MapGuide.
If you change the "Status" field, the point will also change apperance 
(eg. color) according to the rules.

Regards, Kenneth Skovhede, GEOGRAF A/S



ajid1980 skrev:
> Hai all.. 
>
> Platform : Mapguide maestro
>
> I have a *.mdf file.. what steps by step i need to know to import that *.mdb
> (on mapguide maestro) because that mdb has a status to change a point color
> ( on real time refresh or click )
>
> or
>
> any idea if i wanna put my status data on shp/dbf.. so how i wanna change
> the status for example..
>
> The situation like :
> ----------------------
> - when status changing to red colour.. then then point of map also changing
> red point
> - how i wanna change dbf/shp file?? changing the status web bases function..
> nop ESRI or other application)
>
> I need help to all forumer.. thanx
>