I've done something very similar to what you are wanting to do. All you need to do is set up a DSN on Host 2 that points to the Host 1 database. The only trick to this is that you CAN'T use the CF Administrator to set up this DSN. You must use the Window's Control Panel "Data Sources (ODBC)" Management Tool. You set up a System DSN from here. Then you can go back to the CF Administrator and the new DSN should be there.
When I did this before, it was on a CF4.5 server. For the new CFMX server, I think you would "set up" a new "ODBC" DSN, and this should list all the "System" DSN's set up on the server. Hope this helps. Ian Skinner Web Developer BloodSource Sacramento, CA -----Original Message----- From: Tech Support [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 8:30 AM To: CF-Community Subject: Accessing Sql Svr Datasource on a different host I've got an issue.... am hoping someone can answer it. I have two (2) external hosts... and two (2) domains. Primary domain is on Host 1 - and also has a sql server datasource. Secondary domain is on Host 2. How can I access the data source on Host 1 - from Host 2 ? I'm assuming you can map the IP address of Host 2 - to Sql Server on Host 1. This is not the preferred route I would like to follow though - due to cost. Thanks :) Pierre ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
