If you do option2, make sure that the datasource connection between the
two servers is secure in some manner. Probably one of the easiest things
to do is to use stunnel (http://www.stunnel.org/index.html) and create a
simple SSL wrapper for the calls. Takes about 5mins to set up.
John
[email protected]
On 9/8/12 9:42 PM, Troy Jones wrote:
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 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
-------------------------------------------------------------
