This question already has an answer here:

I downloaded the naturalearthdatabase in sqlite-format (http://www.naturalearthdata.com/downloads/, the downloadlink goes to http://kelso.it/x/nesqlite), but qgis 2.2 (running under win 7 64bit) does not load it ("unexpected error"), but I can open the db in sqlitequi. Any ideas whats wrong? enter image description here

marked as duplicate by AndreJ, PolyGeo, BradHards, Fezter, user2856 Mar 17 '14 at 10:38

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


I can confirm this bug. Opening the layers with Add Vector layerstill works (at least in QGIS 2.0).

This might be an issue with sqlite versions mismatch. The database is 2 years old, and spatialite is in a process of heavy development.

It might be worth a bug report, but I don't know who can resolve this: QGIS/Spatialite/NaturalEarth?

The answer to this question gives some more explanation and workarounds:

How do I use the Natural Earth SQLite DB with QGIS?

  • thanks for explaining this. Add Vector layer under qgis 2.2 does not work for me.. – Kurt Mar 18 '14 at 14:30
  • Why not? You have to select one of the available layers, then hit OK. – AndreJ Mar 18 '14 at 15:44
  • oh, you are right, it works . ( I tried to use add vector layer and selected database instead of file). – Kurt Mar 18 '14 at 17:00

Not the answer you're looking for? Browse other questions tagged or ask your own question.