Hi, I've used SQLite in a variety of COM situations without problems.
What is your application environment (asp/client-server/desktop)? Is your COM EXE written in VB? Are you using a custom DLL to interface to the SQLite DLL? How is your COM EXE threaded (free/apartment/single)? I've used the SQLite VB DLL from Pivotal (download from the Yahoo files section) without encountering any of these problems. The only reason why you would need to delve into DCOMCNFG is because you are either running the EXE from ASP or from a Service. In which case, you would need to make sure that the launching user of your EXE has correct permissions to launch/access your objects. Equally, the EXE will need permissions to the directories where SQLite writes its temp files. Steve -----Original Message----- From: Eugene Lin [mailto:[EMAIL PROTECTED] Sent: 27 December 2003 14:48 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [sqlite] Sqlite & COM/EXE server 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
