Re: [sqlite] Sqlite & COM/EXE server
Thank you all for your replies. I do understand the points you're making, i.e. it could be a security context problem in relation to what user account my COM/EXE is attached to, hence to what directories the EXE has the read/write privilege. If it is the case then my question is why Sqlite has no problem accessing the database file itself? Eugene *** REPLY SEPARATOR *** On 01/06/2004 at 2:37 PM Lindsay Mathieson wrote: >Eugene Lin wrote: > >>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! >> >> >Well my guess (from reading the previous emails) is that is neither a >COM or a SQLite problem - basically a lack of understanding re users, >services and nt securiity > >If your com server is running as a normal service (not interactive or >logged on) then it has no user profile. Which means it cannot access any >network directores etc, also it will have no user enviroment settings >such as temporary directories it can access. This why setting the temp >dir to memory works. > >The easy solutuin is to have the service logon as a user, either an >existing one or create a user account for it. > >Alternatively you could create a temp directory thats globaly >read/writable and have the service use that as its temp dir. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Date problem
Hi, With regard to these new date/time functions as pointed out at: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions I have one question: I can't seem to be able to use them on actual datetime field in the database. For instance, my test script as below: create table test(a int, b datetime); insert into test values(1,'2004/1/3'); select * from test where date(b)='2004/1/3' The SELECT statement returns no record. Similarly, the statement: select date(b) from test does not return anything either. Perhaps I misunderstood the usage of those functions? Thanks for any help. Eugene Lin *** REPLY SEPARATOR *** On 01/01/2004 at 10:38 PM D. Richard Hipp wrote: >KL Chin wrote: >> >> Is that away to have a "DATE" comparison inside SQLite? >> Or any expression to convert DATE to integer in SQLite? >> I mean, I don;t have to worry about data migration from other >> database. >> > >http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions > > >-- >D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > >- >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]
[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