System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 50b265eb03ac04fbd3ae031c4fc5e57b4fb675a0
Title: Multi thread access for encrypted database error!
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Legacy_CryptoAPI Resolution: Rejected
Last Modified: 2016-02-15 19:29:13
Version Found In: 1.0.89.0
User Comments:
anonymous added on 2013-10-30 06:09:52:
Issue is happening when encrypted database opened by two or more program.
(Databases without encryption are working good.)

Data modification of the first program is shown by the second one only if it is the first, third, 5th, 7th, etc. (odd) modification sequentially.
After modifying two, four, six, etc. (even) data sequentially the result is not available in second program. The select command by the second program will get a previous state of database.

I hope it was understandable :)
It would be important for me.

regards,
Akos

mistachkin added on 2013-10-30 07:41:22:
The CryptoAPI-based encryption included with System.Data.SQLite is a
legacy feature, has known issues, and is officially unsupported.  It is
being retained only for the purpose of backward compatibility with legacy
applications that make use of it.

Alternatively, you might want to look into the commercial SEE extension,
which does work with System.Data.SQLite and is fully supported for use
with it.