Yes, I'm very positive the data is stored otherwise the application would throw some exception. The database is encrypted by calling passing a private key to the connection using ChangePassword().
Thank you, Raj On Mon, May 23, 2016 at 9:16 AM, R.A. Nagy <r.a.nagy at gmail.com> wrote: > Are we sure that data are being stored at-all? > > Also, how is the database being encrypted? > > > On Sun, May 22, 2016 at 3:02 PM, Rajendra Shirhatti <rrshirhatti at gmail.com > > > wrote: > > > Hi Randall, > > Thank you so much for your reply. > > I don't have enough data to confirm whether database file is missing or > > it's due to some other reason. > > According to my initial investigation, it looks like the application is > > able to create database and perform all the operations successfully upon > > service start. I'm leaning towards the possibility that the tables are > > somehow getting deleted or the database file becomes inaccessible when > the > > service is RESTARTED. We open the database connection during service > > startup and it stays alive as long as service is running. > > Is there any scenario that could corrupt the database because the > > connection was not closed successfully? > > > > Thank you once again. > > > > -Raj > > > > On Sun, May 22, 2016 at 4:54 AM, R.A. Nagy <r.a.nagy at gmail.com> wrote: > > > > > Try: > > > > > > .schema [tablename] > > > > > > Since there is probably nothing there, you probably need to create a > > table. > > > > > > If you are new to SQL / SQLite, then here are some helpful videos: > > > > > > > https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy > > > > > > > > > Cheers, > > > > > > -Randall Nagy > > > President, Soft9000.com > > > > > > > > > > > > > > > On Sat, May 21, 2016 at 4:09 PM, Rajendra Shirhatti < > > rrshirhatti at gmail.com > > > > > > > wrote: > > > > > > > Hi, > > > > We've a .Net Windows Service that uses SQLite 1.0.93.0 for database > > > > operations. The SQLite package contains two binaries, > > > > system.data.sqlite.dll and sqlite.interop.dll. > > > > > > > > The database is encrypted and the blob it contains is encrypted as > > well. > > > > SQLite is intermittently throwing following exceptions while > retrieving > > > > data from the database. > > > > > > > > > > > > - *SQL logic error or missing database no such table*. > > > > > > > > The code is trying to execute a simple query which looks something > > like > > > > this: > > > > SELECT x, y from [tablename] > > > > > > > > This exception is raised while executing > SQLiteCommand.ExecuteReader(). > > > The > > > > stack trace points to > > > > at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String > > > strSql, > > > > SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) > > > > at System.Data.SQLite.SQLiteCommand.BuildNextCommand() > > > > at System.Data.SQLite.SQLiteDataReader.NextResult() > > > > > > > > > > > > > > > > * - Data Source cannot be empty. Use :memory: to open an in-memory > > > > database- unable to open database file * > > > > > > > > These two exceptions are raised while trying to open the connection. > > > > > > > > > > > > Any help or guidance would be appreciated. > > > > > > > > Thank you, > > > > Raj > > > > _______________________________________________ > > > > sqlite-users mailing list > > > > sqlite-users at mailinglists.sqlite.org > > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users at mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >