[sqlite] Sqlite & COM/EXE server

[Eugene Lin]

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?

Thanks for any help in advance.

Eugenel