[mapserver-users] How to join to a MDB database for display on my map?

[Brent Fraser]

I use GDAL's ODBC driver to join to the mdb:

     CONNECTIONTYPE OGR
     CONNECTION     'G:/GeoData/Parcels/Alberta/t_505033.shp'
     DATA "SELECT * FROM t_505033 LEFT JOIN 
'ODBC:Parcels_Rural,basic'.basic ON t_505033.PID=basic.PID"

allowing me to use values from the table "basic" in the mdb for 
labeling, etc:

     LABELITEM  'LINC'
     CLASSITEM 'STATUS'

Best Regards,
Brent Fraser


On 11/18/2011 9:22 AM, boesiii wrote:
> I have a polygon shapefile showing parcel outlines and an access database
> containing owner names.  I would like add a layer displaying the owner name
> but after reading the MapServer documentation "You cannot use joins to
> affect the look of a map", I realize this is not possible.
>
> Is there any other way to accomplish what I am trying to do?
>
> Is there an OGR/GDAL command line function that will export the table from
> the MDB to DBF file?
>
> I know I can join the files together using ESRI ArcGIS but was hoping to
> leave the files in the original format because the data is maintained by
> someone else.
>
>
>
> --
> View this message in context: http://osgeo-org.1803224.n2.nabble.com/How-to-join-to-a-MDB-database-for-display-on-my-map-tp7008818p7008818.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>