We store ours in a CF struct: DSN = StructNew(); DSN.Source = "" DSN.Username = "" DSN.Password = ""
And then we use that in the queries. We put that in a file that starts with an "_" and then we deny any access to files that start with an "_" so people can access it by some means. My boss is a stickler for security and he is cool with it. Just make sure you never dump it out to screen anywhere and you should be good. We have never had a problem. You could maybe go further if you are worried and make then private variables inside a DSN coldfusion component. That way, they wouldn't even be able to be seen in a dump. Then use getters for values: DSN.GetSource(), DSN.GetPassword(), etc. But that is probably overkill. ....................... Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com "Vote for Pedro" -----Original Message----- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 8:13 AM To: CF-Talk Subject: Required DSN Username & Password I'm using a web host that requires a DSN username & password for every query. I am nervous about storing these values on the server in a globals setting file for obvious security reasons. Does anyone have a suggestion how to safely store a DSN username & password? I've thought about encrypting, but with encrypting I would need a way for CF/BD to decrypt for each query which is like leaving the keys to your car on the front seat when you go into a store. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227153 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54