[GIS] Trying to install SpatiaLite 4.3 with SQLite 3.8 on Windows 7

spatialitesqlitewindows 7

I'm new to the open-source GIS database world, and am trying to have SpatiaLite installed on my Windows 7 machine.

I downloaded SQLite 3.8.2 and unpacked the 3 files in a newly created folder c:\Program Files\SQLite. I added the folder to the PATH env variable, and managed to get that going.

To install SpatiaLite, I went to webpage https://www.gaia-gis.it/fossil/libspatialite/index, downloaded libspatialite-4.1.1.zip , which I believe is the latest SpatiaLite version for Windows. I unpacked this zip-file into the aforementioned SQLite folder, and then tried to run .load 'SpatiaLite.dll' from the SQLite prompt. But this gives me an error.

Investigation shows that there is no such thing as 'SpatiaLite.dll', even though I thought I was just following the download and install instructions.

Where am I getting wrong?

Best Answer

If you downloaded libspatialite-4.1.1.zip, you downloaded the source code. That will work, but you'd need to build it first. From your description, I guess that didn't happen.

Instead, you probably want to download packages that are already built. If you have a 32 bit build, use: http://www.gaia-gis.it/gaia-sins/windows-bin-x86/

Related Solutions

[GIS] How to install Spatialite-GIS on Windows

From the Gaia GIS homepage:

Obsolete / Discontinued software [no longer maintained]
...
spatialite-gis  sources     a minimalistic GIS tool built on the top
                            of SpatiaLite and RasterLite

They still offer the sources, but no binaries (as for the gui). So you have to compile it yourself from the sources. The homepage gives some details for various platforms.

Or switch to QGIS, which has much more features. Might be a reason why Gaia does not maintain its old project.

Spatialite ODBC – Loading Spatialite Extension via SQLite3 ODBC Driver

I did the following:

Put the DLLs in a different spot (NOT system32) - in my case c:\spatialite\bin. Note that you need more than just libspatialite - there are supporting DLLs that need to also be there.
Put the entire path in the extension box, not just the name.
Commence with great joy

Oddly enough I had already done the first step - so just adding c:\spatialite\bin to my odbc dll extension is all I needed to do. It's the little things sometimes. I also had already added that location to my PATH environmental variable - but I did a quick test and it doesn't appear to be a requirement.

I'm GUESSING that perhaps it has something to do with it looking in system32 but being a 64bit driver. I'm just guessing on that - I'm still on step #3.

Best Answer

Related Solutions

[GIS] How to install Spatialite-GIS on Windows

Spatialite ODBC – Loading Spatialite Extension via SQLite3 ODBC Driver

Related Question