Re: [sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-05 Thread Joe Mistachkin
Brzozowski, Christoph wrote: Our application uses the System.Data.SQLite .NET Wrapper ( version 1.0.66.0 ) That version was released in April 2010 and is no longer officially supported. in a multi user scenario, where multiple users on different machines access the same database, which

Re: [sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-05 Thread Brzozowski, Christoph
Thank you very much for the responses. That was helpful. With best regards, Christoph Brzozowski Siemens AG Industry Sector Industry Automation Division Industrial Automation Systems Process Automation I IA AS PA CIS RD 5 Karl-Legien-Str. 190 53117 Bonn, Germany Tel: +49 228 64805-215

[sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-04 Thread Brzozowski, Christoph
Hello, Our application uses the System.Data.SQLite .NET Wrapper ( version 1.0.66.0 ) in a multi user scenario, where multiple users on different machines access the same database, which lies on a network share, or in a single user scenario, where the database lies locally but is accessed

Re: [sqlite] Different read/write behaviour when using System.Data.SQLite .NET Wrapper and using database encryption through a password leads to data inconsistency

2013-09-04 Thread Eric Minbiole
We ran into a similar issue while working on our own (semi-custom) SQLite encryption mechanisms. In my case, it was caused by the SQLite page cache reading the File Change Counter (Header page, offset 24) directly from the ciphertext *before* decrypting the page. (Presumably, this is done for