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
