As discussed with @MarlonAmaya in Load ST_GEOMETRY .dll extension into SQLite/mobile geodatabase:
The Load ST_Geometry to a mobile geodatabase for SQL access docs say:
Load the ST_Geometry library.
This example loads the ST_Geometry library to an SQLite database on a Microsoft Windows computer:
SELECT load_extension('stgeometry_sqlite.dll','SDE_SQL_funcs_init');
The file path in that example doesn't include the full path. I found that misleading; I believe the full path is needed.
In my case, I downloaded the .DLL to a folder on my C drive called "SQLite": C:\SQLite\Windows64\. So I had to include that full path:
SELECT load_extension('C:\SQLite\Windows64\stgeometry_sqlite.dll','SDE_SQL_funcs_init');Once I used the full path, I was able to load the .DLL as expected.
If what I've said is accurate, could the docs be changed so that it's clear the full path is needed? That would help avoid confusion for people in the future.
Thanks.