sqlite.dll sqlite3.dll mystery

[picstart]

The package sqlite3laz0.4 in the do not install view of the package manager has a red x
the package will install and the ide will recompile but it never makes it to the installed packages ...yet the sqlite3 icon makes it to the palettes data access tab. Running code that uses the Tsql3DAtaset that worked under v09.28 fails under v0.9.30  after an error free compile  with a run time message >>>>> program can't start because sqlite.dll is missing.
I have sqlite3.dll in windows>>system32 Running win7pro 32 bit.

I tried sqlitelaz0.4 ... it install but when the IDE comes up it errors with sqlite.dll missing. I can't find a source for sqlite.dll
Packages not installed are sqldblaz  ( probably nothing to do with sqlite )
sqlite3laz0.4 with a red x
sqlitelaz0.4   without a red x
This is likely another unpleasant dependency issue or install order issue that I have no clue how to solve.
Any ideas would be of great help

[Leledumbo]

program can't start because sqlite.dll is missing.
I have sqlite3.dll in windows>>system32

Put it in lazarus dir, perhaps the dll isn't loaded statically.

[TurboRascal]

Why would it complain it cannot find sqlite.dll if you only use sqlite3, which requires sqlite3.dll?

If you don't intend to use old sqlite, don't install the sqlite (without '3') package and uninstall it if installed.

[picstart]

sqlite is not installed and wasn't installed. Sqlite3 won't install either though the icon makes it to the palette ( sqlite3 has a red x in the not yet installed list). Since the sqlite3 component errors at run time with it needs sqlite.dll I naively thought it was a dependency issue so I tried installing sqlite without the 3. sqlite hangs the IDE after the recompile of the IDE asking again for sqlite.dll. I recovered by using lazarus.old.exe Again I have always had copy of sqlite3.dll in windows system32. Having sqlite3.dll in windows system32 worked with the 9.028 version of Lazarus. I'm probably wrong but I suspect the IDE itself is reliant on sqlite so it is built in in 9.30 and wasn't in 9.28. Anyway if anybody has got sqlite to work with 9.30 I can put my suspicion that sqlite3 is broken in 9.30 to oneside. Thanks for the ideas so far.

[christensen]

The same problem  had, After I've install Lazarus 0.9.30.2 and install a few components, i noticed in the list of Install/Uninstall Packages Sqlite and Sqlite3, i wasn't sure about which is which and i've installed both(with no errors) ... after this monumental mistake the IDE wont start, the error was the missing sqlite.dll file. only the sqlite3.dll had found but for sqlite.dll no luck.
Lucky with the lazarus.old.exe i've managed to uninstall the sqlite.

[jmpessoa]

For Windows, this sequence is important:

1) Download "sqlite-dll-win32-x86-3071000"  from http://www.sqlite.org/download.html
Unzip and put "sqlite3.def"  and "sqlite3.dll" on <Windows> directory.

2) From lazarus/components/sqlite install "sqlite3laz.lpk"

[christensen]

i didn't copy "sqlite3.def" to system32 directory only the "sqlite3.dll". Sqlite3 was on the Install/Uninstall Packages list and from there i've install it, at least on Lazarus 0.9.30.2 was in the list, i don't know for other versions if they are available in that list.(at the moment with this fresh install i haven't try the component if it's work properly when i compile a project)

[jmpessoa]

Hi Christensen,  try putting dll  just in <windows> directory !

[BigChimp]

I'd really NOT put stuff into the windows/system32 directory, especially not overwrite dlls...
Recipe for DLL hell...

Instead, you can copy the required dlls (and other files) to your lazarus directory. This will allow design time support.
Then copy the dlls over to the output path of your executable and distribute them along with the executable itself. This way, you don't mess with your users' windows directory either.

Just my 2 cents; if you're fine with copying stuff to your system32 directory, it's certainly a quick way of doing things...

[jmpessoa]

Hi BigChimp, you're right!
My suggestion is to quickly resolve the frustration of a code that does not work! so, just try not only <windows/sistem32> but too just <windows>  directory! In this case it actually should work!

[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!

[Leledumbo]

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!

Check the bitness of your app and the dll, they must be the same