[gdal-dev] MDB tools

[Stefan Keller]

Even, tu es le meilleur...
:Stefan

2015-10-02 19:58 GMT+02:00 Even Rouault <even.rouault at spatialys.com>:
> 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