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
