On Jan 25, 2009, at 7:00 PM, RB Smissaert wrote: > For some reason this mail went to the junk mail folder. > That sounds good and I would be happy to buy this, but I am not sure > about: >> All you need to do is replace the DLL > I have number of dll's: > For the desktop: an ActiveX dll and a plain Windows dll. The ActiveX > is used > by my VBA/VB6 app and that ActiveX uses the plain Windows dll. These > files > are compiled by Olaf Schmidt. > On the WM6 device: A .net dll System.Data.SQLite.DLL and a little > Basic4PPC > dll, SQLDevice.dll, which I think is also a .net dll. These files are > compiled by Erel, the author of Basic4PPC. > How would SEE fit in with all this?
If you have an SQLite.dll which is just a version of SQLite compiled for your platform, then you could just replace that one DLL with an SEE-enabled version of SQLite and you would be done. The question is, do these other DLLs contain only SQLite, or other stuff too? If they contain other stuff, then you will have to get the ability to recompile them in order to make use of SEE. > > > RBS > > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp > Sent: 25 January 2009 19:40 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Lock SQLite file by overwriting bytes and then > un-lock? > > > On Jan 25, 2009, at 2:32 PM, RB Smissaert wrote: > >> Yes, you are right there. It won't be much good for anything else >> then a >> casual peek at the device. This is a clinical database, so it >> involves >> patients, diagnoses, medications etc. The ID data and the clinical >> data are >> stored in different tables, but even then with a simple hex editor >> it won't >> be that difficult to match the 2 up. >> So, I suppose the only solution is to encrypt the data. Problem is >> that the >> SQLite on the device can't decrypt and even if it could it would be a >> different system than the one used on the desktop. The DB file is >> made on >> the desktop and then copied to the device and on the desktop I use >> Olaf >> Schmidt's VB wrapper dhRichClient and SQLite 3.6.1. The device app is >> developed with Basic4PPC and that is based on .Net and uses SQLite >> 3.3.12. >> Not sure there is an easy solution there without affecting the speed >> of the >> application. > > > http://www.hwaci.com/sw/sqlite/see.html is often used to meet HIPAA > requirements. SEE supports cross-platform databases. The key can be > entered using PRAGMAs so no new interfaces are needed in your > wrapper. All you need to do is replace the DLL. And by purchasing an > SEE license, you get the additional satisfaction of knowing that you > are helping to support the ongoing development and maintenance of > SQLite :-) > > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
