hi all, solved it.previously for every 1 second in my code DB file 26 times opened and 26 times colses. so after particular no of time the DB file unable to reopen that file. for that i used a singleton pattern thats why DB file open only once in my entire code. because of that it works fine.
thanks Dennis for u r reply.(now i learn about file permissions in sqlite) thanks, kris cbe kriscbe wrote: > > i tried with 3 options in that pragma temp_store(0,1,2). > but same problem occured. > now that time increased for every 40 secs. > > thanks > > kris cbe > > > > Dennis Cote wrote: >> >> kriscbe wrote: >>> >>> i am getting new problem while executing my sqlite3 using c++ after some >>> no >>> of operations on db file >>> i t gives error "unable to open database file" >>> >> >> This is probably another case of a misleading error message. SQLite may >> be trying to open a temporary file, not your database file. You can >> check the temp store settings with a couple of pragma commands. >> >> pragma temp_store; >> pragam temp_store_directory; >> >> See http://www.sqlite.org/pragma.html#modify for details about these >> pragma commands. >> >> SQLite needs to have permission to create files in that directory. >> >> HTH >> Dennis Cote >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > -- View this message in context: http://www.nabble.com/error%3Aunable-to-open-database-file-tp18608770p18644858.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users