Hi there, I created some datasource (SuseLinux + Oracle) and in some datasource instances, I don't need to specify the username and passwords in the cfquery tag while in some I do (even though they are on a separate server from my CF box).
For example: in CF administrator (CFMX 6.1) : Datasource A = server1, Datasource B = server1, Datasource C = server2 <cfquery name="xxxx" datasource="A"> ..... </cfquery> <cfquery name="xxxx" datasource="B" username="xxx" password="xxxx"> ..... </cfquery> <cfquery name="xxxx" datasource="C"> ..... </cfquery> Questions: 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. 2. Is there a way to set a default datasource for CF? thanks everyone Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:248505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
