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 >
