Loading SQLite extension [SQLITE_ERROR] SQL error or missing database (The specified module could not be found. )

I'm trying to load the spatialite extension for SQLite.

The module is on the PATH but rider can't find it / won't load it.

SELECT load_extension('mod_spatialite.dll'); -> [1] [SQLITE_ERROR] SQL error or missing database (The specified module could not be found. )

I've tried to add it to the startup script as well as from the console.

My unit tests can load the extension and interact with the db but now I would like to use riders smart sql features for further development.

Any trouble shooting ideas?

Thanks in advance.

 

1 comment
Comment actions Permalink

Update: Seems that the unit tests stopped working too on this PC, same error. This is probably not a rider issue but my config issue.

Which is strange considering I can load the extension on the terminal just fine.

0

Please sign in to leave a comment.