SQLite + Lazarus

[talesrj]

Hi guys,
I have the same problem, using Lazarus at Windows 7 x64.
I tried all the places for sqlite3.dll (same dir than project, windows, system32, etc), but without sucess. Everytime that I tried to run a SQLite, this error appears:

Project projeto raised exception class 'EInOutError' with message:
Can not load SQLIT client library "sqlite3.dll". Check you installation.

At address 63B1AF

Does anybody can help me?

Thanks!

[exdatis]

Set environment variable(system, advanced settings, environment var, path).

p.s. http://forum.lazarus.freepascal.org/index.php/topic,26148.msg161010.html#msg161010

[avra]

I tried all the places for sqlite3.dll (same dir than project, windows, system32, etc), but without sucess.

Have you tried to put "sqlite3.dll" to "Lazarus.exe" dir?

[marcov]

Yup, sqlite3.dll must be either in a system wide directory or in both the application and ide directories

[talesrj]

Hi,
I made three copies of the sqlite3.dll (windows dir, lazarus folder and project folder) and also I set the lazarus path in the system path, but neither of these actions was successful.
Any idea?
Thanks!

[rvk]

I have the same problem, using Lazarus at Windows 7 x64.
I tried all the places for sqlite3.dll (same dir than project, windows, system32, etc), but without sucess.

Putting sqlite3.dll in the Lazarus-directory and your project directory (where the .exe is) should be sufficient. But you said: system32. You should know that system32 on a 64-bit system is C:\Windows\SysWOW64 and not C:\Windows\system32.

So 32bit dll's go in C:\Windows\SysWOW64 and 64bit dll's go in C:\Windows\system32. (logic, huh )
But as said, you don't need the sqlite3.dll in either of those directories.

What you didn't clarify is you target bitness. Are you compiling to a 32bit program or a 64bit program? If you're compiling to a 64bit program you would also need the 64bit sqlite3.dll (and not the 32bit sqlite3.dll).

[kapibara]

I add my sqlite directory to the system path like this:

From Explorer, right-click "Computer"
Click "Properties"
Click "Advanced System Settings"
Click "Environment Variables"
Under "System Variables", select "Path" and then click the "Edit" button below.

Now, first in the line add:

c:\whatever\sqlite;

Dont forget the SEMICOLON at the end.

And probably you should delete the DLL's you have added to other directories.

[rvk]

SQLite also needs the matching Microsoft Visual C++ Runtime Library to work. I dont remember which one it is though.

Are you sure??? You are talking about "System.Data.SQLite". That's not SQLite itself. System.Data.SQLite is an ADO.NET provider for SQLite.

For SQLite itself refer to: http://www.sqlite.org/

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

and

Self-contained: no external dependencies

So for SQLite itself there is definitely no  Microsoft Visual C++ Runtime Library needed.

[kapibara]

@RVK Sounds reasonable! I just remember having to install that C++ runtime lib everytime I set up a new machine with Lazarus and DB. But it might be that it is Postgres that needs it, and not SQLite.

[Leledumbo]

Hi,
I made three copies of the sqlite3.dll (windows dir, lazarus folder and project folder) and also I set the lazarus path in the system path, but neither of these actions was successful.
Any idea?
Thanks!

check the bitness between lazarus and the dll, they cannot be mixed.