I am just doing some research into this. With SQL Server 2005 and mirroring, the mirror will automatically take over if the primary/principle server fails. But if you the datasource references the principle SQL Servers name, and that server was down, how would it failover?
The only thing I can think of is that you may need to setup two datasources for the principle and mirror and set up a connection check within the CF application code that checks the server and changes the #datasource# var used in the app to the mirror if the principle is down. But this seems incorrect, because in which state would we consider the princible down? And would those states match the mirrored states? And what about client variable storage, would that need the same type of thing? Any have a mirrored SQL Server and coldfusion running together? How do you do it? BrookD -----Original Message----- From: Sandra Clark [mailto:[EMAIL PROTECTED] Sent: October 4, 2006 7:15 PM To: CF-Talk Subject: RE: Strange behavior? Can't we all just get along???? I mean, Joe Rineheart (MG) and Sean Corfield (FB5) are friends and hang out at conferences and all. Can't we lowly programmers emulate these paragons of coders? <Pttthhhbt!> Sandra Clark ============================== http://www.shayna.com Training in Cascading Style Sheets and Accessibility -----Original Message----- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 9:50 PM To: CF-Talk Subject: Re: Strange behavior? I think Sandra pointed out the solution to this issue just a bit ago (maybe). I'm just vaguely thinking it might be the same, that was with FB3 though, or higher, I think... yarg. BTW, Sandra, could you please stop pushing FB? I mean, I was really hoping to like, make MG the de-facto, and you're, like, hampering that. If people know there are other frameworks, the FRAMEWOR will never cease! Sheesh. Don't you want an end to the madness? *wink* :]3|\| On 10/4/06, Doug Brown <[EMAIL PROTECTED]> wrote: > I am using FB2 in my app, yeah I know I am way behind. Anyhow, I using the sesconverter tag and it is screwing with my stylesheet and image links. > > IE: > > http://localhost/site/_images/top_menu.gif > > Becomes > > http://localhost/site/index.cfm/fuseaction/sub_cats/cat_id/_images/top > _menu.gif > > > > Any ideas? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
