Resolved--_SQLite_Open assistance

[Wena]

Hi

I have copied some code from my old Win 7 laptop to my new Win 7 laptop.(Attached).

This code works perfectly on my old laptop.

The only real difference is I have the latest version of autoit on my new lap top.

It fails at _SQLite_Open.

Could some point me in the correct direction please.

Here is a snippet

_SQLite_Open("c:\a\caz.db");;;FAILS HERE
If @error Then
     MsgBox(16, "SQLite Error", "Can't create a memory Database!" & @error);;;;FAILS HERE
     Exit -1
EndIf
_SQLite_Close()

Regards

Wena

CarynSearch.au3

Edited June 25, 2012 by Wena

[jchd]

When invoking _SQLite_Startup, you provide the path to the command-line tool (SQLite3.exe) instead of the one to sqlite3.dll

[Wena]

Hi Jchd

Thanks for the reply.

I added the the path --- $sSQliteDll = _SQLite_Startup(@SystemDir & "SQlite3.dll").

It is still failing.

I have checked in system32 and the file does exist.

Unless I am reading the help file incorrectly it is supposed to create a temp dll when using the SQLite include files.

I have also tried #Require Admin.

Wena

EDIT

I have resolved this for now.

I had SQLClose on the wrong side off my endif.

@jchd Thanks your advise worked.

Edited June 25, 2012 by Wena

[BrewManNH]

Are you on a 64 bit version of Win7? Is the script being run as 32 or 64 bit? Is the sqlite.dll a 64 or 32 bit dll and what is its name?

[Wena]

Hi BrewManNH

Thanks for the reply.

I have , however, resolved this.

Thanks

Wena