Marcia, >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." > > RDS access is not required to let you set up a web site in ColdFusion. By default all the servers I have ever installed or managed, including workstations, have always had and always will have RDS disabled. It is a massive security risk to leave RDS running on production servers.
>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. > > That connection information looks like information for a dnsless connection to the database. This isn't possible with CFMX 6 or higher. I'm not sure what kind of interface you get from Crystaltech for accessing the CF administrator, but a response of "connection string dsn=name" doesn't sound like a reponse you would get from the datasource section of normal CF Admin. >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. > FTP is all you need. You can set your remote information up in DWMX to point to your Crystaltech FTP server and the test server as your local server details. It is not required that you use DWMX with RDS to develop CF application. You do not need to see data processed within DWMX. In fact it is better if you actually run your site from within a browser, so that you can see what it will really look like as DWMX can only do a poor imitation of rendering your page. Make sure that your datasource name, as set in your application, exists, is the same name and is connecting correctly in the datasources section of your _Crystaltech_ control panel. Other than this, I'm not sure what to suggest. If you are still getting problems give us a URL we can look at where you see the dsn not found error and show us some code. Hope that helps Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Save $10 Download ZoneAlarm Security Suite http://www.houseoffusion.com/banners/view.cfm?bannerid=66 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:942 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
