SQLite db support in Windows 10

[dinodod]

So I installed Autoit v3 onto my windows 10 OS and fired up a simple script to connect to a sqlite DB file.  But the script failed to execute because it couldn't find sqlite3.dll in any of the paths.  I manually copied the file into several of the paths and still it can't access it or it's incompatible,

Is there a solution for this?

The error is:

SQLite3.dll can't be loaded!

Not found in <Path>

 

Thanks!

 

[BrewManNH]

What paths are you installing to? What version of SQLite are you using (x86 or x64)? Are you running AutoIt in the same architecture as the dll?

[dinodod]

Windows 10 x64

Interesting.  I went back to sqlite and downloaded their latest package (http://www.sqlite.org/2016/sqlite-dll-win32-x86-3110100.zip) and this works.  The x64 package errored on me.  Maybe I need to somehow declare my script to be x64???  I don't remember.

I was using sqlite-dll-win32-x86-3071501.zip. and this did not work for me.  But the latest version seems to be working.  

Am I missing anything?

 

Looking inside the sqlite.au3 file, I'm not seeing anything specific on what version sqlite I need.  I do see how they support x64 automatically
 

Local $sDll_Dirname = ""
    If $sDll_Filename = "" Then $sDll_Filename = "sqlite3.dll"
    If @AutoItX64 And (StringInStr($sDll_Filename, "_x64") = 0) Then $sDll_Filename = StringReplace($sDll_Filename, ".dll", "_x64.dll")