Page 1 of 1

Sharing Database ?

Posted: 28.02.2009, 21:39
by solook
hi...

i use ZEOSDBO-6.6.4 , Delphi 7

what can i do to add,modify,dellet record on database in two or more computer shared?

Posted: 05.03.2009, 12:12
by mdaems
Have a look here:
http://www.sqlite.org/faq.html#q5

Seems to me you better look for a real client/server database server instead of SQLite, but apparently it may be possible with SQLite as well by just pointing to the same file.

Something that should also work is building a single server program on the server containing the database and let all clients connect to the server process using the TProvider/TClientDataset objects. Then only one process is accessing the sqlite database.

Mark

Posted: 08.03.2009, 08:07
by solook
real client/server database server instead of SQLite,

pleas tell me some free client/server database that sported with zeos component

Posted: 20.03.2009, 22:49
by mdaems
Firebird, Mysql (the 'free' depends on what you do with it), PostgreSQL are all supported.

Mark