Greetings.
Installing MSYS2 and opening an UCRT64 terminal, I can do this:
$ python3
Python 3.12.9 (main, Feb 6 2025, 14:33:31) [GCC UCRT 14.2.0 64 bit (AMD64)]
on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>>
But, if I build SQLite3 on that same machine, after I run,
$ ./configure --prefix=/ucrt64 $$ make install
Doing the same as above,
$ python3
Python 3.12.7 (main, Nov 22 2024, 20:28:41) [GCC UCRT 14.2.0 64 bit (AMD64)]
on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:/msys64/ucrt64/lib/python3.12/sqlite3/__init__.py", line 57, in
<module>
from sqlite3.dbapi2 import *
File "C:/msys64/ucrt64/lib/python3.12/sqlite3/dbapi2.py", line 27, in <module>
from _sqlite3 import *
ImportError: DLL load failed while importing _sqlite3: The specified procedure
could not be found.
>>>
How can I get it back to be able to run the sqlite3 library?
When I do:
$ ntldd `find /ucrt64/lib/python3.12/ -name '_sqlite3*'` | grep sqlite
libsqlite3-0.dll => C:\msys64\ucrt64\bin\libsqlite3-0.dll
(0x000001cf3a960000)
It's pointing to the correct DLL, but because it was sqlite v3.47.2, I think it
has broken some specific pointer. Any help would be greatly appreciated. Thanks.
Internal Use
==============================================================
Please consider the environment before printing this email.
If you have received this message in error, please notify the sender and
immediately delete this message and any attachment hereto and/or copy hereof,
as such message contains confidential information intended solely for the
individual or entity to whom it is addressed. The use or disclosure of such
information to third parties is prohibited by law and may give rise to civil or
criminal liability.
The views presented in this message are solely those of the author(s) and do
not necessarily represent the opinion of Avangrid Networks, Inc. or any company
of its group. Neither Avangrid Networks, Inc. nor any company of its group
guarantees the integrity, security or proper receipt of this message. Likewise,
neither Avangrid Networks, Inc. nor any company of its group accepts any
liability whatsoever for any possible damages arising from, or in connection
with, data interception, software viruses or manipulation by third parties.
==============================================================
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
https://mail.python.org/mailman/listinfo/db-sig
