Brett, Thanks for your message. No, the table is not open in the main thread when I try to open it in other threads. The COM object is indeed a out of process object hosted in a EXE. In fact, this is odd: In order to find out the cause of the problem I have done a simple COM/EXE. I have just one call to Sqlite API in the entire app which is sqlite_open, and I place this call inside the _main() function. If I launch this test app myself, it works just fine. But if it is launched by other apps because of the COM object is being requested, then sqlite_open fails with "no such table: sqlite_temp_master" error.
Unfortunately I can't use the SqlitPlus COM DLL because the version of Sqlite that I'm using is customised by myself - I have added encryption into the database. But I'll take a look at it anyway. Regards Eugene *********** REPLY SEPARATOR *********** On 12/27/2003 at 4:26 PM EzTools wrote: >Hi Eugene. Is the table already open in the main thread when you try open >it in the other thread? Is the COM object an "out of process" object? > >BTW, have you looked into using the SqlitePlus COM DLL? It makes life >*much* easier than with the Sqlite database engine. Here are the links to >check it out: > > www.eztools-software.com/sqliteplus.htm > www.eztools-software.com/downloads/sqliteplus.exe > >cheers >-Brett Goodman > >----- Original Message ----- >From: "Eugene Lin" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, December 27, 2003 2:46 AM >Subject: [sqlite] Fwd: no such table: sqlite_temp_master > > >> Hi, >> >> When I use Sqlite from the main thread everything works very well, but if >> I call any API function such as "sqlite_open" from a sub-thread then I >> always get: "no such table: sqlite_temp_master" error. The sub-thread is >> within a COM object which is invoked by another application. Can anyone >> please help? >> >> Eugene >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
