[Qgis-user] Loading SpatiaLite databases

[Giuseppe Sucameli]

Hi Mike,

you have a sqlite db with not spatialite support enabled.
You can load that db by the "Add Vector Layer".

Cheers.

On Sun, Aug 1, 2010 at 12:43 AM, Mike Leahy <mgleahy at alumni.uwaterloo.ca>wrote:

> Hello list,
>
> I'm having trouble opening an spatialite database that I created by
> importing
> a shapefile.  When I try to open the db, I get a message saying:
>
> "Failure while connecting to:
> /path/to/filename.sqlite
>
> seems to be a valid SQLite DB, but not a SpatiaLite's one..."
>
> I've found a couple references to this error in my searches online, but
> nothing conclusive yet.
>
> I created the file by opening the db with 'spatialite
> /path/to/filename.db',
> then used the .loadshp command to import a shapefile into the database.
>  The
> data appear to be fine, and I can query it and the geometries all seem to
> work
> (e.g., "select area(Geometry) from tablename;" produces the expected
> output).
>
> I also have the same problem if I use the OGR conversion utility in QGIS to
> convert a shapefile to SQLite - though I'm guessing in this case it's
> because
> OGR isn't creating an actual SpatiaLite file.
>
> I'm doing this using QGIS 1.5 on 64-bit Ubuntu.  Here's the version
> information from spatialite:
>
> SpatiaLite version ..: 2.4.0    Supported Extensions:
>        - 'VirtualShape'        [direct Shapefile access]
>        - 'VirtualDbf'          [direct DBF access]
>        - 'VirtualText'         [direct CSV/TXT access]
>        - 'VirtualNetwork'      [Dijkstra shortest path]
>        - 'RTree'               [Spatial Index - R*Tree]
>        - 'MbrCache'            [Spatial Index - MBR cache]
>        - 'VirtualFDO'          [FDO-OGR interoperability]
>        - 'SpatiaLite'          [Spatial SQL - OGC]
> PROJ.4 version ......: Rel. 4.7.1, 23 September 2009
> GEOS version ........: 3.2.2-CAPI-1.6.2
> SQLite version ......: 3.6.22
>
> Is there something incompatible here, or am I doing something wrong in the
> creation of the SpatiaLite DB?
>
> Regards,
> Mike
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
Giuseppe Sucameli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20100801/7bce9423/attachment.html>