[Ubuntu] ESRI, Microsoft Access Personal Geodatabase, PGeo and ogrinfo error: ODBC: Invalid install path

[Johan Van de Wauw]

A few things you can try:

It seems that you have installed a local copy in /usr/local/lib,
whereas gdal is looking for mdbtools in /usr/lib
Can you tell us where limdb is installed?
ls  /usr/lib/libmdbodbc*
ls /usr/local/lib/libmdbodbc*
and which odbcinst you are running:
which odbcinst

It is usually better to install from the repositories rather than from
source, you may mix things which are compiled against different
versions of unixodbc.
Consider installing mdbtools and odbc using the provided packages:
mdbtools and unixodbc-bin

Apart from that: ODBCSYSINI is an environment variable. You can always
set it by running export ODBCSYSINI= sth before running your command.

Johan

On Thu, Mar 1, 2012 at 11:07 PM, Katie Urey <ksurey at gmail.com> wrote:
> Friends,
>
> Per notes on this web page, http://gdal.org/ogr/drv_pgeo.html
>
> I believe that I should be able to read tables from a Microsoft/ESRI
> personal geodatabase by using ogr* commands.
>
> Not yet. The Current error is "ODBC: Invalid install path". It
> would be simple if a typo or an install mistake was confirmed.
> For instance- did I err in the install to get
> ODBCSYSINI set to my home dir?  If so, do I re-install or
> override?
>
> Also, please advise if I should send to another list.
>
> -best
> Katie Urey
> Portland, Oregon
>
>
> some details:
>
> -1:/home/GISData/CurbCuts$ ogrinfo --debug on PGeo:sample_pgeo
>  PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0
>  ODBC: HOME=/home/katie
>  ODBC: ODBCSYSINI=/home/katie
> **ERROR 1: ODBC: Invalid install path
>  Warning 1: Unable to install MDB driver for ODBC, MDB access may not
> supported.
>
>  PGeo: EstablishSession(sample_pgeo)
>  ODBC: SQLConnect(sample_pgeo)
>  ODBC: ... failed: [unixODBC][Driver Manager]Data source name not
> found, and no default driver specified
>  ODBC: SQLDisconnect()
>  ERROR 1: Unable to initialize ODBC connection to DSN for sample_pgeo,
>  [unixODBC][Driver Manager]Data source name not found, and no default
> driver specified
>  PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0
>  ERROR 1: ODBC: Invalid install path
>  Warning 1: Unable to install MDB driver for ODBC, MDB access may not
> supported.
>
>  PGeo: EstablishSession(sample_pgeo)
>  ODBC: SQLConnect(sample_pgeo)
>  ODBC: ... failed: [unixODBC][Driver Manager]Data source name not
> found, and no default driver specified
>  ODBC: SQLDisconnect()
>  ERROR 1: Unable to initialize ODBC connection to DSN for sample_pgeo,
>  [unixODBC][Driver Manager]Data source name not found, and no default
> driver specified
>  FAILURE:
>  Unable to open datasource `PGeo:sample_pgeo' with the following
> drivers.
>
>
> I am working on a Ubuntu/Natty OS with unixODBC 2.3.1, which I installed
> from a
> tar download using the defaults.  (I am ignorant of make/configure..)
>
> I am able to see the tables in the ESRI Personal Geodatabase by using
> DataManager
> and mdb-tables.
>
> The gdal info:
> GDAL 1.8.0, released 2011/01/12
>
>
> ==============
>
> odbcinst -j
> unixODBC 2.3.1
> DRIVERS............: /usr/local/etc/odbcinst.ini
> SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
> FILE DATA SOURCES..: /home/GISData/CurbCuts/
> USER DATA SOURCES..: /home/katie/.odbc.ini
> SQLULEN Size.......: 4
> SQLLEN Size........: 4
> SQLSETPOSIROW Size.: 2
>
> ====
>
> mdb-tables WPC_study_area_data_from_PBOT.mdb
> GDB_ReleaseInfo GDB_FeatureDataset GDB_ObjectClasses GDB_FeatureClasses
> GDB_RelClasses GDB_ValidRules GDB_AttrRules GDB_RelRules
> GDB_EdgeConnRules GDB_JnConnRules GDB_Topologies GDB_TopoRules
> GDB_TopoClasses GDB_DefaultValues GDB_Subtypes GDB_Domains
> GDB_RangeDomains GDB_CodedDomains GDB_UserMetadata GDB_FieldInfo
> GDB_Extensions GDB_Replicas GDB_ReplicasEx GDB_ReplicaDatasets
> GDB_Toolboxes GDB_RasterCatalogs GDB_ExtensionDatasets GDB_ReplicaLog
> GDB_AnnoSymbols GDB_SpatialRefs GDB_GeomColumns Streets_pdx_Shape_Index
> Streets_pdx Selections SelectedObjects Tax_Parcels_Shape_Index
> Tax_Parcels Sidewalks_Shape_Index Sidewalks Curb_Ramps_Shape_Index
> Curb_Ramps Driveways_Shape_Index Driveways PM_Symbols_Shape_Index
> PM_Symbols PM_Lines_Shape_Index PM_Lines MAX_Shape_Index MAX
> LH_Intersections_Shape_Index LH_Intersections LH_Nodelegs_Shape_Index
> LH_Nodelegs LH_Blockfaces_Shape_Index LH_Blockfaces
> LH_Segments_Shape_Index LH_Segments
>
> ============Access DSN in /usr/local/etc/odbcinst.ini
>
> 1:~$ grep -A7 Access /usr/local/etc/odbcinst.ini
> [Microsoft Access Driver (*.mdb)]
> Description     = MDB Tools ODBC drivers
> Driver          = /usr/lib/libmdbodbc.so.0
> Setup           =
> FileUsage       = 1
> CPTimeout       =
> CPReuse         =
>
> and in ~/.odbc.ini
> [sample_pgeo]
> Description     = Sample PGeo Database for Curb Cuts
> Driver          = Microsoft Access Driver (*.mdb)
> Database        = /home/GISData/CurbCuts/WPC_study_area_data_from_PBOT.mdb
> Host            = localhost
> Port            = 1360
> User            = katie
> Password        =
> Trace           = Yes
> _______________________________________________
> UbuntuGIS mailing list
> Ubuntu at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/ubuntu
> http://trac.osgeo.org/ubuntugis/wiki