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 <[email protected]>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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > -- Giuseppe Sucameli
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
