Hello tejas, You're using windows so, you should be using "Procmon" to watch file IO. You need to add and look at logging. This is sort of trouble-shooting 101. If you can't get the debugger on it, you'll have to debug with logging.
I'd generate a log file and log everything to do with opening and accessing the DB. C Sunday, February 16, 2014, 11:45:27 PM, you wrote: tp> Hi Teg, tp> I tried putting delay of 3 seconds and 30 seconds but nothing happens. tp> Still not able to access database and store anything. tp> When i create a file to store data it stores. Strange...... tp> Need more views please. tp> Thanks, tp> Tejas tp> On Sun, Feb 16, 2014 at 12:35 AM, Teg <t...@djii.com> wrote: >> 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 >> >> -- 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