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:355430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm