Try using ogrinfo on the command line to make sure the ogr/odbc portion
works:
ogrinfo -sql "SELECT * FROM PLOTS LEFT JOIN
'ODBC:geoplan,County_Taxid_Parcels'.County_Taxid_Parcels ON
PLOTS.SHRT_TXID=County_Taxid_Parcels.SHRT_TXID"
D:\ms4w\apps\ftmagisapp_v2\maps\background\PLOTS.shp
Best Regards,
Brent Fraser
On 11/18/2011 11:01 AM, boesiii wrote:
Brent,
I tried your suggestion, but I get an internal server error, when I turn on
the layer. Part of MAP file below:
CONNECTIONTYPE OGR
CONNECTION 'D:/ms4w/apps/ftmagisapp_v2/maps/background/PLOTS.shp'
DATA "SELECT * FROM PLOTS LEFT JOIN
'ODBC:geoplan,County_Taxid_Parcels'.County_Taxid_Parcels ON
PLOTS.SHRT_TXID=County_Taxid_Parcels.SHRT_TXID"
LABELITEM 'OWNR_NAME'
In the apache error log it stated Premature end of script headers:
mapserv.exe, referer: http://127.0.0.1/ftmagisapp_v2/geomoose.html
Does it make a difference if I am on Windows 7 64bit and I am using the
32bit ODBC?
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/How-to-join-to-a-MDB-database-for-display-on-my-map-tp7008818p7009187.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
