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 >
