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
