A quick bit of assistance for anyone else trying to configure RDS in Eclipse, against a remote ColdFusion 8 Server deployed as an instance on JRUN.

DETERMINE THE PORT THAT COLDFUSION IS "RUNNING ON"

1. ?On the remote server, click Start > Administrative Tools > Services, and make sure that the MACROMEDIA JRUN Admin Server service is running.

2. ?Click on Start > Programs > Adobe > ColdFusion 8 (Multiserver version) > JRun Management Console, and log in

3. ?On the home screen of that web app, you will see a list of all installed ColdFusion server instances. ?One of them should be the instance to which you wish to connect via RDS. ?Make note of the HTTP port. ?On my system, the admin instance was 8000, the example instance called "Samples" was on 8200, and my desired RDS instance was on 8300

?

MAKE SURE THE REMOTE SERVER ALLOWS CONNECTIONS ON THE SPECIFIED PORT

In my case, I needed to open the Windows Firewall for 8300. ?You may need to do this on whatever router/firewall you are using.

?

CONFIGURE ECLIPSE

1. ?Click Window > Show View > Other (Alt-Shift-Q, Q)

2. ?Find the ColdFusion folder/node, and choose RDS Dataview

3. ?Click the first icon in that view's toolbar, to show the RDS configuration dialog.

4. ?Click the New button

5. ?Enter a description, the IP address or host name of your server, the port number you discovered above, and a / for the Context Root.

6. ?Enter the username and password you configured for RDS. ?Use the ColdFusion Administrator web interface for your desired server instance, if you need to set/reset the RDS login method and username/password.

7. ?Click Test Connection... you should get a positive result.

8. ?If you wish to use the debugger, you'll need to enable the line debugger in your desired ColdFusion server instance, via the CF Administrator.

You should now be able to view your datasources in this CF Eclipse view, and run queries. ?I use Eclipse "projects" so I never use the RDS file view, but that should ?work for you now also.

Good luck!

?