personal-geodatabaseqgis
My environment:
Windows 7 Professional:
Service Pack 1
64-Bit
QGIS:
QGIS-Version: 2.8.2-Wien
32-Bit
Microsoft Office 2010 Professional:
32-bit
I want to connect an ESRI Personal Geodatabase (*.mdb) with the "Add Vectorlayer" feature in QGIS
The problem is with the Access Jet driver.
My Questions:
Has anybody successfully connected to an ESRI Personal Geodatabase in QGIS 2.8.2?
As shown under your menu on QGIS: HELP>ABOUT>, what version of GDAL/OGR is your QGIS compiled against? Is that 1.9.2?
Note there are two ways of doing this. The way you are going about doing it is the long way but that is the way I am going to show how to do it here. The other way is by just going to Add Vector Layer and then selecting file and then browsing to where your .mdb file is located and opening the .mdb file.
First, you need to make sure QGIS 32 bit version is being used. Download and install QGIS for Windows 32 bit. You need a 32 bit version of QGIS because Microsoft does not make a 64 bit driver for Access(.mdb). Esri ArcMap is 32 bit too so it can work with .mdb files.
Second, you need to create a DSN(Data Source Name). To create a DSN, Go to your start button and click it.
Next in the search box, type %windir%\SysWoW64\odbcad32.exe and click on the odbcad32.exe program.
Click on the System DSN tab
Click on the add button to add a dsn so ODBC and Esri Personal Database.mdb can be accessed. Once you click on the Add button a new dialog will appear. On this dialog, select Microsoft Access Driver(*.mdb) and click finish.
After clicking finish, another dialog will appear. In this dialog, put QGIS for the Data Source Name.
Next click on the Select button under Databases. Once you select this button, another dialog will appear.It is the select database dialog.
On this dialog, you need to navigate to your .mdb file. Once you are in the folder the .mdb file will appear in the left box. Select your .mdb file and click OK
Now you should see the ODBC Microsoft Access Setup Dialog. The Dialog should show you your .mdb file like the dialog box below.
Now click OK on the dialog box. Also make note, the DATA Source Name is QGIS. We will use this name when setting up an ODBC .mdb / Esri Personal GeoDatabase.mdb. Once you click ok you should see a dialog box like the following, which shows the DSN you just created. Click ok on this dialog box to close it out.
Now open up QGIS 2.4 and go to Add Vector Layer
Now, Select database and then select your Encoding you want and then under Database Type select Esri Personal GeoDatabase
Now, on the same dialog, click the New Button
A new dialog box will appear. On this dialog box, fill out the Type, Name and Database fields. For the Type field, select Esri Personal GeoDatabase. For the Name, type whatever you want. For the Database field, type QGIS. Note that QGIS is the same name as the DSN that we created earlier.
Now click on the test button.
If everything is setup correctly, you will see this after clicking on the test button.
Next click ok to close out the test and then click Ok to finish the database connection.
Now you should see the name you gave the connection and once you do, click the Open Button. Once you click open, it will ask for a password. Just click ok, unless the database has a password.
After clicking ok on the password dialog box, you will see a dialog like below:
Select your layer and click ok. After selecting the layer you want and clicking ok you will see another dialog box. This dialog box is for setting coordinate references.
And we are done! You can do this with regular .mdb or Esri Personal GeoDatabase. To do it this way, you need to create a DSN and then set up a connection. There is a simpler way and that is just by going to add vector and making sure File is selected and then just browsing to your .mdb. Note, you need QGIS 32 bit to work with .mdb databases.
Best Answer
Thank you for your inputs.
My source is an ESRI Personal Geodatabase (*.mdb). I can open the source in MS Access. The table GDB_ColumInfo, GDB_GeoColumns, GDB_ITEMRELATIONSHIPS, etc. and many Geometry-Table are there.
I have already created a successful connection on File (Datei) and File Type ESRI-Personal GeoDatabase (*.mdb). It runs, but it is a "READ ONLY" Connection.
But now, I want a Connection on Database (Datenbank) with the hope this will be a "READ-WRITE" Connection.
I read a lot in the forum, I must first install the correct Access Jet Driver. 32bit or 64 bit under MS Windows System Settings
I will now following the way from Michael Miles Stimson with northrivergeographic.com/qgis-accessing-personal-geodatabase