[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Yoav Apter
Thanks. It is indeed a problem with a temp file - I set the temporary directory with an uninitialized value. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Jay A. Kreibich
On Thu, Jul 15, 2010 at 04:35:56PM +0300, Yoav Apter scratched on the wall: > Using ProcMon we notice that when this happens, Sqlite is trying to > open a new file with a gibberish name which explains the OS error. > At what time does sqlite3_step needs top open a file (considering > the database

Re: [sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Dan Kennedy
On Jul 15, 2010, at 8:35 PM, Yoav Apter wrote: > Hi > > We are building a Windows application using a read-only Sqlite > database. When executing many queries in a short time, we sometimes > get SQLITE_CANTOPEN from sqlite3_step. Checking GetLastError gives > us error code 123: The

[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Yoav Apter
Hi We are building a Windows application using a read-only Sqlite database. When executing many queries in a short time, we sometimes get SQLITE_CANTOPEN from sqlite3_step. Checking GetLastError gives us error code 123: The filename, directory name, or volume label syntax is incorrect. If we