> I am very much a Newbie and very much confused. > > I used Coldfusion MX7, Acess 2000, and Dreamweaver MX 2004 and am > trying to load my dynamic site on a Crystaltech server. Since they do > not allow RDS connections, I have been having problems getting my CF > pages to work. I keep getting the error "Data source Name could not be > found." > > I have configured and tested the DNS through CF Administrator and it > works. Although after testing, it gives me the info: "connection > string dsn=name" and I don't know what to do with that. So maybe > that's the problem. The site worked fine off my hard drive; it was > only once I put it up on the Crystaltech site that I had problems. > > I am learning as I go along, and my client has been patient, but it's > wearing thin and my frustration level is increasing. I have read and > tried so many things, that I am more confused than ever, so please > HELP! > > And a note about Crystaltech; they have been less than helpful. First > they told me they don't allow RDS. So I said, fine but how do I access > my pages without it. Then they replied, we can't give out the RDS > password for security reasons. Then I sent them a screenshot from DW > showing them that I couldn't get around the RDS password problem and > they replied that they only accept FTP. Each time I write back, all I > get is what I can't do, not any help in how to make it work. Their > last reply was to go the DW forums for help... > > I chose Crystaltech after doing some research and they seemed to have > a good reputation on several CF forums. But perhaps I made a mistake? > > Someone from another forum suggested I try posting my question here. > Any help would be greatly appreciated. Thank-you in advance. > Marcia,
You may need RDS to use some of the features offered by DreamWeaver, like the DB connection, but like you said public access isn't allowed on a shared server. But in most cases, if you have your website setup and running all you'll need to do is transfer the site content to their servers, upload the DB, and ask them to create the DSN for you. Make sure the DSN is the same as what is in your code. If they've set it up and it's still not working then ask them to verify it in the CF admin. If it still doesn't work then chances are you have another DSN that you've forgotten about. This is one reason to setup a request scope variable (request.dsn) in your application.cfm file. Then you only have one place to look for it. But yeah, when you transfer you content everything should pretty much be setup other than some testing and maybe a few minor configuration mods. That way you don't have to deal with support techs, I am one, not for CrystalTech ;). Though I can't do anything for you on their servers feel free to email me directly if you have any specific questions. !Clint ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:961 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
