Sharing Database ?

solook · Post by **solook** » 28.02.2009, 21:39

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?

Post by **mdaems** » 05.03.2009, 12:12

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

solook · Post by **solook** » 08.03.2009, 08:07

real client/server database server instead of SQLite,

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

Post by **mdaems** » 20.03.2009, 22:49

Firebird, Mysql (the 'free' depends on what you do with it), PostgreSQL are all supported.

Mark