Problem setting the environment for SQLite database

[FrancescoDiMuro]

Good morning guys
I was trying to use again SQLite in AutoIt, and I've again an issue: I can't startup SQLite...
Can you please show me the way to set the enviornment for a SQLIte usage in AutoIt? Step by step, I'll follow your suggestion(s).

Thanks for everyone will reply!

Francesco

[jchd]

Don't #include <SQLite.Dll.au3> but instead download the SQLite DLL suitable for your architecture and place it simply in the script directory.

Use _SQLite_Startup($path_of_dll)

No environment setup/variable is needed.

[Skysnake]

Try this?_SQLite.7z

[FrancescoDiMuro]

@jchd

Thanks for your reply
I did something like this ( in order to have an application compatible with both x32 and x64 OS Arch... ) :
 

Global $sSQLite_DLL = ""

; Check for Windows Architecture

MsgBox($MB_ICONINFORMATION, "OS Arch:", @OSArch)

If(@OSArch = "X86") Then
    $sSQLite_DLL = @ScriptDir & "\sqlite3_x32.dll"
ElseIf(@OSArch = "X64") Then
    $sSQLite_DLL = @ScriptDir & "\sqlite3_x64.dll"
EndIf
MsgBox($MB_ICONINFORMATION, "DLL to load:", $sSQLite_DLL)

_SQLite_Startup($sSQLite_DLL)
If @error Then
    MsgBox($MB_ICONERROR, "Changes Detector:", "Error during the startup of SQLite." & @CRLF & "Error: " & @error)
    Exit
EndIf

But I've always the error that I can't do the startup.

Any suggestions?

Thanks  

[kylomas]

I think the 32 bit version is just named sqlite3.dll, no bitness ( is that even a word) inducator...

 

[jchd]

Yes, that and always use the dll name w/o "bitness", just _SQLite_Startup("sqlite3.dll"). _SQLite_Startup appends "_X64" to the DLL filename when needed.

This UDF code does this under the hood:

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

You can safely remove your test for architecture and streamline your code.

[Skysnake]

@FrancescoDiMuro did you look at my zip file in post #3?