[mapserver-users] OGR Join To MS-Access Without Using ODBC

James Card James.Card at calcad.com
Thu Dec 2 21:30:24 PST 2010


I'm trying to determine what syntax to use to create an OGR join to an MS  
Access database *without* using ODBC (on a Windows server). Is that  
possible?

Current syntax is: DATA "SELECT * FROM LHFO_Routes shp LEFT JOIN  
'ODBC:Routes_MDB,vRoutesTheme'.vRoutesTheme mdb ON  
shp.ROAD_NO_=mdb.RouteNumber"

-- 
James Card
California CAD Solutions, Inc.
209-578-5580 - Voice
209-521-6493 - FAX



More information about the MapServer-users mailing list