Thanks Brad, I just checked when you setup a database in windows's odbc data source administrator. There is a check box when you are adding a new datasource for "Use the failover SQL server if the primary SQL server is not available". So this check box must be available if the setup detects that the database is mirrored.
I will have to setup a datasource that is mirrored and try it out. Thanks! Chad -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, November 05, 2007 1:02 PM To: CF-Talk Subject: RE: MS SQL Mirroring and CF I do not speak from experience, but I believe you must have special DB drivers set up with your CF data source which do the fail over for you. ~Brad -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, November 05, 2007 11:12 AM To: CF-Talk Subject: MS SQL Mirroring and CF I am reading up on mirroring our MS SQL server. What I have read you can setup a second server with a second installation of MS SQL. The licensing allows for this also so you don't have to buy two copies. Now you can mirror from one server to the other. Now my question is say you primary server fails and goes off line. The mirrored server kicks in. How do you get your CF server to look for the database on the mirrored server? Obviously the two servers cannot have the same IP or name since they are on the same network. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
