Jump to content
Sign in to follow this  
thegoodguy

Sqlite Beginner

Recommended Posts

thegoodguy

HI there,

I want perform various analyses on my Firefox downloads. I hunted for where I could find all the data and found that Firefox stores it in a database (downloads.sqlite).

I am fairly new to Autoit and totally new to Sqlite.

I read a little about sqlite, I opened the example script on the "_SQLite_Startup" Autoit help file page and ran it. I get the error "SQLite3.dll Can't be Loaded!". I am guessing I don't have some files that I should have, but I can't figure out what's missing.

I have installed the lastest version of Autoit and downloaded SQLite.dll.au3 and SQLite3.dll from http://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/.

If someone can get me pointed in the right direction it'd be much appreciated.

Many thanks.

Share this post


Link to post
Share on other sites
kylomas

thegoodguy,

SQLite attempts to find sqlite3.dll in the following directories:

@scriptdir

@windowsdir

@systemdir

@workingdir

Copy the dll to one of them and the example should work.

You can see what each of these values are on your machine with the following code

consolewrite(@scriptdir & @lf & @windowsdir & @lf & @systemdir & @lf & @workingdir & @lf)

kylomas


Forum Rules         Procedure for posting code

"I like pigs.  Dogs look up to us.  Cats look down on us.  Pigs treat us as equals."

- Sir Winston Churchill

Share this post


Link to post
Share on other sites
thegoodguy

Thanks kylomas.

Now on to the next hurdle ...

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
Sign in to follow this  

×