On 9/23/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>How exactly are you accessing the database over the network?
Two machines with Windows XP on a LAN.
Using file sharing a place my app.exe on one machine and
instructs it to use the file (database) on the other machine,
sqlite3_open("\\LW75\SHARE\data.sq3", &db)
Ok. Perhaps Offline Files is enabled (Folder Options control panel)?
That does a local cache. It will also screw with locks, since it
obviously can't contact the server to guarantee exclusivity (or
release held locks, for that matter).
I also echo the general advice to stay away from concurrent users on
network shares, if you can. The entire concept is sufficiently
complex to make me nervous.
I know some people have worked on a client/server version of sqlite,
so you may be able to find a drop-in replacement without having to
change your configuration (or even code, if they kept the same API).
I don't have links to any offhand though.
>From: Trevor Talbot <[EMAIL PROTECTED]>
>Subject: Re: Disconnected machine with database, SELECT still works !
>Newsgroups: gmane.comp.db.sqlite.general
>Date: 2006-09-23 15:12:09 GMT (38 minutes ago)
>On 9/23/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>> Tried to solve a problem and what I did was to open the
>> database over the net and then physically disconnect
>> the machine.
>>
>> I can still SELECT !
>> sqlite3_prepare() works and gives SQLITE_OK
>> sqlite3_step() gives SQLITE_ROW but is very, very slow
>> sqlite3_finalize() works.
>>
>> First when I do INSERT/UPDATE/DELETE I get an error.
>How exactly are you accessing the database over the network?
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
