Hi Eli
Thanks for your suggestion. Despite pulling most of my hair out I still can't get past the syntax error thrown by the PGeo driver, so I would certainly be interested to follow the alternative approach. However I see in the drv_mdb documentation that GDAL/OGR >=1.9.0 is required, yet I can't find anything for Ubuntu later than 1.8 (from UbuntuGIS unstable). Do you have 1.9 on your Ubuntu, if so could you tell me where I can find it? Chris From: Eli Adam [mailto:[email protected]] Sent: 24 October 2011 19:32 To: Chris Green Cc: [email protected] Subject: Re: [gdal-dev] ogrinfo and PGeo Driver for .mdb file, on Ubuntu Chris, There is also another route that may work for PGeo, http://www.gdal.org/ogr/drv_mdb.html I recently built that on Ubuntu but have not used it yet. It looks like you are close on the other route though. HTH, Eli On Mon, Oct 24, 2011 at 5:35 AM, Chris Green <[email protected]> wrote: Hi List I'm hoping someone can help me make ogr work under Linux with the PGeo driver, so I can read an ESRI Personal Database .mdb file into Mapserver. I can see from old posts that the basic problem is that MDBTools is a bit 'flaky' and needs a DSN based connection rather than connecting direct to the .mdb data. I have been trying to follow the instructions in http://www.gdal.org/ogr/drv_pgeo.html . Having installed unixODBC and MDBTools, I configured the odbcinst.ini and odbc.ini files as suggested and it seems that I have partial success because when I define my datasource in odbc.ini like so: [my_pgeo] Description = Sample PGeo Database Driver = Microsoft Access Driver (*.mdb) Database = /var/www/vhosts/mydomain.com/httpdocs/data/test.mdb then the command ogrinfo PGeo:my_pgeo results in the following: INFO: Open of 'PGeo:my_pgeo' using driver 'PGeo' successful. Error: syntax error at line:2 col:0 I can't figure out what or where this syntax error can be. I feel that I am quite close to success but don't know how to move forward from here. Can anyone point me in the right direction please? Chris _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
