[gdal-dev] MDB tools

[Even Rouault]

Le vendredi 02 octobre 2015 19:54:12, Stefan Keller a écrit :
> 2015-10-02 16:35 GMT+02:00 I wrote
> 
> > Yes, I'm testing GDAL 1.11.2, released 2015/02/10, in Windows which
> > supports PGeo and Geomedia.
> > My problem is, how can I tell ogrinfo's and ogr2ogr that myfile.mdb is
> > Geomedia and not PGeo (since both have fileextension .mdb)?
> 
> That's the command and the error messages I get:
> 
> C:\Users\sfkeller\Downloads>ogrinfo fussgaengerstreifen.mdb -al -so
> ERROR 1: Unable to initialize ODBC connection to DSN for DRIVER=Microsoft
> Access Driver (*.mdb);DBQ=fussgaengerstreifen.mdb,
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> drive r specified
> ERROR 1: Unable to initialize ODBC connection to DSN for DRIVER=Microsoft
> Access Driver (*.mdb);DBQ=fussgaengerstreifen.mdb,
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> drive r specified
> FAILURE:
> Unable to open datasource `fussgaengerstreifen.mdb' with the following
> drivers. -> OCI
>   -> ...

Perhaps you hit https://trac.osgeo.org/gdal/ticket/5594 ?

> 
> :Stefan
> 
> 2015-10-02 16:35 GMT+02:00 Stefan Keller <sfkeller at gmail.com>:
> > Zoltan
> > 
> > Yes, I'm testing GDAL 1.11.2, released 2015/02/10, in Windows which
> > supports PGeo and Geomedia.
> > My problem is, how can I tell ogrinfo's and ogr2ogr that myfile.mdb is
> > Geomedia and not PGeo (since both have fileextension .mdb)?
> > 
> > :Stefan
> > 
> > 2015-10-02 15:48 GMT+02:00 Zoltan Szecsei <zoltans at geograph.co.za>:
> >> Hi,
> >> Look at http://www.gdal.org/ogr_formats.html
> >> 
> >> IIRC ogr2ogr needed that - but ogrinfo?  not sure - maybe the -oo param?
> >> 
> >> You could also use ogrinfo --formats
> >> to see what's available on your system.
> >> 
> >> Hopefully others will chip in too.
> >> Regards,
> >> Zoltan
> >> 
> >> On 2015-10-02 15:38, Stefan Keller wrote:
> >>> I have a similar issue and supposedly a very simple question:
> >>> Given a file Geomedia .mdb file I'm getting a similar error on Windows.
> >>> % ogrinfo myfile.mdb -al -so
> >>> How does OGR recognize if it's a Personal Geodatabase or a Geomedia
> >>> file?
> >>> 
> >>> :Stefan
> >>> 
> >>> 2012-03-28 16:19 GMT+02:00 Paolo Corti <pcorti at gmail.com>:
> >>>> On Wed, Mar 28, 2012 at 3:57 PM, Zoltan Szecsei
> >>>> <zoltans at geograph.co.za>
> >>>> 
> >>>> wrote:
> >>>>> Hi All,
> >>>>> 
> >>>>> I am trying to find a way to list the data type of each field in all
> >>>>> tables
> >>>>> in a GeoMedia MDB databse.
> >>>>> 
> >>>>> I tried ogrinfo mdbname and got:  ERROR 1: PGeo: MDB Tools driver not
> >>>>> found!
> >>>>> 
> >>>>> so, sudo apt-get install mdbtools, and tried again and got same
> >>>>> error.
> >>>>> 
> >>>>> so, sudo apt-get install gdal-bin and that gave me a newer version
> >>>>> than that
> >>>>> I did have.
> >>>>> Interestingly apt-get returned:    Setting up gdal-bin
> >>>>> (1.9.0-1~exp5~lucid4)
> >>>>> ...... etc etc
> >>>>> but afterwards:  ogrinfo --version still returns GDAL 1.8.1, released
> >>>>> 2011/07/09
> >>>> 
> >>>> As you are on Linux, you should avoid the rely on ODBC, and use the
> >>>> Geomedia driver [1], only available from gdal 1.9.
> >>>> I would test it for you, but I have no Geomedia sample data for
> >>>> testing
> >>>> 
> >>>> p
> >>>> 
> >>>> [1] http://www.gdal.org/ogr/drv_geomedia.html
> >>>> 
> >>>> --
> >>>> Paolo Corti
> >>>> Geospatial software developer
> >>>> web: http://www.paolocorti.net
> >>>> twitter: @capooti
> >>>> skype: capooti
> >>>> _______________________________________________
> >>>> gdal-dev mailing list
> >>>> gdal-dev at lists.osgeo.org
> >>>> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> >> 
> >> --
> >> 
> >> ===========================================
> >> Zoltan Szecsei PrGISc [PGP0031]
> >> Geograph (Pty) Ltd.
> >> GIS and Photogrammetric Services
> >> 
> >> P.O. Box 7, Muizenberg 7950, South Africa.
> >> 
> >> Mobile: +27-83-6004028
> >> Fax:    +27-86-6115323     www.geograph.co.za
> >> ===========================================
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com