[Qgis-user] Once again mdb files on Linux.

[Fernando M. Roxo da Motta]

  Hi all,


  Has someone tried to load MDB file on QGIS in Linux lately?

  I went through this list history and read a lot about people trying
to load this kind of data in QGIS and failing.   So far the impression
I have is that it is only feasible using Windows 32 bits.   I don't
remember to read a single case of success in Linux.

  I am trying to follow the instructions from many messages, in many
lists, in many languages without success.

  I am running [Xu|U]buntu 14.04.2 LTS 64 bits, with QGIS 2.8.2 64 bits
from QGIS repository (using apt-get).  I have installed mdbtools,
odbc-mdbtools and unixodbc, everything with 64bits.

  I have the following configurations:

$ cat /etc/odbcinst.ini
[MDBTools]
Description             = MDBTools Driver
Driver          = libmdbodbc.so
Setup           = libmdbodbc.so
FileUsage               = 1
UsageCount              = 1

$ cat .odbc.ini 
[Limites]
Description = Something to test
Driver = MDBTools
Database = ~/gis/dados/Meus/MDB/Limites.mdb
Host        = 
Port        = 
User        = 
Password    =
Trace       = Yes
TraceFile   = /tmp/Limites.log

$ odbcinst -q -s
[Limites]

$ isql Limites
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

  If I try a number of queries it seems to work.


  If someone wnt to give it a try, the Limites.mdb file was obtained at:

ftp://geoftp.ibge.gov.br/mapeamento_sistematico/base_vetorial_continua_escala_250mil/Limites.zip

  Ogrinfo, _in_principle_, as support for ODBC and PGeo:

$ ogrinfo --formats|grep 'PGeo\|ODBC'
  -> "ODBC" (read/write)
  -> "PGeo" (readonly)


$ ogrinfo PGeo:Limites
ERROR 1: PGeo: MDB Tools driver not found!

Warning 1: Unable to install MDB driver for ODBC, MDB access may not
supported.

ERROR 1: PGeo: MDB Tools driver not found!

Warning 1: Unable to install MDB driver for ODBC, MDB access may not
supported.

FAILURE:
Unable to open datasource `PGeo:Limites' with the following drivers.
======= long list clipped ==========8<---------------

$ ogrinfo ODBC:Limites
geometry_columns is not a table in this database
Got no result for 'SELECT f_table_name, f_geometry_column,
geometry_type FROM geometry_columns' command INFO: Open of
`ODBC:Limites' using driver `ODBC' successful.

  In QGIS I tried to load using "insert vector layer->database" and
tried to configure two types of connections 'ESRI Personal GeoDatabase'
and 'ODBC'.   In both I configured just a name and a DSN from ODBC.
The test for Personal GeoDatabase failed but for ODBC succeeded.  But
when trying to load using ODBC connection it fail saying that
ODBC-Limites is not a recognized data source.

  One interesting thing (IMHO) is that if I insert the path for the MDB
file when trying the Personal GeoDatabase configuration the error in
QGIS reads:

Connection failed - Check settings and try again.

Extended error information:
Unable to initialize ODBC connection to DSN for
~/gis/dados/Meus/MDB/Limites.mdb, [unixODBC][Driver Manager]Data source
name not found, and no default driver specified

  If I use just the DSN of the '~/.odbc.ini' the error reads:

Connection failed - Check settings and try again.

Extended error information:


  After all this, is there anything else worth a try?


  TIA



  Roxo

-- 
---------------- Non luctari, ludare -------------------+ WYSIWYG
Fernando M. Roxo da Motta <petro at roxo.org>              | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
      ( Usuário Linux registrado #39505 )               | I see text,
------------ Quis custodiet ipsos custodes?-------------+ I get text!