I try over 2 days to connect an ESRI Personal Geodatabase with QGIS 2.8.1
Here is my testing report.
Testing environment: Windows 7 64bit; MS Office 32bit; QGIS 32Bit
1. Step: Creating an ODBC-System-DSN We have a 32bit Office installation. We find the 32bit ODBC-Administration-Tool under:
C:\Windows\SysWOW64\odbcad32.exe
The mdb-File is an ESRI Personal Geodatabase.
2. Step: Testing the ODBC-Connecting work With the database4.exe, which is free, I tested the new ODBC-Connecting does work. (http://fishcodelib.com/Database.htm)
Yeeees, very good!
And here you can see all tables in the mdb-File.
3. Step: Open with ODBC-Connection in QGIS
Yeees, very good. The ODBC is working!
Oh NO, the Geometrytyp is UNKNOWN!!
4. Step: Open with ESRI-Personal-GeoDatabase-Connection in QGIS
Oh NO, the ESRI-Personal-GeoDatabase-Connection doesn't work! Why?
Reference 1: Should I try the QGIS 64bit Version? Like this Post: http://gis.stackexchange.com/a/139716/53879 My opinion is, that in this Post with drag the mdb file into your workspace is NOT an ODBC-Connection. The ESRI Personal Geodatabase will add with "Add Vector-Layer.." in File-Modus. Just try, drag a mdb-file into the Workspace. It will open... But I want to connect the ESRI Personal Geodatabase in Database-Modus.
Reference 2: In this post: http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase The Workaround work. I think here is QGIS 64bit installed.
QUESTIONS: _Why work the ODBC-Test and the ESRI-Personal-GeoDatabase-Test not?
_Should I try my Workaourond in QGIS 64bit Installation? Have anybody some expierence?
Problem: I want to connect an existing ESRI-Personal-GeoDatabase (*.mdb) over ODBC and edit the Datas. In 32bit Installation of QGIS ist this not possible!!
Thank you for any Ideas!
أكثر...
Here is my testing report.
Testing environment: Windows 7 64bit; MS Office 32bit; QGIS 32Bit
1. Step: Creating an ODBC-System-DSN We have a 32bit Office installation. We find the 32bit ODBC-Administration-Tool under:
C:\Windows\SysWOW64\odbcad32.exe
The mdb-File is an ESRI Personal Geodatabase.
2. Step: Testing the ODBC-Connecting work With the database4.exe, which is free, I tested the new ODBC-Connecting does work. (http://fishcodelib.com/Database.htm)
Yeeees, very good!
3. Step: Open with ODBC-Connection in QGIS
Yeees, very good. The ODBC is working!
Oh NO, the Geometrytyp is UNKNOWN!!
4. Step: Open with ESRI-Personal-GeoDatabase-Connection in QGIS
Oh NO, the ESRI-Personal-GeoDatabase-Connection doesn't work! Why?
Reference 1: Should I try the QGIS 64bit Version? Like this Post: http://gis.stackexchange.com/a/139716/53879 My opinion is, that in this Post with drag the mdb file into your workspace is NOT an ODBC-Connection. The ESRI Personal Geodatabase will add with "Add Vector-Layer.." in File-Modus. Just try, drag a mdb-file into the Workspace. It will open... But I want to connect the ESRI Personal Geodatabase in Database-Modus.
Reference 2: In this post: http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase The Workaround work. I think here is QGIS 64bit installed.
QUESTIONS: _Why work the ODBC-Test and the ESRI-Personal-GeoDatabase-Test not?
_Should I try my Workaourond in QGIS 64bit Installation? Have anybody some expierence?
Problem: I want to connect an existing ESRI-Personal-GeoDatabase (*.mdb) over ODBC and edit the Datas. In 32bit Installation of QGIS ist this not possible!!
Thank you for any Ideas!
أكثر...