FreeTDS Development Group

[Beth Woods <agentbeckett186 AT yahoo.com>]

Thank you for the quick reply.  That was very helpful, even though it wasn't 
the answer I was hoping for :)

Thanks,
Beth

----- Original Message ----
From: James K. Lowden <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Sent: Monday, April 16, 2007 10:31:59 PM
Subject: Re: [freetds] SQL Server 2005 Mirroring

Beth Woods wrote:
> 
> Our servers are mirrored so that if 
> the primary goes down the mirror will automatically handle any new
> connections.   How can I configure this with the freetds driver?  What I
> basically need is an  alternate server.  I did not see that as an option
> for the configuration file.  

Welcome to the project, Beth.  

FreeTDS doesn't do any kind of failover.  It follows DNS.  In my work
environment, we have a CNAME DNS record that points to the primary.  On
failure, that entry is changed to point to the secondary.  

I think this kind of arrangement is fairly common.  

HTH.  

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com