Bug report #18234
Esri Personal GeoDatabase (*.mdb file)
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Vectors | ||
| Affected QGIS version: | 3.0.0 | Regression?: | Yes |
| Operating System: | Windows 7 Professional | Easy fix?: | No |
| Pull Request or Patch supplied: | No | Resolution: | fixed/implemented |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 26125 |
Description
I can not load a Esri personal Geodatabase file into Qgis 3 anymore.
I has already added the following lines to qgis.bat:
set OGR_SKIP=ODBC
set PGEO_DRIVER_TEMPLATE=DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=%%s
I also have QGIS 2.18.17 (LTR) installed on same machine and It still working there.
I installed both from OSGeo
Related issues
Associated revisions
osgeo4w: include PGEO_DRIVER_TEMPLATE and OGR_SKIP in qgis.vars
(fixes #18234)
osgeo4w: include PGEO_DRIVER_TEMPLATE and OGR_SKIP in qgis.vars
(fixes #18234)
(cherry picked from commit a9b663ec0cdf47ba99bab593139da9c108d977da)
History
#1
Updated by Andrea Giudiceandrea over 6 years ago
It seems that QGIS 3 is now launched directly, not through qgis.bat as was for QGIS 2.18.
Now you need to set the two variables in QGIS Settings panel -> Options | System | Environment.
The names and the values of the variables are:
variable name: OGR_SKIP
value: ODBC
variable name: PGEO_DRIVER_TEMPLATE
value: DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=%s
note that there is only one percent sign in the value of PGEO_DRIVER_TEMPLATE variable.
#2
Updated by Nyall Dawson over 6 years ago
- Resolution set to fixed/implemented
- Status changed from Open to Closed
#3
Updated by Jürgen Fischer over 6 years ago
- Related to Bug report #12054: ODBC and geodatabase access fails on windows 7 64 bits added
#4
Updated by Mario Reyes over 6 years ago
Almerio Moreira wrote:
I can not load a Esri personal Geodatabase file into Qgis 3 anymore.
I has already added the following lines to qgis.bat:
set OGR_SKIP=ODBC
set PGEO_DRIVER_TEMPLATE=DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=%%sI also have QGIS 2.18.17 (LTR) installed on same machine and It still working there.
I installed both from OSGeo
I am trying to load a ESRI personal Geodatabase in QGIS 3.03 (Windows 10) and it's not working. The personal geodatabase file can be downloaded from this link: https://pubs.usgs.gov/of/1997/ofr-97-470/OF97-470K/graphic/data.html