Embeding SQLite3.dll

[BisherSH]

Good day ,

I have the code below , and i would like to embed SQLite3.dll to the compiled file 

Is it possible ? 

Thanks in advance

#include <SQLite.au3>
#include <SQLite.dll.au3>


_SQLite_Startup()

If @error Then
    MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!")
    Exit -1
EndIf

$DB = _SQLite_Open("C:\Temp\Test.db")
$Action = "TestAction"
$Time = @HOUR&":"&@MIN&":"&@SEC
$Date = @YEAR&"-"&@MON&"-"&@MDAY
$User = @UserName
$Computer = @ComputerName
$DC = @LogonServer
If @error Then
    MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Couldnt open Database")
    Exit -1
EndIf
_SQLite_Exec($DB,"INSERT INTO QLogs (Action,Date,Time,User,Computer,DC) " & _
                              "VALUES ("& _SQLite_FastEscape($Action) & "," & _
                                          _SQLite_FastEscape($Date) & "," & _
                                          _SQLite_FastEscape($Time) & "," & _
                                          _SQLite_FastEscape($User) & "," & _
                                          _SQLite_FastEscape($Computer) & "," & _
                                          _SQLite_FastEscape($DC) & ");")

If @error Then
    MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Couldnt insert!")
    Exit -1
EndIf
_SQLite_Shutdown()

[jguinch]

Use FileInstall to embed the dll in your script. This function extracts the file from the compiled script to the directory you specifiy

Edited February 14, 2017 by jguinch

[Starf0x]

Or you can do this:
 

#AutoIt3Wrapper_Res_File_Add=Sqllite.dll, RT_RCDATA, BIN_DLL ; This file is added during compilation.
#include <ResourcesEx.au3>
_Resource_SaveToFile('Sqllite.dll', 'BIN_DLL') ; This must be done at startup

Cheers, Starf0x

[BisherSH]

Thank you for the quick reply , 

It looks very useful , but what i am actually looking for is using the resource DLL file directly from the compiled EXE without saving the DLL to disk .

I found something which looks exactly what i need , and i was able to embed the file but I couldt find the correct way to use it inside my code

 

 

[BisherSH]

I mean I need to use the DLL from memory , I found this link too but I also couldn't find the correct way to user it in my code

 

[junkew]

Depending your target OS maybe not needed.

• SQLite version 3.11.2 is shipping with the Windows 10 Anniversary edition

[UEZ]

Try this: SQLiteMem.au3

Please reply if it works.

Edited February 21, 2017 by UEZ