Solution to sqlite startup error (2023 win11) _SQLite_ Startup

[YGYL0]

Machine translation
I am on the Win11 system and when i using autoit SQLite udf, report errors: _SQLite_Startup error [SQLite Error SQLite.dll Can't be Loaded!], my version is 3.3.16.0
For example, running the f1 help document _SQLite_GetTable2D Example will report an error

I took a brief look at the process, and there are basically several reasons for this:

1.The most critical issue is the issue with the official UDF SQLite.au3
In SQLite.au3  _SQLite_Startup() The third parameter of the Startup() function, iForceLocal, forces the use of the local DLL. When iForceLocal is 0, it will be downloaded from the official AU3 and the official DLL will be used
IForceLocal defaults to 0 and can be downloaded from the official website without specifying it, but this feature seems to be disabled,  __SQLite_Inline_Version in __SQLite_GetDownloadedPath is actually no longer available.

2. Of course, we have a way to manually download it, https://www.autoitscript.com/autoit3/pkgmgr/sqlite/
Manually download sqlite3.dll, sqlite3.exe, sqlite3_x64.dll, update.dat in C:\Users\admin...\AppData\Local\AutoIt v3\SQLite solve the problem? The answer is no~~
Firstly, pkgmgr/sqlite did not update the corresponding version files in a timely manner
The program will search for file names online, such as sqlite3_302800000.dll, display does not match~
So to disable the online download function, set the third parameter to 1, and then place the file in your program directory, which is more stable

3. Then you may find that there is still an error, and the root cause is whether the system is 64 bit and whether autoit is running in x64 mode by default
Generally speaking, when installing autoit, the installation program is recommended for x32 installation, so even if you use a 64-bit DLL and autoit runs according to 32-bit, an error will still be reported
#AutoIt3Wrapper_ UseX64=n This is not a random addition, sometimes we have to=y instead
When autoit runs at 64 bit_ SQLite_ Startup will add_ X64 suffix, if the file name is not_ X64 doesn't work either

Of course, we can also go to the latest version in 2023 on the official website of SQLite, corresponding to SQLite version 3.41.2
https://www.sqlite.org/download.html
So here we need to pay special attention to x64 and x32, as well as their suffix issues. Of course, putting them together is also a good idea.