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 <[email protected]> | 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! _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
