On 15 Feb 2014, at 12:29pm, tejas parekh <cntte...@gmail.com> wrote:
> When windows services starts and calls two processes p-1 and p-2 none of > the process is able to store data in the database. > But if i call only one p-1 with service then everything works well > meanwhile if i run p-2 manually with double click then also two processes > are able to send data in to database. Have you set a timeout on both processes ? Use either of these: <http://www.sqlite.org/c3ref/busy_timeout.html> <http://www.sqlite.org/pragma.html#pragma_busy_timeout> A timeout of a minute is not unusual. It needs to be long enough that if it fails your application should give up and quit. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users