I finally solved this. I exported the site configs from DW.
Copied a working site configs to a new file. Imported the file and edited it to the site with the problem and it works. I would really like to understand exactly what the problem is/was, but this works for now. -----Original Message----- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 16 April 2013 16:44 To: cf-talk Subject: Re: CF 7/ Dreamweaver and Data Sources are you sure the CFIDE is reachable on the URL you have specified in the RDS settings. If this is your local machine, you should only need to specify http://localhost/ as that is where the cfadmin resides by default On Tue, Apr 16, 2013 at 3:53 PM, Jenny Gavin-Wear < jenn...@fasttrackonline.co.uk> wrote: > > Hi Russ, > > It shows the config sequence. The RDS login seems to work fine in > that the password is accepted. > > Step 5 Create a CF data source has :- > > http://mywebsite /cfide/administrator/datasources/index.cfm > > But the database don't list. > > > > -----Original Message----- > From: Russ Michaels [mailto:r...@michaels.me.uk] > Sent: 16 April 2013 15:32 > To: cf-talk > Subject: Re: CF 7/ Dreamweaver and Data Sources > > > does the database/DSN tab still display all the DSN's on that server ? > > > On Tue, Apr 16, 2013 at 3:20 PM, Jenny Gavin-Wear < > jenn...@fasttrackonline.co.uk> wrote: > > > > > Hi all, > > > > My setup is:- > > > > DW CS3 > > CF MX 7 > > Windows 7 WS > > Windows 2003 development server > > MS SQL 2000 database > > Local area network > > > > I am having a problem with DW CS3. > > > > A site I have used for some weeks has suddenly started misbehaving. > > > > When trying to access a CF 7 data source (SQL 2000, I know, it's > > old) binding I get :- > > > > "In order to view the columns of this recordset, please associate > > the variable (#application.dsn#) with a data source. To do this, > > press the plus > > (+) button and choose Data Source Name Variable." > > > > When I try and associate my application.dsn with a data source none > > are seen in the drop down. > > > > I compared the site to another site which is working fine and I > > can't see any difference in the setup. > > > > I have cleared the site cache and removed the data connections from > > within DW. (menu, Site => Advanced) > > > > I tried completely recreating the site copying only the cfm files > > into a new directory. > > > > I tried removing the configs from the Appdata cache/config. > > > > I've used this set up for years, but that doesn't mean to say I > > haven't missed something obvious - very rusty. > > > > Any ideas as to what is wrong, please? > > > > Thanks, > > > > Jenny > > > > -- > > I am using the free version of SPAMfighter. > > SPAMfighter has removed 10828 of my spam emails to date. > > Get the free SPAMfighter here: http://www.spamfighter.com/len > > > > Do you have a slow PC? Try a Free scan > > http://www.spamfighter.com/SLOW-PCfighter?cid=sigen > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
