[gdal-dev] ogrinfo and PGeo Driver for .mdb file, on Ubuntu

[Chris Green]

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:eadam at co.lincoln.or.us] 
Sent: 24 October 2011 19:32
To: Chris Green
Cc: gdal-dev at lists.osgeo.org
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 <chris.green at ibstv.co.uk>
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
gdal-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev







-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20111025/3a0508be/attachment.html