SQLite3.dll can't be loaded

[TDCSoftware]

Hi,

   I'm completely new to AutoIt so, please, forgive me for my questions. I'm trying to run the _SQLIte_Open example, quite simple, but I only get the message of the title. SQLIte3.dll is in the same folder of my script so I have no idea what's wrong in the code. 

  Any help would be appreciated. 

 

Mauricio

[TheXman]

If you are using a 64-bit Windows OS, then the most likely cause is that the script can't find sqlite3_x64.dll.  By default, _SQLite_Startup() will look for sqlite3.dll when the script is being run using the 32-bit AutoIt interpreter and sqlite3_x64.dll when using the 64-bit AutoIt interpreter.  Try putting the sqlite3_x64.dll file in the script's folder and see if i works.

[water]

Starting with AutoIt 3.3.14.2:

_SQLite_Startup() no longer automatically downloads DLL files.

With the latest beta 3.3.15.1 a download script has been added:

Extras\AutoUpdateIt\AutoSQLiteUpdateIt.au3 script to download sqlite dll's used by _SQLite_Startup().

[TDCSoftware]

There is no a sqlite3_x64.dll. If you go to SQLite Download and look for Precompiled binaries for Windows 64, it will download a zip that only contains a sqlite3.dll and a sqlite3.def. I'm working in a W10 64 bits computer.

[benners]

The sqlite links are here

 

[Gianni]

3 hours ago, TDCSoftware said:

There is no a sqlite3_x64.dll. If you go to SQLite Download and look for Precompiled binaries for Windows 64, it will download a zip that only contains a sqlite3.dll and a sqlite3.def. I'm working in a W10 64 bits computer.

save it to your script directory and then just rename it to  sqlite3_x64.dll (or whatever else fits your needs)
then you can use the following command to force the SQLite engine (that is in that dll file) to be  startup  from that location:

_SQLite_Startup(@ScriptDir & "\sqlite3_x64.dll", False, True)

P.S.

Warning; using the above command you can force the execution of a 64 bit dll on a 32 bit AutoIt and that is not a good idea....

as @TheXman already pointed out, you have to use a 32bit or 64bit version of the SQLite dll according to what AutoIt version you are using (and not on what Windows version you are) i.e you can use a 32 bit AutoIt version even if we are running on a 64 bit Win10

so, use either 32 or 64 dll version that fits (matches) to the AutoIt version (and not to the Win version)

Edited December 8, 2020 by Chimp

[Skysnake]

If it means anything, I have found that standardizing all on 32bit solves lots of problems. Many tools are not 64 bit ready

[Zedna]

There is AutoIt3Wrapper directive to force 32bit AutoIt compilation even on 64bit Windows,

so put this at top of your script and compile script from full Scite4AutoIt3 (where is AutoIt3Wrapper included):

 

older AutoIt versions:

#AutoIt3Wrapper_UseX64=n

latest AutoIt version (direct pragma directive of Aut2Exe):

#pragma compile(x64, false)