Thanks Ryan and Oliver for your answers
You are too fast for me, I didn't have the time to answer the first
posts...
@Ryan
> There is no safe way to do what you need. Networked file systems do not
> play nice with file-locking. SQLite is suitable for localized storage,
> not Networked-multi-user-access systems. You need a client-server
> architecture for that.
I know sqlite cannot be "safely" used on a shared network file system
but I'm not sure this is the case here : I believe (May be I'm
completely wrong here, and this is the main point) Windows server with
TSE doesn't use NFS between rdp clients, as the exe + db + dll are on
the same storage but use a different memory space between TSE connexion.
I'm not a windows server TSE expert so I can't tell but I'm hoping
someone can
@Oliver
I won't be able to statically link sqlite in the exe (I wish I could...).
I use "immediate" transaction when writing and try as much as possible
long write operation.
The worst case is when you get a "Database is locked" message which mean
you have to kill all the application processes in order to unlock the db
(unless another means exists ?)
BR
Luc
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
