Prev: XML
Next: OLE Drag & Drop - does it work with VO?
From: Geoff Schaller on 17 Feb 2010 16:22 Nick, Forget email - that is hopeless for the task. The main problem is that it requires users to interact with the process and mail clients to be available and ISP accounts to be set up correctly, blah, blah, blah. Simply will not work. Forget FTP - what a terrible idea. Now you have to write processes to write and pick the data. Everything has to be translated to and from files. It is again asynchronous and there is complexity if you want a secure process. Nup. Bad idea. ADS and Replication - another bad idea. Expensive for starters and replication is too traffic intensive over slow connections. It will drive you nuts implementing the replication commands. The solution? A web service of course. The web service would be a small set of commands to access or set data into your database. The benefits are that it is fully real time, highly secure, free to implement, does not require any end user setup and is extensible into other functionality you may wish to deliver. We have exactly such a system which connects bridge clubs nationwide to a central server. It's like a super backup but it also manages an on-line national database that propagates back out to clubs. The web service could be written in VO but it is a lot easier to user C# (it is quick and small) and the clients can be anything. If they are VO you will need a small XML parser but many of us have one. Cheers, Geoff "Nick Friend" <nicktekhne(a)googlemail.com> wrote in message news:2ce10566-687f-431b-8acd-ee5e4e1a00ba(a)j27g2000yqn.googlegroups.com: > I'm interested to see how others are managing this type of scenario > (or suggestions generally). > > The particular case is this.... we have a construction management > software (DBF/CDX) which is typically installed in the clients main > office, and then with smaller installations in each building site. > We're currently doing the development work to implement Advantage > Database Server in our app to be able to use replication. The idea is > that each site will be constantly updating the central office database > and vice versa. We've run tests and it all works perfectly so far. > > The problem I want to crack is this. I don't want to force clients to > establish static IPs for each site, I want our system to be as > transparent and simple for them to implement as possible. But for > replication to work our software needs to establish the current IP > address of each site every time the systems come up. We'll also need > to occasionally transmit additional data, such as when a new work > directory and database are created in the central office for a new > site for example. > > So far, my thought is to use a single common email account that the > different locations can all send coded messages to... so on start up > the program at each site looks up it's current IP address, sends an > email with date and time stamp, and then queries the same account for > messages from the other sites to extract their IP addresses. > > Has anyone dealt with this type of situation before, or hopefully got > a better suggestion of how to deal with this? > > TIA > > Nick
From: Nick Friend on 17 Feb 2010 17:08 Geoff, I haven't had much to do with web services (which is probably why it hadn't occured to me!), but it sounds like a good route. Thanks You're wrong about ADS and replication by the way... fast, very low traffic and dead easy to implement. Nick
From: Geoff Schaller on 17 Feb 2010 17:50 Nick, My issue with replication is over the internet. I'm not worried about internal LAN replication. Geoff "Nick Friend" <nicktekhne(a)googlemail.com> wrote in message news:142ba606-df9b-4537-b5b5-9f996810ff7c(a)d2g2000yqa.googlegroups.com: > Geoff, > > I haven't had much to do with web services (which is probably why it > hadn't occured to me!), but it sounds like a good route. Thanks > > You're wrong about ADS and replication by the way... fast, very low > traffic and dead easy to implement. > > Nick
From: Geoff Schaller on 17 Feb 2010 17:51 ..also, if you do replication like that then your clients will be up for ADS licenses because you've taken ADS out of its free zone. "Nick Friend" <nicktekhne(a)googlemail.com> wrote in message news:142ba606-df9b-4537-b5b5-9f996810ff7c(a)d2g2000yqa.googlegroups.com: > Geoff, > > I haven't had much to do with web services (which is probably why it > hadn't occured to me!), but it sounds like a good route. Thanks > > You're wrong about ADS and replication by the way... fast, very low > traffic and dead easy to implement. > > Nick
From: Nick Friend on 17 Feb 2010 18:40
This is over the Internet... Nick |