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

[Etienne Tourigny]

Have you tried the MDB driver with gdal-1.9 ?  It might be more easy
to setup -> http://gdal.org/ogr/drv_mdb.html

If not - How did you install ODBC? Have you followed the installation
instructions in the document you linked to?

Etienne

On Thu, Mar 1, 2012 at 7: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