> > You also don't need Midas. Checkout Midware (www.thensle.de (?)). It's
>
>http://www.rtfm.be/fpiette/midwareuk.htm is what you are referring to I
>guess..... Thensle does the free VCS stuff (V2 looks rather good too)
Yes, sorry. FreeVCS is usefull too though.
>MySQL is not free on the Win32 platform......
Hmmmmm, should be...
>MidWare is not to use the BDE. That raises the following questions:
>
>- Is the MS-SQL7 native in D5?? Does it bypass the BDE like IBX??
>- What if the access mechanism was ADO??
There is not native MS-SQL OOB (out of box) but there is some stuff
avaialble. ADO is probably the best choice. Midware won't care what you
use on the back end.
>I am still unclear as to what the best way would be to keep the back ends
>in sync
My idea was that each 'server' process would look after a single database.
If you have 3 clients connected to each of 2 servers then you would have 2
databases. The server process would need to pass along modify requests form
the clients to the other server(s).
You could still potentially get a database out of sync if a message is lost
so some sort of transaction control may be necessary and you will certainly
need to serialize the messages so that things happen in order.
There is lots of technology around that will help, MQ, MTS, replication etc.
In the end, you will still need to do some amount of complex coding. If
you know the issues, then coding it yourself is probably easier, less time
consuming and less complex as you won't need to learn someone elses api.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
