Cannot find SQLite3.exe

[GoofyGremlin]

I am trying to write a program to log data into an SQL database. The program as I have it now is just to test that the process is working, but everytime I run it I get an @error = 2, i.e. SQLite.exe cannot be found. Here is the code as i have it:

expandcollapse popup

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

Dim $dataBase = FileGetShortName("C:\Documents and Settings\Owner\My Documents\script\TimBot\cardList")
Dim $sqlPath = FileGetShortName("C:\Program Files\AutoIt3\Extras\SQLite")
 
Dim $sOutput

_SQLite_Startup ()

If @error > 0 Then
    MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!")
    Exit - 1
EndIf


_SQLite_Open ($dataBase); Open a :memory: database

If @error > 0 Then
    MsgBox(16, "SQLite Error", "Can't Load Database!")
    Exit - 1
EndIf

Dim $createtbl = "CREATE TABLE cardList(one text, two text, three numeric, four numeric, five numeric, six numeric);" & @CRLF
Dim $sInput = "INSERT INTO " & $dataBase & ".cardList" & " VALUES (Tim, TimsSet, 5, 7, 1, 2);" & @CRLF

_SQLite_SQLiteExe ($dataBase, $createtbl, $sOutput, $sqlPath = "SQLite.exe")
_SQLite_SQLiteExe ($dataBase, $sInput, $sOutput, $sqlPath = "SQLite.exe")



If @error > 0 Then
    MsgBox(16, "Error", @error)
    Exit - 1
EndIf

_SQLite_Close ()
_SQLite_Shutdown ()

[Blue_Drache]

AutoIt\Extras\SQLite

It's called "squlite3.exe"

[GEOSoft]

AutoIt\Extras\SQLite

It's called "squlite3.exe"

Hmmm. Still says sglite.exe on mine.

[GoofyGremlin]

Hmmm. Still says sglite.exe on mine.

with these changes

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

_SQLite_Startup ()

If @error > 0 Then
    MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!")
    Exit - 1
EndIf

Dim $dataBase = FileGetShortName("C:\Documents and Settings\Owner\My Documents\script\TimBot\cardList")
_SQLite_Open ( $dataBase= ":memory:"); Open a :memory: database

If @error > 0 Then
    MsgBox(16, "SQLite Error", "Can't Load Database!")
    Exit - 1
EndIf

Dim $sqlPath = FileGetShortName("C:\Program Files\AutoIt3\Extras\SQLite\sqlite3.exe")
Dim $sOutput
Dim $createtbl = "CREATE TABLE cardList(one text, two text, three numeric, four numeric, five numeric, six numeric);" & @CRLF
Dim $sInput = "INSERT INTO " & "cardList" & " VALUES (Tim, TimsSet, 5, 7, 1, 2);" & @CRLF


_SQLite_SQLiteExe ($dataBase, $createtbl, $sOutput, $sqlPath)
_SQLite_SQLiteExe ($dataBase, $sInput, $sOutput, $sqlPath)


If @error > 0 Then
    MsgBox(16, "Error", @error)
    Exit - 1
EndIf

_SQLite_Close ()
_SQLite_Shutdown ()

I am now getting an @error=3. Don't know what is wrong with my SQL, seems pretty simple.