I have developed an application in Python on linux that uses the mod_spatialite extension for sqlite. Up until now, I have had no problems loading the extension using SELECT load_extension('/path/to/mod_spatialite'); in sqlite3.
One of my clients wishes to use the application on Windows, so I have been trying to test the system on a Windows 10 machine. Unfortunately, I am having issues using load_extension() in windows. I have successfully tested mod_spatialite by running the standalone sqlite3.exe in the same directory containing the .dlls and using SELECT load_extension('mod_spatialite'); , so I know that works.
The problem is, when I try to load_extension() in Windows using the full path to mod_spatialite (e.g., select load_extension('C:\path\to\mod_spatialite'); , I get an error
Any suggestions would be appreciated!
أكثر...
One of my clients wishes to use the application on Windows, so I have been trying to test the system on a Windows 10 machine. Unfortunately, I am having issues using load_extension() in windows. I have successfully tested mod_spatialite by running the standalone sqlite3.exe in the same directory containing the .dlls and using SELECT load_extension('mod_spatialite'); , so I know that works.
The problem is, when I try to load_extension() in Windows using the full path to mod_spatialite (e.g., select load_extension('C:\path\to\mod_spatialite'); , I get an error
%1 is not a valid Win32 application
I have tried using the 32 and 64 bit versions of mod_spatialite. I have also tried adding the mod_spatialite .dlls to the C:\Windows\System32 folder, which has been suggested by others. The problem I describe above occurs when using the standalone sqlite3.exe in a folder not containing the .dlls and when using the sqlite3 module in Python.
Any suggestions would be appreciated!
أكثر...