SQL Lite Lock

2

2220

Member

Licensed User

• Sep 2, 2008

• #1

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,

Joan

 

M

Mr_Gee

Active Member

Licensed User

Longtime User

• Sep 2, 2008

• #2

I had the same issue, I solved it by closing the connection before sending another cmd

B4X:

cmd.CommandText = "SELECT * FROM countries WHERE country = 'XYZ"
Reader.Value = cmd.ExecuteReader
Reader.Close

Make sure you use the Reader.Value before closing the Reader, otherwise you lose the value

 

Last edited: Sep 2, 2008

2

2220

Member

Licensed User

• Sep 2, 2008

• #3

Thank you very much. I'll check all the code.

By the way have anybody tested the Transparent AES Encryption for SQLite DLL with B4P? Or the MapESoft- GIS component with source code


I'm looking for an encryption tool for SQL Lite. It's a must for me.

 

Last edited: Sep 2, 2008

agraham

Expert

Licensed User

Longtime User

• Sep 2, 2008

• #4

2220 said:

By the way have anybody tested the Transparent AES Encryption for SQLite DLL with B4P? Or the MapESoft- GIS component with source code

Click to expand...

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.

Click to expand...

If you are willing to roll your own look at my Crypto library http://www.b4x.com/forum/additional-libraries/2220-cryptoex-library.html

 

2

2220

Member

Licensed User

• Sep 3, 2008

• #5

I'll try Agraham.
Thank you.