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@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
===========================================
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
