Why not set up a web service on the Guernsey server that uses CF to poll the US server for updated data? Or, perhaps easier, how about something like this: on the US server, after any SQL insert/update/deletes, use CFHTTP to post that data to the Guernsey server. The script on the Guernsey server would have the appropriate SQL to insert/update/delete to that server; if the data is sensitive, use an SSL connection and do an IP check on the incoming request.
I think there are a bunch of ways to skin this cat, you could also use web services. Pete On 9/29/06, Les Mizzell <[EMAIL PROTECTED]> wrote: > I have a client that has a site/database hosted in the US. They've > started an international "companion" business that's located in > Guernsey, which is basically a rock in the ocean between England and > France (no offense to anybody in Guernsey - pics I've seen are beautiful). > > The new site for them has to be hosted in Guernsey and have the co.gg > domain extension. They found exactly one Coldfusion hosting service in > Guernsey that they thought could meet their needs. > > The main site in the US is using a MySQL database for all their client > and enrollment information. They need to share that database with the > new site/host in Guernsey. The database is constantly being updated or > added two. > > The host in the US allows a remote connection to their database. In > fact, I don't have a single client with a database that the host > *doesn't* allow a remote connection. Whoop - make that one - the hosting > company in Guernsey. No remote access there. > > So I figure, big deal, if I can't have a remote connection to the > database in Guernsey, then I'll just have them set up a DSN to the > database in the US and keep all data there, which I have permission from > the US host to do. The same folks in the US that administer the > enrollments from the US site will be administering the Guernsey site > anyway, so I could build the admin for the whole thing into the US site. > > The Guernsey host won't set up a DSN to a remote database either. > > So, I see no way to share data. > > Is there a CODE ONLY way to do this? Like maybe a DSN-less connection to > the US database? Ideas? > > "Get a new host" isn't really an option I don't think - I'm going to > have to work with what I've got. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
