Hi Noli, On Sun, 29. Aug 2010 at 12:00:15 +1000, Noli Sicad wrote: > I still have problem opening spatialite database / files in trunk > version - Quantum GIS - 1.6.0-Trunk 'Trunk' (14162M).
Ok, let me repeat our earlier findings (with some additional info). Creating and using SpatiaLite databases via the SpatiaLite provider (New SpatiaLite Layer/Add SpatiaLite Layer) should work with any QGIS. But to create SpatiaLite databases using the QgsVectorFileWriter class (Save As) or use them via the OGR provider (Add Vector Layer) requires a QGIS linked to GDAL 1.7 that in turn is linked with SpatiaLite 2.4. The only public available Linux build I know that has that is the ubuntugis build of QGIS 1.5 - because ubuntugis' GDAL 1.7 has SpatiaLite support. The nightly debian builds are built against the GDAL the respective distribution has. Which is commonly earlier than GDAL 1.7 and therefore doesn't include SpatiaLite support. So unless you install a GDAL 1.7 from ubuntugis (or Debian experimental) and use a QGIS build against it (QGIS 1.5 from ubuntugis or your own build), you won't have SpatiaLite support in "Save As" and the OGR provider. SQLite support is probably there, but that's different from SpatiaLite. Which version of SpatiaLite is in use in the SpatiaLite provider is determined by whether or not the build is using the system's SpatiaLite or the qgis' internal SpatiaLite. The nightly trunk builds for Debian Squeeze and unstable and Ubuntu Lucid and Maverick use the system's SpatiaLite, all others (read Debian Lenny) use internal SpatiaLite, which currently is 2.4.0. When unstable and Maverick contain GDAL 1.7 the nightly builds with pick it up automatically. So eventually the "problem" with the nightly builds will solve itself. > Anybody using Ubuntu 10.04 and can open spatialite database and what > versions of QGIS, spatialite, ogr2org, etc. The tool is called ogr2ogr. But you could even have multiple libaries and therefore have a GDAL 1.7 ogr2ogr (from gdal-bin), but a QGIS that still uses an earlier GDAL. The version of GDAL your OGR provider is using is shown by ldd /usr/lib/qgis/plugins/libogrprovider.so | grep gdal And the version of system SpatiaLite, if any, the SpatiaLite provider uses is shown by ldd /usr/lib/qgis/plugins/libspatialiteprovider.so | grep spatialite You can also check the about box to see the versions QGIS was built with (which still might not necessarily be the currently installed and running versions). Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-20 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
