I can't say if it works or not, but you could try the cf_IsColdFusionDataSource(dsn) function.
One probably crazy idea off the top of my head, would be to write a program that checked to see if the database is up, if not, switch the ip address in the CF DSN settings in the registry (or wherever MX stores it), and the switch should be transparent to pretty much everything. ...or maybe have the above connection testing set a server variable to the connect string or provider dsn, and just use that server variable in your cfquerys. Lot's more ways really...these ideas are pretty low tech as redundancy solutions go. If you want to hit everything with the CF hammer though... ;-) -- jon mailto:[EMAIL PROTECTED] Tuesday, June 24, 2003, 3:33:47 PM, you wrote: a> I hope that this isn't a stipid question but I'm sure it must have been asked before. a> I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm a> <cfif primary_available> a> <cfset use_database="primary"> a> <cfelseif Secondary_available> a> <cfset use_database="secondary> a> <cfelse> a> .... no database available a> </cfif> a> Any thought on how I can easily check to see which box is available. a> Cheers a> Richard a> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
