I used to have a script that ran a query and if it failed(using cfcatch) it fired an ASP page that used ADSI and recycled the cf server. This was on a CF4 box and the cf server would lose contact with the database and resetting the cf service fixed that.
Clint ----- Original Message ----- From: "jon hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 3:09 PM Subject: Re: Database Availability > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
