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-tp18608770p18628387.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