SQL Lite Lock


Licensed User
First of all, I purchased B4P few weeks ago and I'm very happy with them. I'm still discovering the tricks.

I'd like to know how can I control the File Locking of SQL Lite. I got some error messages of 'Database is Locked' and I have no ideo how to fix it or to control it.

Thank you in advance,



Active Member
Licensed User
I had the same issue, I solved it by closing the connection before sending another cmd
cmd.CommandText = "SELECT * FROM countries WHERE country = 'XYZ"
Reader.Value = cmd.ExecuteReader
Make sure you use the Reader.Value before closing the Reader, otherwise you lose the value
Last edited:


Licensed User
They both seem to be native code libraries incorporating SQLite code and the encryption routines. They won't work with B4ppc as the B4ppc version of the SQLite library incorporates a managed wrapper because B4ppc is a .NET app.
I'm looking for an encryption tool for SQL Lite. It's a must for me.
If you are willing to roll your own look at my Crypto library http://www.basic4ppc.com/forum/additional-libraries/2220-cryptoex-library.html