Bug report #6293
evis not able to load MS access database table
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||duplicate|
|Crashes QGIS or corrupts data:||Yes||Copied to github as #:||15591|
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.
#2 Updated by Andre Joost over 7 years ago
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.
#4 Updated by Andre Joost over 7 years ago
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 #5832 / #5809, now fixed in master.