I would think that would have everything to do with whether or not you included the username and password in the datasource configuration. Around here, we don't, because we use different users to connect. So, the CF datasource is basically just a connection to the database, and each developer accesses a different schema based on the username and password that's passed with their queries.
I don't think there's a way to set a "default database" for CF. On 8/1/06, vcc person <[EMAIL PROTECTED]> wrote: > 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). > > F ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:248525 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
