Re: [sqlite] ATTACH problem

Thank you. I've finally found the problem also thanks to error message. I haven't called sqlite3_reset() after SQLITE_BUSY so retrying step() returned MISUSE. But what to do if I'm fetching the rows for SELECT statement? Reset() would put me to beginning. Can SQLITE_BUSY (or _LOCK) occur after

[sqlite] ATTACH problem

Ok it seems last time I've posted too many errors so I'll try to ask about this one. Maybe other are just consequences of this. I've finally received this error also on my computer, but only in release build. - windows XP, sqlite 3.6.3, VS 2005 - sqlite3_threadsafe() -> 1 - 20 worker threads, e

[sqlite] Random errors

Hi, my post is quit long so I hope somebody will read to end :) I've wrote about my problem before but I still cannot find a solution. My windows app is using sqlite, it is compiled using VS 2005. I've tried more sqlite versions, including 3.6.3. I've tried also to compile sqlite static librar

Re: [sqlite] Error A0A

Do you think this is causing my problem? I've added reset call there because without that this error was more frequent. [EMAIL PROTECTED] wrote: > I'm using some wrapper but modified. > Here is my Exec method: > > > if ( rc == SQLITE_BUSY) > { > Sleep(0); > rc = _sqlite3_reset(m_stmt); > contin

Re: [sqlite] Error A0A

I'm using some wrapper but modified. Here is my Exec method: while(1) { rc = _sqlite3_step(m_stmt); if (rc == SQLITE_ROW) return 1; if (rc == SQLITE_DONE) { _sqlite3_reset(m_stmt); return 0;

[sqlite] Error A0A

I'm using multiple connections to sqlite database from more threads in my application. Few customers reports sqlite error in windows vista which I cannot get in my system. Error code is 0xA0A (I haven't turned on extended error codes). This error number gives no sense to me because it is not de

[sqlite] Mailing list

I apologize if this is off topic but wouldn't it be better to use some standard discussion board, like PHPBB instead of mailing list? It is pain to use mailing lists (you have couple of them for sqlite), ((un)registration, posting, receiving tons of e-mails, searching, etc.). Message from my o

[sqlite] ATTACH problem

I‘m running ATTACH database on SQlite 3.5.8 on windows. I‘m opening one database file and attaching the second one. On my computer it works, but it fails at other computer. The database is opened in more than one thread (it is failing in worker thread). sqlite3_step() returns SQLITE_MISUSE , but