current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite

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

share|improve this question

marked as duplicate by AndreJ, PolyGeo♦, BradHards, Fezter, Luke 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.

1 Answer 1

up vote 2 down vote accepted

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?

share|improve this answer
    
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.