Hello tejas, I'm thinking it sounds like the processing collides and you don't have retry's built into the process. Basically a race condition. The fact you can run one process and it works, and then later run a second process and it works suggests the problem is in the startup when you have two starting at the same time.
As an experiment, I might put a long delay in the thread of the second process so, the first process gets good and started before the second one tries. C Saturday, February 15, 2014, 7:29:14 AM, you wrote: tp> Hi All, tp> We have a small issue with sqlite database. tp> Program structure: tp> one windows service calls two windows processes process-1 and process-2. tp> both processes use common database db1.s3db file to store data. tp> When windows services starts and calls two processes p-1 and p-2 none of tp> the process is able to store data in the database. tp> But if i call only one p-1 with service then everything works well tp> meanwhile if i run p-2 manually with double click then also two processes tp> are able to send data in to database. tp> Please help i am clueless. tp> Thanks, tp> Tejas tp> _______________________________________________ tp> sqlite-users mailing list tp> sqlite-users@sqlite.org tp> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users