If your query code is all contained in a CFC you can use web services on the guernsey computer and local component calls on the US computer. You would have to change is the "createObject()" or "invoke" call. You would want to add some security to the US computer - probabably in the form of an application.cfc located in the component folder that restricted by IP - and you might want to add some security to the components themselves. I would also add SSL for this communication.
-----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 7:44 AM To: CF-Talk Subject: Two Databases on Two Servers Conundrum 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:254724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
