Hello,
I have the following extensions installed:
However when i try to use sqlalchemy i get the the error message:
: DLL load failed while importing _sqlite3: The specified procedure could not be found. (or '_sqlite3.*' is unknown)I am using:
Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-GB (en_US); UI: en-US
Calc: CL threaded
so, not a LO issue … 
Well, I did install the sqlite3 extension, but no sqlite3 to be found. I know the extension is not LO, but still.
more precisely sqlalchemy is not LO !?
not sure what your expectations are here …
SQLite ODBC Driver works for me on Linux.
I install the package, register the driver and various SQLite-DBs. The databases are accessible via File>New>Database… Connect to existing DB, type “ODBC”.
sqlite3 is part of any regular python-installation, so its clearly a LO-issue!
says who ?
and who says sqlalchemy would share the same python install ?
sqlite3 != sqlalchemy
and OP says ?
the OP doesn’t seem to have a clue like you?
oldies but clearly descriptive :
https://stackoverflow.com/questions/24410124/does-python-sqlite3-library-need-sqlite-to-be-installed
Gee thanks for the good words. I have been on this forum for a while and appreciate all the help. So if this can be resolved I would appreciate it.
I installed LO for windows without a problem. I always thought sqlite3 was part of python (python!=LO). I even installed the sqlite3 extension. I recently installed psndas and sqlalchemy. So presumably this should work. If you guys have any ideas I would appreciate.
Thanks for your help.
I’m not sure here. LO had never a “regular” install of python in Windows. We see recently “python with pip” and in Linux we had use of systems python, but without checking a current install I won’t expect to much… Compare:
.
I think the installed extension is providing a jdbc-driver to an embedded sqlite-database, but obviously not the expected hook for sqlalchemy. No, that seems to be another extension by prrvchr .
But still: the extension may not put a “standard python sqlite module” in pythonpath and then it will not be found.
Thank you.