I would think you could make a single web service at your USA location that would provide all db access you need, and well as provide all CRUD functions. Then just tweak your code in the US and remote location to consume that web service, and you wouldn't even have 2 code bases to update any more. Web services are pretty easy in CF, it shouldn't take you too long.
Chris -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 8:59 AM To: CF-Talk Subject: Re: Two Databases on Two Servers Conundrum 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:254732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
