Skip to main content
December 4, 2007
Question

Configuring RDS???

  • December 4, 2007
  • 1 reply
  • 279 views
Hey guys,

I just installed the Cold Fusion Report Writer, and I'm trying to figure out how to configure the RDS so I can make use of it. I'm getting really frustrated and I don't understand what this RDS crap is. I just want to connect to an SQL database. We have two Cold Fusion servers, one has CF7 and the other has CF8. I know what the IP addresses are of both servers, but what do I need to put in the RDS configuration on my own machine so that I can use the local ODBCs I've created on them (to access the servers?). All I'd like to do is be able to write a report. It doesn't seem to make a difference whether I install the report writer on my local machine, or one of those servers and run it locally there.

What is it looking for for "host"? I assume it needs an IP address? I've tried both IP addresses, as well as the various ports (80, 8300, 8500) none of them work.

What am I doing wrong?


Thanks,

Todd
This topic has been closed for replies.

1 reply

Inspiring
December 4, 2007
What am I doing wrong?
Thanks,


First things first. Confirm that RDS is enabled on the CF servers you
are trying to connect to. It is under the "Security" tab of the
ColdFusion Administrator page. You need to turn this feature on and
provide a username and password that will be used with RDS clients, such
as the Report Writer, to access the data source information in the
ColdFusion configuration.

NOTE: It is considered a bad practice to have RDS enabled on production
servers! It could be used by people who should not have access to
access your production data and do not nice things to it.