[sqlite] PB in sqlite 3.0.2 when define SQLITE_OMIT_DATETIME_FUNCS
PB in sqlite 3.0.2 when define SQLITE_OMIT_DATETIME_FUNCS I think sqlite3RegisterDateTimeFunctions should be in date.c void sqlite3RegisterDateTimeFunctions(sqlite *db){ #ifndef SQLITE_OMIT_DATETIME_FUNCS static struct { char *zName; int nArg; void (*xFunc)(sqlite3_context*,int,sqlite3_value**); } aFuncs[] = { { "julianday", -1, juliandayFunc }, { "date", -1, dateFunc}, { "time", -1, timeFunc}, { "datetime", -1, datetimeFunc}, { "strftime", -1, strftimeFunc}, }; int i; for(i=0; i
RE: [sqlite] Sqlite & COM/EXE server
This is not a sqllite problem, if I understand well your problem. When your service is running, the security account is SYSTEM. SYSTEM on XP has not the right to write everywhere. I'm thinking this is your problem Look where sqlLite write his temp file and look at the security in this place. Regards Eric JESOVER http://eric.jesover.net -Original Message- From: Eugene Lin [mailto:[EMAIL PROTECTED] Sent: Tuesday 06 January 2004 03: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]