hi, thanks for your reply. I know there is no permissions problems since after some time when I try the same action, it succeeds. in the website, I manage to read/write/delete in different locations of the code. and since the website is on a shared hosting I cannot modify the TMP definitions, which I assume they exist. the fact that it does work for time to time , makes it difficult to debug.
Shahar. 2012/1/29 Jan Hudec <b...@ucw.cz> > On Sat, Jan 28, 2012 at 23:36:36 +0200, Shahar Weinstein wrote: > > I'm using System.Data.Sqlite the latest version that supports .NET 4 > > in an ordinary .NET website. > > when trying to issue a single update to the database I'm receiving the > > error message saying that the database file is locked. > > there is only one connection open. In the connection string connection > > pooling has been set to off > > the website is being hosted on a shared hosting server. > > Sqlite needs wrtie access to the database file itself, ability to create > and > write to a file in the same directory as the database file and ability to > create and write to a file in temporary directory. > > So first check permissions whether it can do all those operations. To > select > temporary directory, set TMP variable in environment before opening the > database. And make sure you set the same temporary directory in all > processes > that will access the same database. > > -- > Jan 'Bulb' Hudec < > b...@ucw.cz> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users