it is possible to create protected sqlite databases with an alternative dll. Since it is is public domain also and the only changes are made to pager.c and adding crypt.c it should be includeable in the bcc55 build, i do not have the knowledge to do so. Lesnes, if you read this i hope you are able to integerate this in your obj build. I wil continue getting things to compile also but to no avail as of yet. 3das.noeska.com - 3D Adventure Studio
Geregistreerd: wo jan 25 2006, 04:34 Woonplaats: groningen (NL) berichten: 1561
I don't get it. I only need the appropiate sqlite.dll containing the encrypion code. This dll works with the patch you made I asume. I have checked out sourceforge, but the source package only contains a design.dll and a load of c++ / c# stuff. Then there is a msi download I cannot use since I don't want to install this on my engines due to the fact that we won't be using it. So how do I get this dll? I cannot build it.
LesNes is responsible for the obj files for the static Delphi package, but I don't want to maintain different sources. So I'll be most happy to ask LesNes about it, but before I do that I need to check your patch to the dll which I can obtain somewhere or can't. If I cannot have access to a proper maintainalble dll then there's no point for me to put any effort in it although we could use such functionality. albert
Geregistreerd: do mei 25 2006, 10:41 Woonplaats: Gorredijk (NL) berichten: 11
using the makefiles provide by sasa and modifying sqlite_dll.mak with: adding -DSQLITE_HAS_CODEC to CFLAGS and replacing pager.obj with crypt.obj adding the crypt.c file from the sources provided from: link and using their instuction on modifying pager.c i nearly managed to build the dll using bcc55.
Next i got errors on attach.c on line 138 and pragma.c on line 939
on these lines is the following code: #if SQLITE_HAS_CODEC placing a // before the line and the following #end i managed to get a working dll of 296kb. I replaced the dll in the above download. I could use a neater solution for uncommenting the above lines.
also i could use help building the sqlite obj for delphi usage.
[ Bijgewerkt di mei 30 2006, 01:11 ] 3das.noeska.com - 3D Adventure Studio
Geregistreerd: wo jan 25 2006, 04:34 Woonplaats: groningen (NL) berichten: 1561
I advise you try to get into contact with LesNes. He has all the C++ knowledge. See the separate forum section on the static sqlite components for details. albert
Geregistreerd: wo jan 25 2006, 04:34 Woonplaats: groningen (NL) berichten: 1561
I have already informed him, it's not our policy to exchange email addresses by the forum. I've send your email address to him by private mail. albert albert
Geregistreerd: do mei 25 2006, 10:41 Woonplaats: Gorredijk (NL) berichten: 11
this evening i discovered that in build335.bat after the -I is q:c:\borland\bcc\include removeing the q: i got things to build. Also in sqlite335.c pager.c had to be renamed to crypt.c. Now i have obj ready for including in delphi. But this does not work yet as it is dependen on wincrypt.h and the obj belonging to that is somewhere hidden in an .lib i ques. Is that also where the other obj files come from? I hope lesnes can shine some light on this.
[ Bijgewerkt wo mei 31 2006, 01:16 ] 3das.noeska.com - 3D Adventure Studio
Geregistreerd: vr jan 06 2006, 03:38 berichten: 110
Noeska,
Thank you for reporting a bug in SZSQLiteConv utility, fixed in version 1.0.2.
According to information from link, original crypting abbility is not free of charge and you need to contact author of SQLite for purchasing and full support.
However, the third party SQLite code you use maybe the problem. You may also send me your archive with modified SQLite source and I will try to find where is the problem.
