Adding database RDS Login Dreamweaver 8 Coldfusion 8

Forum|Forum|17 years ago
December 2, 2008
3 replies
2003 views

I am using Coldfusion development and Dreamweaver 8, I have had a bad time getting anything to work for this.

I am following the Susan Hove Tutorial 'getting started'. My first problem was that the URL would not test out while I was defining the site http://localhost:8500/wwwroot/mycoldfusion/ when I test this I get a http: 404 which is a not found error I believe. If I remove the wwwroot the URL tests fine and the site definition is ticked but I cannot see any of the data sources CFARTGALLERY etc or MySource which I have added and verified in the Coldfusion administrator.

I suspect the RDS login may be incorrect or the server setup is incorrect, if I click on RDS login I get the error The URL sepcified for this site testing server may be incorrect.

The other thing I suspect is that I have to specify a DSN but I am not sure if I have done this already or not.

Any suggestions would be appreciated, I have lost days playing with this.

Julian

Getting started

This topic has been closed for replies.

D

Daverms

Inspiring

Hi Julian,

Try defining your site right from the scratch. And while doing that, if URL test fails, try replacing the "localhost" with "127.0.0.1" (or with your actual IP). Also make sure that your port number is correct (like, if you running under the built-in webserver then your port might be "8500" or else if you are using IIS it might be "80").

HTH

C

ClubbyJMC2008Author

Inspiring

Hi Daverms

Sorry for the delay I was working on several projects currently,

I have tried your suggestion relating to redefining the site. I have redfined the site and dreamweaver appears to be communicating with coldfusion correctly however when I click on the plus sign in the applications window on the data bases tab it pulls up the connection definition screnn but when I click on OK nothing happens.

Do I need anything else running other than coldfusion and dreamweaver. I have previously from the coldfusion administrator managed to define the DSN and it all checked out. I can also see the data bases in other page types but not in cold fusion.

D

Daverms

Inspiring

Hi,

What happens when you do this,

Application Panel -> Bindings Tab -> Then click the "+" button -> Then select "Record Set" -> Name the recordset and then select the "CFARTGALLERY" from the list of available data sources.

C

ClubbyJMC2008Author

Inspiring

Hi Daverms

When I do this I get an error message saying

'This server behaviour requires a ColdFusion Datasource. Please check the database panel for information on how to create one.' I have tried creating from here but unsuccessfully, I have managed this from ColdFusion administrator bothe before and after installing the extensions that allow you to get the '+' sign on the database Tab.

Thanks
Julian

D

Daverms

Inspiring

Hi Julian,

Had you checked the RDS support during your CF installation?. Are you trying with the same credentials in the site setup (with Dreamweaver)?.

C

ClubbyJMC2008Author

Inspiring

Hi Daverms, thanks for replying.

I don't have any opportunity to put in any logon details, it is just an error message that comes up. I have now tried opening the database in an ASP page and this worked first time but it doesn't solve my immediate problem of making the database available from a CF page. I have defined in CFADMIN I have tried to use the extensions and I have checked out the details in Admin tools of MSoft XP.

Thanks
Julian

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded