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

[Chris Green]

Hi Eli

 

Thanks very much for the details. It all seems rather daunting, I think I
will punish myself with one more day of trying to get PGeo to work before
tackling MDB     

 

 

 

 

Chris

 

From: Eli Adam [mailto:eadam at co.lincoln.or.us] 
Sent: 25 October 2011 17:39
To: Chris Green
Cc: gdal-dev at lists.osgeo.org
Subject: Re: [gdal-dev] ogrinfo and PGeo Driver for .mdb file, on Ubuntu

 

Chris, 

GDAL 1.9 is trunk so I built from source.  You need to first install
subversion, a compiler and other things to compile software.  Once you have
the proper environment, then for the basic GDAL build (which would not
include mdb of any sort) it is not too difficult and there are directions on
the wiki, http://trac.osgeo.org/gdal/wiki/BuildingOnUnix

Adding in more formats and drivers is more difficult.  Usually, there are
details on the format page, http://gdal.org/ogr/drv_mdb.html and/or the
build hints section of the wiki, http://trac.osgeo.org/gdal/wiki/BuildHints

For the way I did it for the Access mdb driver, I had to make a file
/etc/ld.so.sonf.d/libjvm.conf which just has the path pointing to libjvm.so
I did this based on the file not found errors I got after compiling and
running ogrinfo on the first attempt.  I don't fully understand what is the
proper way to address issues like this and there may be better ways.  I
first learned about it using the FileGDB driver.  Here is that thread,
http://osgeo-org.1803224.n2.nabble.com/gdal-dev-FileGDB-OGR-driver-test-td62
37191.html  Even's suggestion about adding to LD_LIBRARY_PATH and these two
links are mostly what helped me figure it out.  

http://stackoverflow.com/questions/480764/linux-error-while-loading-shared-l
ibraries-cannot-open-shared-object-file-no-su
and 
http://replay.waybackmachine.org/20090301081221/http://www.linux.org/docs/ld
p/howto/Program-Library-HOWTO/shared-libraries.html
<http://replay.waybackmachine.org/20090301081221/http:/www.linux.org/docs/ld
p/howto/Program-Library-HOWTO/shared-libraries.html> 

HTH, Eli



On Tue, Oct 25, 2011 at 12:20 AM, Chris Green <chris.green at ibstv.co.uk>
wrote:

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/20111026/aa2860fb/attachment.html