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

[Brent Fraser]

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
>