Jump to content
TDCSoftware

SQLite3.dll can't be loaded

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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().


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites
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 by Chimp

small minds discuss people average minds discuss events great minds discuss ideas.... and use AutoIt....

Share this post


Link to post
Share on other sites

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


Skysnake

Why is the snake in the sky?

Share this post


Link to post
Share on other sites

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)

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...