Ed, When you specify an IP the JDBC driver tries to do a reverse lookup to build it's connection string. If it gets a "not found" response it then tries to contact the IP directly. Failing that it uses the IP. This process adds overhead to your connection process. It's why I always "short-circuit" the process and add host entries for whichever DB servers I'm using. Then resolution is always assured whether or not the DNS server is up.
-Mark -----Original Message----- From: Edward Chanter [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 5:45 AM To: CF-Linux Subject: Previous Email Just to let you know that I sorted the problem out. We had a DNS server that was down and for some reason CF needs that to connect to a DSN, even though the DSN had an ip specified and that IP is on the same subnet as the CF server. Very weird, but it's working now so it's all good. best wishes, -= Ed ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Edward Chanter Technical Innovations Manager Collaborative Connections Ltd. http://www.cc.uk.com/ Phone: +44 (0) 1273 832221 Mobile: +44 (0) 7866 365282 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:14:3831 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
