Eugene, I obviously didn't explain myself very well in my previous email........
Your problem is NOT, repeat NOT, with SQLite! Your problem is quite clearly a permissions problem on directories accessed by your COM object. As far as I remember, you are instantiating your COM exe from IIS (which runs under the SYSTEM account by default). Your COM EXE takes on the security and profile as defined for it in DCOMCNFG. I would imagine that you haven't changed the defaults for these settings and therefore the COM EXE is very limited as to where it can write files. SQLite is simpy a DLL and so it has the same permissions as your COM EXE when writing it's "normal" work files. You have merely amplified that this is definitely your problem by moving the temporary files into memory. Steve > -----Original Message----- > From: Eugene Lin [mailto:[EMAIL PROTECTED] > Sent: 06 January 2004 02:21 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [sqlite] Sqlite & COM/EXE server > > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
