can't find sqlite3.dll

[sqlite_user]

I am testing the UNIDAC and DBExpress products, both for SQLite. I want to purchase at least one of them, if I can get them to work. In each case the install seems to be fine, but when I try to run the demos under Delphi RAD Studio XE2, I get a message 'Cannot load client DLL: sqlite3.dll'. I've done a systemwide search and sqlite3.dll isn't anywhere on my box (XP sp3). I've downloaded versions of sqlite3.dll from the sqlite home page, and put them everywhere I can think of - even though I see from the web site that your compile is a wee bit different than theirs I figured I'd at least try. That does not work, same error message. Bottom line, could someone tell me where to obtain the correct sqlite3.dll, and where it should be installed, for both the DBExpress and UNIDAC products? thanks in advance.

[AlexP]

Hello,

You can download the sqlite3.dll library at http://sqlite.org/sqlite-dll-win32-x86-3070800.zip. If the SQLite library is in the ..\Windows\System32 folder, and the Path environment variable contains a path to this folder, UniDAC and dbExpress driver for SQLite will load this library automatically. Besides, you can specify a path to this library yourself:

in UniDAC
UniConnection.SpecificOptions.Values['ClientLibrary'] := 'Path to sqlite3.dll';

in dbExpress

SQLConnection.LibraryName := 'Path to sqlite3.dll';