faustf

SQLite3-x64.dll problem startup not loading

14 posts in this topic

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??? :D  thankz 

Share this post


Link to post
Share on other sites



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


_AdapterConnections()_AlwaysRun()_AppMon()_AppMonEx()_BinaryBin()_CheckMsgBox()_CmdLineRaw()_ContextMenu()_ConvertLHWebColor()/_ConvertSHWebColor()_DesktopDimensions()_DisplayPassword()_DotNet_Load()/_DotNet_Unload()_Fibonacci()_FileCompare()_FileCompareContents()_FileNameByHandle()_FilePrefix/SRE()_FindInFile()_GetBackgroundColor()/_SetBackgroundColor()_GetConrolID()_GetCtrlClass()_GetDirectoryFormat()_GetDriveMediaType()_GetFilename()/_GetFilenameExt()_GetHardwareID()_GetIP()_GetIP_Country()_GetOSLanguage()_GetSavedSource()_GetStringSize()_GetSystemPaths()_GetURLImage()_GIFImage()_GoogleWeather()_GUICtrlCreateGroup()_GUICtrlListBox_CreateArray()_GUICtrlListView_CreateArray()_GUICtrlListView_SaveCSV()_GUICtrlListView_SaveHTML()_GUICtrlListView_SaveTxt()_GUICtrlListView_SaveXML()_GUICtrlMenu_Recent()_GUICtrlMenu_SetItemImage()_GUICtrlTreeView_CreateArray()_GUIDisable()_GUIImageList_SetIconFromHandle()_GUIRegisterMsg()_GUISetIcon()_Icon_Clear()/_Icon_Set()_IdleTime()_InetGet()_InetGetGUI()_InetGetProgress()_IPDetails()_IsFileOlder()_IsGUID()_IsHex()_IsPalindrome()_IsRegKey()_IsStringRegExp()_IsSystemDrive()_IsUPX()_IsValidType()_IsWebColor()_Language()_Log()_MicrosoftInternetConnectivity()_MSDNDataType()_PathFull/GetRelative/Split()_PathSplitEx()_PrintFromArray()_ProgressSetMarquee()_ReDim()_RockPaperScissors()/_RockPaperScissorsLizardSpock()_ScrollingCredits_SelfDelete()_SelfRename()_SelfUpdate()_SendTo()_ShellAll()_ShellFile()_ShellFolder()_SingletonHWID()_SingletonPID()_Startup()_StringCompact()_StringIsValid()_StringRegExpMetaCharacters()_StringReplaceWholeWord()_StringStripChars()_Temperature()_TrialPeriod()_UKToUSDate()/_USToUKDate()_WinAPI_Create_CTL_CODE()_WinAPI_CreateGUID()_WMIDateStringToDate()/_DateToWMIDateString()Au3 script parsingAutoIt SearchAutoIt3 PortableAutoIt3WrapperToPragmaAutoItWinGetTitle()/AutoItWinSetTitle()CodingDirToHTML5FileInstallrFileReadLastChars()GeoIP databaseGUI - Only Close ButtonGUI ExamplesGUICtrlDeleteImage()GUICtrlGetBkColor()GUICtrlGetStyle()GUIEventsGUIGetBkColor()Int_Parse() & Int_TryParse()IsISBN()LockFile()Mapping CtrlIDsOOP in AutoItParseHeadersToSciTE()PasswordValidPasteBinPosts Per DayPreExpandProtect GlobalsQueue()Resource UpdateResourcesExSciTE JumpSettings INISHELLHOOKShunting-YardSignature CreatorStack()Stopwatch()StringAddLF()/StringStripLF()StringEOLToCRLF()VSCROLLWM_COPYDATAMore Examples...

Updated: 04/09/2015

Share this post


Link to post
Share on other sites

yes  , you can suggest me  some  page? 

 

Share this post


Link to post
Share on other sites

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 :(

Share this post


Link to post
Share on other sites

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 

 

Share this post


Link to post
Share on other sites

faustf,

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

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

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.

 

 


Skysnake

Why is the snake in the sky?

Share this post


Link to post
Share on other sites

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 

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 

Share this post


Link to post
Share on other sites

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


This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites

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

understund  right? 

 

Share this post


Link to post
Share on other sites

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.


This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now