Chris, I think what you're asking is that you want a cfc that is hosted on a remote server to access your datasource, hosted on your server? If so, I do not know of a way to do that although it may be possible and I'm just not aware of it. I'd recommend one of two things:
1). Move your local datasource and database to the remote server and all will be good as before. 2). If this is not possible, then create a datasource on the remote server and point the connection to your server's MySQL database. From: [email protected] [mailto:[email protected]] On Behalf Of Chris Sent: Saturday, September 08, 2012 3:55 PM To: [email protected] Subject: [ACFUG Discuss] Communicating with a data source moved to on another server Initially, we had on the same box, a MySQL server, a Coldfusion server so when a MySQL database named "mydatabase" was referenced in the Coldfusion component file, the application worked. The application is a Flex front end, Coldfusion middle tier and MySQL back end. The Flex component communicates with Coldfusion using remoting services. Now, the Coldfusion is provided by a off-site hosting provider to avoid costs of a Coldfusion license. However, the datasource named "mydatabase" cannot be accessed by the Coldfusion component since it is on the on-site server. The error message is "Unable to invoke CFC operation failed on the orf2344_cfvars data source" What needs to be done so that the Coldfusion component can access the datasource named "mydatabase"? Our server administrator who changed the servers does not have time to look into this so I need to find out what could have gone wrong and inform him how to fix it. Any suggestions would be appreciated. Thanks ________________________________ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2012.0.2197 / Virus Database: 2437/5256 - Release Date: 09/08/12 ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink<http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
