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

Fri Mar 2 12:35:28 EST 2012

Your best bet is to uninstall what you installed manually, and stick
to the repositories.

cd ~/Downloads/unixODBC-2.3.1
make uninstall

And for the repositories, try

sudo apt-get install mdbtools unixodbc-bin

For gdal-1.9.0 I'm not sure it is available yet in ubuntugis-unstable
ppa, but it should be coming shortly.
Your other option is to build it manually, but it is somewhat involved.

Etienne

On Fri, Mar 2, 2012 at 2:22 PM, Katie Urey <ksurey at gmail.com> wrote:
> Hi Etienne Tourigny,
>
> Thank you for the suggestions and questions.
>
> I looked around for gdal-1.9 and did not find instructions that I
> thought I could follow.  I may later try gdal-1.9.
>
> About my installation.  Its been a few days.  I believe that I
> followed the instructions, but as a newbie, its possible
> that I made many mistakes.  So:
>
>   cd ~/Downloads/unixODBC-2.3.1
>  ./configure
>   make
>   make install
>
> If I uninstall, (not sure how...)  and re-install from repositories, I
> will have from apt-cache-
>
> Package: mdbtools
> Versions:
> 0.5.99.0.6pre1.0.20051109-7ubuntu1
> (/var/lib/apt/lists/us.archive.ubuntu.com_ubuntu_dists_natty_main_binary-i386_Packages)
> (/v
> ar/lib/dpkg/status)
>
> Package: unixodbc
> Versions:
> 2.2.14p2-2ubuntu1
> (/var/lib/apt/lists/us.archive.ubuntu.com_ubuntu_dists_natty_main_binary-i386_Packages)
> (/var/lib/dpkg/statu
> s)
>
> best regards,
>
> Katie Urey
> Portland, Oregon
>
>
> On Fri, Mar 2, 2012 at 5:57 AM, Etienne Tourigny
> <etourigny.dev at gmail.com> wrote:
>> 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