Thanks Troy:
Yes, the Coldfusion component is hosted on a remote server and I want it to access the datasource, hosted on our local server. Option 1 is not possible since the server administrator does not want the database to be hosted by remote server. It is his decision and I have no say in it. How do you do what you suggested in option 2? I am new to this, can you please elaborate? I tried searching, but likely I am not using the right search terms which can lead to an example. I appreciate your advice and time. ________________________________ From: Troy Jones <t...@dynapp.com> To: "discussion@acfug.org" <discussion@acfug.org> Sent: Saturday, September 8, 2012 9:42 PM Subject: RE: [ACFUG Discuss] Communicating with a data source moved to on another server 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:ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Chris Sent: Saturday, September 08, 2012 3:55 PM To: discussion@acfug.org 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 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------