SQLite3-x64.dll problem startup not loading

[faustf]

hi guy  i have  a  win 7 64 bit and   i wanna load  a SQLite3-x64.dll   i  modify the  little script  for control  if my autoit  work good  

; SQLite.dll version must match

#include <MsgBoxConstants.au3>
#include <SQLite.au3>
#include <SQLite.dll.au3>
#AutoIt3Wrapper_UseX64=Y
Local $sSQliteDll = _SQLite_Startup();('sqlite3-x64.dll')

If @error Then
    MsgBox($MB_SYSTEMMODAL, "SQLite Error",@ScriptDir& "\SQLite3-64\SQLite3-x64.dll Can't be Loaded!" & @CRLF & @CRLF & _
            "Not FOUND in @SystemDir, @WindowsDir, @ScriptDir, @WorkingDir, @LocalAppDataDir\AutoIt v3\SQLite")
    Exit -1
EndIf

MsgBox($MB_SYSTEMMODAL, "SQLite3.dll Loaded", $sSQliteDll & " (" & _SQLite_LibVersion() & ")")
ConsoleWrite("_SQLite_LibVersion=" & _SQLite_LibVersion() & @CRLF)
_SQLite_Shutdown()

but  not  go i try to put  in script  dir  and  also in system 

if  i remove #AutoIt3Wrapper_UseX64=Y  and  rename  sqlite3.dll work ,  but in this mode  not  work in 64  bit  my script ,  someone  have   idea???   thankz 

[guinness]

...and the Forum search you made came up with zero hits?

[faustf]

yes  , you can suggest me  some  page? 

 

[faustf]

i looked  all page in forum  for  sqlite 64 bit  but nothing  ,  when  try  to use  64 bit  autoit  and  64 bit dll sqlite  ,  not  go give me error

[faustf]

i tryed  to look  also  in this  but  nothing   https://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/

[faustf]

hi guy

 

i  try  to  use sqlite 3 x 64 .dll   in  64 bit system  with autoit  64 bit ,  but  have   problem  dont  work , i read  in forum , but  nothing .  

exist a  tutorial  for  step by step  for   use  sqlite3 x 64.dll ?? in autoit ? 

someone  can help me ??  thankz 

 

[Melba23]

faustf,

Please stick to just the one thread at a time - threads merged.

M23

[Skysnake]

Check your anti virus / browser popups and Windows Security

What may be happening is that AutoIt TRIES to download the .dll, but the actual download is blocked, or deleted, before it can be used locally.

 

 

[faustf]

sorry Melba 

i work in  virtual machine  and  use  microsoft security essential , not pop up nothing but i just  download  a sqlite 64 bit  , by   official site  sqlite 

and  in 

_SQLite_Startup

 i  also insert a path  but nothing 

 

[faustf]

i try to use  also  odbc  connector  for sqlite  

http://www.ch-werner.de/sqliteodbc/

i  used   64bit version  ,  i think i  have  corrected  string  for connect  but  not  connect :(((

this is  my script  with odbc 

; SQLite.dll version must match

#include <MsgBoxConstants.au3>
#include <SQLite.au3>
#include <SQLite.dll.au3>
#AutoIt3Wrapper_UseX64=Y
#RequireAdmin
Global $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")

    $objConn = ObjCreate("ADODB.Connection")
    $objConn.Open('Dsn=SQLite ODBC Driver;database=C:\Users\utente\Documents\CONNECTOR ODOO PRESTASHOP\autoit\test.sqlite3 ')

    If @error Then
        MsgBox(16, "Errore", "Error Opening Connection")
    Else
        MsgBox (0,'','de')
    EndIf



Func _ErrFunc($oError)
    ; Do anything here.
    ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
            @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
            @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
            @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
            @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc   ;==>_ErrFunc

some one  have  idea ??  thankz  at all

[faustf]

i  have  a question  i look the  udf  in include  Sqlite.au3   i see  this  part of  code 

If $bDownloadDLL Then
            If Not FileExists($sDll_Dirname & $sDll_Filename) Then
                ; Create in @LocalAppDataDir & "\AutoIt v3\" to avoid reloading (only valid for the current user)
                $sDll_Dirname = @LocalAppDataDir & "\AutoIt v3\SQLite"
            EndIf

i look in my  C:\Users\utente\AppData\Local\AutoIt v3   but not  have  the  folder SQLite 

i must create and  put the dll inside??? 

thankz 

[jchd]

The availability of the various SQLite DLLs for download has been suspended by Jon few months ago due to excessive load on AutoIt server.

[faustf]

and  then  i dont  can use a  sqlite 64bit  version??? 

understund  right? 

 

[jchd]

Of course you can. I use this for both x86 and x64, given that the x86 DLL is c:\bin\sqlite3.dll and that for x64 the DLL is c:\bin\sqlite3_x64.dll

Local $dll = _SQLite_Startup("c:\bin\sqlite3.dll")

Adjust the base directory to your needs.