[Ubuntu] ESRI, Microsoft Access Personal Geodatabase, PGeo and
ogrinfo error: ODBC: Invalid install path
Katie Urey
ksurey at gmail.com
Fri Mar 2 12:22:53 EST 2012
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
More information about the Ubuntu
mailing list