[gdal-dev] MDB tools - SOLVED

[Zoltan Szecsei]

Sorry - I didn't try he simple idea first:
Just use mdb-schema from mdb-tools.

Apologies for the bandwidth wastage.

Regards,
Zoltan


On 2012/03/28 15:57, Zoltan Szecsei 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
>
>
> Anyway, still no avail:
>
>> zls at gs0:~/q4x$ ogrinfo SSC_WC_Q43.mdb
>> ERROR 1: PGeo: MDB Tools driver not found!
>>
>> Warning 1: Unable to install MDB driver for ODBC, MDB access may not 
>> supported.
>>
>> ERROR 1: Unable to initialize ODBC connection to DSN for 
>> DRIVER=Microsoft Access Driver (*.mdb);DBQ=SSC_WC_Q43.mdb,
>> [unixODBC][Driver Manager]Data source name not found, and no default 
>> driver specified
>> ERROR 1: PGeo: MDB Tools driver not found!
>>
>> Warning 1: Unable to install MDB driver for ODBC, MDB access may not 
>> supported.
>>
>> ERROR 1: Unable to initialize ODBC connection to DSN for 
>> DRIVER=Microsoft Access Driver (*.mdb);DBQ=SSC_WC_Q43.mdb,
>> [unixODBC][Driver Manager]Data source name not found, and no default 
>> driver specified
>> FAILURE:
>> Unable to open datasource `SSC_WC_Q43.mdb' with the following drivers.
>>   -> ESRI Shapefile
>>   -> MapInfo File
>>   -> UK .NTF   [etc tec]
>
> I then removed the packages and reinstalled them using synaptic, only 
> to get errors regarding no gdalinfo in /usr/local/bin, even though 
> which gdalinfo returns /usr/bin/gdalinfo (without the 'local')
>
>
> Can anyone spot my deliberate mistake?
> Will ogrinfo be able to give me the schema printout that I want, or is 
> there a better way?
> (I am not an Access user)
>
> Thanks in advance,
> Zoltan
>
>
>
>
>


-- 

===========================================
Zoltan Szecsei PrGISc [PGP0031]
Geograph (Pty) Ltd.
P.O. Box 7, Muizenberg 7950, South Africa.

65 Main Road, Muizenberg 7945
Western Cape, South Africa.

34° 6'16.35"S 18°28'5.62"E

Tel: +27-21-7884897  Mobile: +27-83-6004028
Fax: +27-86-6115323     www.geograph.co.za
===========================================