evis not able to load MS access database table

[qgib]

Author Name: Andre Joost (Andre Joost)
Original Redmine Issue: 6293
Affected QGIS version: master
Redmine category:c++_plugins
Assignee: ersts-amnh-org -

---

I tried to connect to a MSAccess database table via evis. The database table has fields E and N with coordinates for points.
Qgis 1.7.4 connects and loads correctly, but re-opening a saved project leads to "defect layers" dialogue.
Qgis 1.8.0 does the same, but crashes on re-opening the project.
Qgis master crashes at loading the database. The form for choosing x and y data fields is the last I get.

---

Related issue(s): #15458 (duplicates)
Redmine related issue(s): 6119

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

tagging as blocker as in 1.7.4 didn't crashed the program, so id indeed a regression.

---

• fixed_version_id was configured as Version 2.0.0
• category_id was configured as C++ Plugins
• assigned_to_id was configured as ersts-amnh-org
• priority_id was changed from Normal to Severe/Regression

[qgib]

Author Name: Andre Joost (Andre Joost)

---

After a fresh install, it works in Master, but 1.8.0 still crashes on reopening (possibly known defect of "defect layers" handling).
But it would be good to get re-opening of projects working. In the qgs file, only the path to a temporary database is given. Database path and SQL query string are not stored.

[qgib]

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

---

what temporary database? A delimited text file that doesn't exist anymore? Then this might be a duplicate of #15307 and/or #15458.

[qgib]

Author Name: Andre Joost (Andre Joost)

---

Yes, it is a delimited text file, which gets deleted after closing the program. If I save it before closing, and restore it to the temp folder, the project reopens.
Strangely enough, that file will not be deleted on closing the project anymore...
But that would not be a live connection to the database anymore. Storing the database connection parameters would be better (like for spatialite databases).
In Qgis 1.8.0, you get the crash because of bug #15307 / #15292, now fixed in master.

[qgib]

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

---

• resolution was changed from to duplicate
• status_id was changed from Open to Closed