[Ubuntu] ESRI, Microsoft Access Personal Geodatabase, PGeo and
ogrinfo error: ODBC: Invalid install path
Katie Urey
ksurey at gmail.com
Fri Mar 2 13:41:31 EST 2012
Hello Etienne Tourigny,
Returned to repositories. Now have stack smashing.
Katie Urey
===========
PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0
PGeo: MDB Tools driver installed successfully!
PGeo: EstablishSession(sample_pgeo)
ODBC: SQLConnect(sample_pgeo)
*** stack smashing detected ***: ogrinfo terminated
======= Backtrace: =========
/lib/i386-linux-gnu/libc.so.6(__fortify_fail+0x50)[0x4e3df0]
/lib/i386-linux-gnu/libc.so.6(+0xe5d9a)[0x4e3d9a]
/usr/lib/libgdal1.8.0.so.1(+0x5cc194)[0x112d194]
/usr/lib/libgdal1.8.0.so.1(_ZN16CPLODBCStatement5FetchEii+0x77f)[0xee280f]
[0x302c2274]
======= Memory map: ========
[ lines removed..]
odbcinst -j
unixODBC 2.2.14
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-ver -M
mdbtools v0.6pre1
uname -a
Linux Edith-1 2.6.38-8-generic #42-Ubuntu SMP Mon Apr 11 03:31:50 UTC
2011 i686 i686 i386 GNU/Linux
On Fri, Mar 2, 2012 at 9:35 AM, Etienne Tourigny
<etourigny.dev at gmail.com> wrote:
> 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
More information about the Ubuntu
mailing list