Bert, >It is a COM-related problem, not a SQLITE problem
I can now tell you that it IS a sqlite problem NOT a COM problem. Sqlite is trying to create its temporary database at some location (which I'm not sure where) and it failed. I have found that you can force sqlite to store its temporary database in memory. Once I have done that, the problem has gone! Eugene *********** REPLY SEPARATOR *********** On 12/27/2003 at 5:00 PM [EMAIL PROTECTED] wrote: >> Hi, >> >> Does anyone use Sqlite in a COM/EXE server? >> >> I always get the error "no such table: sqlite_temp_master" from Sqlite >when I call any of its API >> function from within a COM EXE. Out of many attempts I discovered that >if I set my COM EXE to run as >> an Interactive User (by using DCOMCNFG) then everything works as >expected. The problem is that a COM >> EXE is not supposed to run as an Interactive User. Why would Sqlite need >to be run in an Interactive >> User account? > >If it is not an Interactive user, then it is a service, a few years ago I >had some >problems with services and not Interactive user-accounts, I found a >solution at >following website. > >http://www.aldyn-software.com/svcom.html > >I did not check it out today, but I guess you find the answer there. > >It is a COM-related problem, not a SQLITE problem > >kind regards >Bert Verhees > >> >> Thanks for any help in advance. >> >> Eugenel >> >> > > > >--------------------------------------------------------------------- >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]