Loading @SystemDir&"\winsqlite3.dll" with _SQLite_Startup (64bit problem) - (Moved)

[Krakatoa]

winsqlite3.dll is default Windows sqlite dll

32bit _SQLite_Startup(@SystemDir & "\winsqlite3.dll") not problem.

64bit problem, requires _x64.dll

Why can't it be solved somehow by default SQLite.au3?

Example:

SQLite.au3 (add $add_x64):

...

Func _SQLite_Startup($sDll_Filename = "", $bUTF8ErrorMsg = False, $iForceLocal = 0, $hPrintCallback = $__g_hPrintCallback_SQLite, $bAutoItTypeConversion = False, $add_x64 = True)

...

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

...

and 32bit and 64bit not problem:

_SQLite_Startup(@SystemDir & "\winsqlite3.dll", False, 0, $__g_hPrintCallback_SQLite, False, False)

Edited August 4, 2023 by Krakatoa

[Jos]

Moved to the appropriate forum.

Moderation Team

[Krakatoa]

But this is AutoIt Technical Discussion = This is proposal to change the default SQLite.au3 to load winsqlite3.dll

[jchd]

Yes, that part (at least) needs rewrite. Post in the bug tracker to leave a trace.

[Andreik]

Why not applying your logic when the function is called.

_SQLite_Startup(@SystemDir & "\winsqlite3" & (@AutoItX64 ? '_x64' : '') & ".dll", False, 0, $__g_hPrintCallback_SQLite, False, False)

 

[Krakatoa]

3 minutes ago, Andreik said:

Why not applying your logic when the function is called.

_SQLite_Startup(@SystemDir & "\winsqlite3" & (@AutoItX64 ? '_x64' : '') & ".dll", False, 0, $__g_hPrintCallback_SQLite, False, False)

 

I want to use default SQLite.au3 + 64bit autoit script + default Windows c:\Windows\System32\winsqlite3.dll

... but default SQLite.au3 won't let me:

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

I have to use modified SQLite.au3

That's why I wrote here a proposal to override SQLite.au3 to use the default SQLite.au3 to load 64bit winsqlite3.dll

[Andreik]

winsqlite3.dll has the same name for x64? Otherwise it should work fine. I agree though with jchd that this could have been written better.

[Krakatoa]

10 minutes ago, Andreik said:

winsqlite3.dll has the same name for x64? Otherwise it should work fine. I agree though with jchd that this could have been written better.

Yes.

32bit is c:\Windows\SysWOW64\winsqlite3.dll

64bit is c:\Windows\System32\winsqlite3.dll

But default SQLite.au3 64bit winsqlite3.dll can't, only winsqlite3_x64.dll can, but it doesn't exist.

Edited August 4, 2023 by Krakatoa

[Andreik]

I see. You can open a ticket as has been suggested but it might take some time until it will be done.

[jchd]

I recommend against placing user sqlite.dll in system folders, irrespective of 32- or 64-bit.

This is because there are many common programs using their version of SQLite with potentially proprietary-modified DLL. For instance in my humble system:

AutoIt
ActiveTCL
Abobe Acrobat (and many other Adobe prgms)
PCloud file hosting service
Wolfram Mathematica
AOMEI Backuper
Acronis
Various Epson support prgms
Windows Installer
Windows 10 or 11 itself provides its own SQLite DLLs
... and my own SQLite GUI front-ends or my own programs.

Other common programs use SQLite linked in their code, like FireFox, Chome, etc.

SQLite is probably the most common library used worldwide, not counting devices using it internally without saying like smart TVs, routers, GPSs, smartphones, tablets, ...

[argumentum]

..for the size of the DLL and the potential mishaps that can happen, I'd carry/use my own.
Who is to know what happens in a windows update or whatnot.

My 2 cents of fear based freaking out "what did happen" type of thing.

Edited August 4, 2023 by argumentum

[Krakatoa]

winsqlite3.dll not user sqlite dll, but winsqlite3.dll is in Windows by default.

They don't change often.

winsqlite3.dll is not recommendation, but that should be choice if the programmer sees fit.

What is my point? The user should be able to set the sqlite dll name without _x64 in the 64bit script with default SQLite.au3.

 

 

 

 

 

Edited August 4, 2023 by Krakatoa

[Krakatoa]

solution without modifying SQLite.au3

$sSQliteDll = _SQLite_Startup(@SystemDir & "\_x64\..\winsqlite3.dll")