(lots of DSN/DNS in here, read carefully :) ) so a while back the problem with Java caching the IP when you use a CFHTTP call and if the IP changes Java would still use the original IP address and not the new IP was highlighed.
We're now using a DNS entry for SQL server addresses on SQL DSNs, would you expect this to exhibit similar behaviour should the IP of the SQL server change? We have two SQL server clusters on different IPs and we're planning on testing our disaster recovery plan, ie a fully failed cluster - so the plan is that should we need to switch between SQL clusters we only (at least, that's the plan) have to change the DNS entry (on our DNS server) to the new cluster and we should switch over to the second cluster. any thoughts..or am i just gonna have to try it? john. -- <a href="http://spreadfirefox.com/community/?q=affiliates&id=734&t=1";>Get Firefox!</a> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: 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:190768 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
