Esri Personal GeoDatabase (*.mdb file)

[qgib]

Author Name: Almerio Moreira (@jorgealmerio)
Original Redmine Issue: 18234
Affected QGIS version: 3.0.0
Redmine category:vectors

---

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 issue(s): #20256 (relates)
Redmine related issue(s): 12054

---

[qgib]

Author Name: Andrea Giudiceandrea (@agiudiceandrea)

---

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.

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

• resolution was changed from to fixed/implemented
• status_id was changed from Open to Closed

[qgib]

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

---

• relates was configured as ODBC and geodatabase access fails on windows 7 64 bits #20256

[qgib]

Author Name: Mario Reyes (@ernesto561)

---

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=%%s

I 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