[mapserver-users] Re: How to join to a MDB database for display on my map?
Brent Fraser
bfraser at geoanalytic.com
Fri Nov 18 10:17:53 PST 2011
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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
More information about the MapServer-users
mailing list