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 <[email protected]> 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 <[email protected]> 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 >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/ubuntu >> http://trac.osgeo.org/ubuntugis/wiki _______________________________________________ UbuntuGIS mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/ubuntu http://trac.osgeo.org/ubuntugis/wiki
