We use a FQDN rather than a netbios name. E.g. Servername.domainname
-- Russ -----Original Message----- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 15:21 To: CF-Talk Subject: Re: MySQL DSN 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] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:222894 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
