I have tried that too! - I must admit that right now I am turning to a KISS solution: String-based database with functions and procedures in a class that handles the different jobs you do on a table. After all these old-fashioned DB's are not so picky :-)
-----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Stephen Chrzanowski Sendt: 12. oktober 2018 14:37 Til: General Discussion of SQLite Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked How about moving the databases elsewhere? Sometimes applications are picky when it comes where files are being written to (IE: Program Files). On Fri, Oct 12, 2018 at 8:30 AM Lars Frederiksen <lars...@dadlnet.dk> wrote: > Setting the Busy Timeout (in FireDAC) to 5000 ms does not solve the > problem - unfortunately! > > -----Oprindelig meddelelse----- > Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > På vegne af Stephen Chrzanowski > Sendt: 12. oktober 2018 14:25 > Til: General Discussion of SQLite Database > Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is > locked > > Change the timeout value on the connection to 5 seconds or so. The DB will > retry. The AV has its grip on it, doing a scan, and won't let anything > else touch it until its done. > > On Fri, Oct 12, 2018 at 3:11 AM Lars Frederiksen <lars...@dadlnet.dk> > wrote: > > > Hello, > > > > I have made (in Delphi) a program that writes to a sqlite database. This > is > > a simple stand-alone solution. Now something is blocking for the programs > > attempt to writing to the databse. There is a an error message: > > [FireDAC][Phys][SQLite] Database is locked. > > > > A friend of mine has analysed the scenario and tells me that BitDefender > is > > the Problem. In BitDefender "Application Access" I have given my program > > permission to "Work". > > > > Any solution on how to "tell" BitDefender that it is OK to make changes > in > > my database? (I have tried BitDefender support - but no ticket answer!) > > > > Maybe also somebody knows an antivirus/anti-malware solution which are > not > > so "hard" as BitDefender? (and with a userfriendly GUI). > > > > Thank you so much for any help. I am rather "desperate" for some help! > > > > Best Regards > > > > Lars > > > > > > > > > > > > _______________________________________________ > > 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 > > _______________________________________________ > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users