The 'scary bit' here is the device not functioning. > A device attached to the system is not functioning.
Is the database/journal on the same/local PC or on a network? Chris On Mon, Dec 4, 2017 at 4:27 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 4 Dec 2017, at 9:31am, Tilak Vijayeta <vijayeta.ti...@gi-de.com> wrote: > > > PID:02FB0036 TID:06B60006 SQLite error (14): os_win.c:36317: (31) > winOpen(\------\TTDB.db3-journal) - A device attached to the system is > not functioning. > > You appear to have a hardware or operating system problem which is causing > a SQLite error. SQLite error 14 is "Unable to open the database file". > > Is there some sort of protection on the journal file, or on the directory > it’s in, which is preventing your program from accessing it ? > > > PID:02FB0036 TID:06B60006 SQLite error (778): os_win.c:34215: (5) > winWrite2(\----\TTDB.db3-journal) - Access is denied. > > "Access is denied" suggests there is some sort of protection or access > problem. > > > 1. A Journal file gets created as a backup on every transaction, > as in Update or Insert. This file gets deleted after the transaction is > committed. > > This is not normal for SQLite. Can you tell us the result of > > PRAGMA journal_mode > > for whatever database file you’re accessing ? > > > 2. I assumed that the journal file goes 'Read Only' sometimes > because of which Delete operation fails. > > That is not something SQLite does. > > > 3. To fix it, every time I come across a SQL Lite error 14, I > change the read only property of the Journal file. > > This does not fit the way SQLite works. If you are in a situation where > you have to do this, you have more serious problems which you will have to > deal with later. You have something which is preventing SQLite from > working properly. Are you running any anti-virus program ? Can you > disable it temporarily while you test your program to see if it’s the > culprit ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users