search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.29k stars 2.96k forks source link

Geomedia MDB "Open File " -> Vector Data Not working #27428

Closed qgib closed 5 years ago

qgib commented 6 years ago

Author Name: ROCCO ABEL LUCIANO RABILOTTA PISTERS (ROCCO ABEL LUCIANO RABILOTTA PISTERS) Original Redmine Issue: 19601 Affected QGIS version: 3.2.1 Redmine category:data_provider

Hi,

I am in the process of using legacy data from Geomedia MDB (Access) format (Jet 3 and Jet 4 versions). When I try to open the file with the Geomedia MDB filter selected, and "Invalid format" error raises in QGIS Desktop (3.2.1). I have files made with Geomedia Versions 4, 5, 6 and 2015, but with 97 access format, and gives the same error each time.

An MDB file sample is appended.

qgib commented 6 years ago

Author Name: Giovanni Manghi (@gioman)

What ogrinfo (from the GDAL/OGR installation made by QGIS) says about this dataset? I guess that says that is not recognized.

See if this https://github.com/qgis/QGIS/issues/17462#issuecomment-495728330 or this #20256 helps.

Also: https://www.gdal.org/ogr_formats.html

Geomedia .mdb Geomedia No No No, needs ODBC library

https://www.gdal.org/drv_geomedia.html

qgib commented 5 years ago

Author Name: Jürgen Fischer (@jef-n)

Bulk closing 82 tickets in feedback state for more than 90 days affecting an old version. Feel free to reopen if it still applies to a current version and you have more information that clarify the issue.

qgib commented 5 years ago

Author Name: Roberto Marzocchi (@rmarzocchi84)

Jürgen Fischer wrote:

Bulk closing 82 tickets in feedback state for more than 90 days affecting an old version. Feel free to reopen if it still applies to a current version and you have more information that clarify the issue.

The problem affect also the LTR version of QGIS

qgib commented 5 years ago

Author Name: Roberto Marzocchi (@rmarzocchi84)

Roberto Marzocchi wrote:

Jürgen Fischer wrote:

Bulk closing 82 tickets in feedback state for more than 90 days affecting an old version. Feel free to reopen if it still applies to a current version and you have more information that clarify the issue.

The problem affect also the LTR version of QGIS

The outout of ogrinfo is:

ERROR 1: Unable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (.mdb, .accdb);DBQ=INFRAESTRUCTURA_INEGI_2015.mdb,

ERROR 1: Unable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (.mdb, .accdb);DBQ=INFRAESTRUCTURA_INEGI_2015.mdb,

FAILURE: Unable to open datasource `INFRAESTRUCTURA_INEGI_2015.mdb' with the following drivers. -> JP2ECW -> FileGDB -> OCI -> SOSI -> PCIDSK -> netCDF -> JP2OpenJPEG -> PDF -> MBTiles -> EEDA -> DB2ODBC -> ESRI Shapefile -> MapInfo File -> UK .NTF -> OGR_SDTS -> S57 -> DGN -> OGR_VRT -> REC -> Memory -> BNA -> CSV -> NAS -> GML -> GPX -> LIBKML -> KML -> GeoJSON -> GeoJSONSeq -> ESRIJSON -> TopoJSON -> Interlis 1 -> Interlis 2 -> OGR_GMT -> GPKG -> SQLite -> WAsP -> PGeo -> MSSQLSpatial -> OGR_OGDI -> PostgreSQL -> MySQL -> OpenFileGDB -> XPlane -> DXF -> CAD -> Geoconcept -> GeoRSS -> GPSTrackMaker -> VFK -> PGDUMP -> OSM -> GPSBabel -> SUA -> OpenAir -> OGR_PDS -> WFS -> WFS3 -> HTF -> AeronavFAA -> Geomedia -> EDIGEO -> GFT -> SVG -> CouchDB -> Cloudant -> Idrisi -> ARCGEN -> SEGUKOOA -> SEGY -> XLS -> ODS -> XLSX -> ElasticSearch -> Walk -> Carto -> AmigoCloud -> SXF -> Selafin -> JML -> PLSCENES -> CSW -> VDV -> GMLAS -> MVT -> TIGER -> AVCBin -> AVCE00 -> NGW -> HTTP