I think it could be an authentication issue between the servers. I noticed that our network folks were surprised to here that the server in question is new to them. the other ones that connected where already in the CFAdmin ... so I think that could be it...
>> 1. Do you know why on some I had to add and some I don't have >> to specify the username and password? Ideally, I don't want >> to have them displayed. > >Typically, if you set the username and password within the datasource >settings in the CF Administrator, you don't have to set them in your CFQUERY >tags. I'm not sure if setting them in your CFQUERY tags overrides the values >within the CF Administrator, but if it does, and you set it incorrectly >within the CF Administrator, that would explain why you need to set them in >your CFQUERY tags. > >> 2. Is there a way to set a default datasource for CF? > >No. However, you could presumably write a custom tag to invoke CFQUERY for >you, which would effectively provide the same result. I wouldn't recommend >you do this, though, because it would introduce many more serious problems >to solve something that's not very important. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
