Remote Data Source connection

[ronbowalker]

I am new to this so please bear with me...

I am trying to create a new data source in CF Builder. I am trying to connect to a host site that has a production application running on the www. This site is under construction and is a CF project for the most part. I have SQL on my laptop as well as CF9, CF Builder, Dreamweaver CS5. I want to connect to this remote site so I can Query the data to see what has been done in the existing tables to this point. I have never done this before, and I hope this is possible. Not knowing the critical data about the database is making this hard for me. The original data creator is out of the picture, and I am too green to know how to find and extract the database/s. Everything I try in the CF Builder - Data Source template is failing......

So if you can help me to get thru this issue, please reply.

Thanks again,

Ron

[ilssac]

I've never done this with CF Builder (I don't yet have that to play with).

But I have done this before with my developer edition of ColdFusion.  You just put the IP address of the remote database for the "server" field, plus other relevant data base connection data.  Such as user name, password, database|schema, etc.

[Big_Mad_Kev]

To be able to see the datasources in CFBuilder you need ensure the

server has RDS enabled,

most shared hosting companies don't, allow this

But if your saying you have the database locally and all the code, then

you can install ColdFusion locally and run it that way

SELF PROMOTION ALERT: You could check out this ADC Article:

http://www.adobe.com/devnet/coldfusion/articles/setup_dev.html

Once installed you can setup a datasource to your local install using

the ColdFusion Admin.