Exchanging info between remote sites
in [Visual Objects]
|
Prev: XML
Next: OLE Drag & Drop - does it work with VO?
From: Geoff Schaller on 17 Feb 2010 19:22 Ok but I am immediately suspicious. "Nick Friend" <nicktekhne(a)googlemail.com> wrote in message news:3b079fde-e1b3-484b-aa20-bbd6129277c8(a)15g2000yqa.googlegroups.com: > This is over the Internet... > > Nick
From: Dave Francis on 18 Feb 2010 04:26 Nick, If links are always initiated from remote site to centre, do you need to know the remote IP? The remotes could query the centre every now and then for updates? But I did something years ago that might give you what you want. There are sites on the web (something like ipaddressworld.com) that reflect your external IP address. So you can grab this, encrypt it and post it onto a known web site as a small htm file with a file name related to your site's name. Do this everytime you start your app and check it ocassionally while running. Those files can be retrieved at the other sites in VO with GetDocumentByURL (or something like that), decrypt and you have that site's IP. If a site loses contact, as well as retrying the old IP, it looks for a new encrypted file on your web site. HTH Dave (I googled f the centre does not have a fixed IP, then there is a neat "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: Joachim Duerr (ADS) on 18 Feb 2010 05:28 Dave Francis wrote: >But I did something years ago that might give you what you want. >There are sites on the web (something like ipaddressworld.com) that >reflect your external IP address. So you can grab this, encrypt it >and post it onto a known web site as a small htm file with a file >name related to your site's name. Do this everytime you start your >app and check it ocassionally while running. Those files can be >retrieved at the other sites in VO with GetDocumentByURL (or >something like that), decrypt and you have that site's IP. If a site >loses contact, as well as retrying the old IP, it looks for a new >encrypted file on your web site. it might be easier to use a service like dyndns.org. -- Joachim Duerr Advantage Presales check out my new ADS book on http://www.jd-engineering.de/adsbuch
From: Dave Francis on 18 Feb 2010 06:46 Joachim, Thanks for reminding me - I googled but could not remember or find that name quickly. I'm pretty sure it was the service I used back then. Dave Francis "Joachim Duerr (ADS)" <jojo.duerr(a)gmx.de> wrote in message news:7u4j2fF8pgU1(a)mid.individual.net... > Dave Francis wrote: > >>But I did something years ago that might give you what you want. >>There are sites on the web (something like ipaddressworld.com) that >>reflect your external IP address. So you can grab this, encrypt it >>and post it onto a known web site as a small htm file with a file >>name related to your site's name. Do this everytime you start your >>app and check it ocassionally while running. Those files can be >>retrieved at the other sites in VO with GetDocumentByURL (or >>something like that), decrypt and you have that site's IP. If a site >>loses contact, as well as retrying the old IP, it looks for a new >>encrypted file on your web site. > > it might be easier to use a service like dyndns.org. > > -- > Joachim Duerr > Advantage Presales > check out my new ADS book on http://www.jd-engineering.de/adsbuch
From: Nick Friend on 18 Feb 2010 11:43
Dyndns is my backup option if all else fails, but what I'm trying to do is have something completely internal to our program. Also we may end up with some of our larger clients (who can easily have 30 or 40 sites running at once) using this, in which case organising all the accounts for something like dyndns will be a real pain. I think Geoff's suggestion of a web service is probably the way to go (even if he was a bit wide of the mark in other respects ;-) ) Nick On 18 Feb, 10:28, "Joachim Duerr (ADS)" <jojo.du...(a)gmx.de> wrote: > > it might be easier to use a service like dyndns.org. > > -- > Joachim Duerr > Advantage Presales > check out my new ADS book onhttp://www.jd-engineering.de/adsbuch |