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 <ksu...@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....@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 <ksu...@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@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/ubuntu >>> http://trac.osgeo.org/ubuntugis/wiki _______________________________________________ UbuntuGIS mailing list Ubuntu@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/ubuntu http://trac.osgeo.org/ubuntugis/wiki