Ok, it's apartment threaded so you're either creating a thread per object or using a pool of threads. The permissions thing on COM EXE is a very common problem in ASP and is described in loads of MS knowledge base articles. I can pretty much guarentee thet your problem is permissions and NOT SQLite per se. As I understand it, SQLite creates a journal file as soon as it opens a database in the same directory as the database file. It then uses temp files in other situations with large sorts etc.
Hope this helps. Steve -----Original Message----- From: Eugene Lin [mailto:[EMAIL PROTECTED] Sent: 27 December 2003 16:41 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [sqlite] Sqlite & COM/EXE server Hi, My COM EXE is written in VC++ and I am not using a custom DLL to interface to the SQLite DLL - I link SQLite statically into my EXE. The EXE is apartment threaded. The EXE itself does not create any interactive visual components such as windows or dialog, it does not use MFC. However you might be right, I am launching the EXE from ASP and that could be the cause of the problem. Although I don't understand why ASP would have such a requirement. I have written some other COM/EXE for ASP in the past and did not have this problem. I still suspect this is something to do with Sqlite, because other features in the EXE work well. >>Equally, the EXE will need permissions to the directories where SQLite writes its temp files. Where is the directory that SQLite writes its temp files? Thanks Eugene *********** REPLY SEPARATOR *********** On 12/27/2003 at 5:18 PM [EMAIL PROTECTED] wrote: >> 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. >> > >The EXE must have a desktop when it wants to create Windows, in MS WIndows >a lot of code is creating invisible Windows, only Interactive Users are >allowed to do >so, there about is the problem with out of process COM-objects and >services, I >forget the exact how and why, but maybe this helps to find the answer > >Bert Verhees > >--------------------------------------------------------------------- >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]
