On 10/31/05, Snake <[EMAIL PROTECTED]> wrote: > I don't acxtually have any to test a sthey have all been removed from the > server. > But it's the standard error you get if you pass invalid login details or no > login details at all.
I'm jumping in late here w/o all the backstory on this thread, but if you're got a server with multiple IP addresses on it (esp Windows, IMHO) you can sometimes get a different "address" if you're using the netbios name instead of the IP in the datasource connection setup. This case isn't db-specific -- I've seen it happen w/ MS-SQL as well, but it's always on machines that have multiple IPs. The symptoms however, are typically *random* failures of the connection, not specifically when it's <cfquery> vs <cfquery name="" password="">. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222729 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

