That doesn't really matter. So long as you're using the right username/password combination, it'll work fine even if you have access credentials in both places. Sometimes it's a matter of going into CFADMIN, getting it all set up so it works, then stripping the creds out of CFADMIN and using them in your datasource. I usually use the DSN to hold the credentials, though, just because I'm too lazy to add them to every... single... query...
But, there's no rule... do it how is most comfortable and makes the most sense. Laterz, J On Mon, 28 Feb 2005 19:03:44 -0400, Larry White <[EMAIL PROTECTED]> wrote: > If you're setting the username and password in CF Admin, > then why are you doing it in cfquery? The datasource should > use the one set up in CF Admin. > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.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:197262 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
