jTDS Driver and SQL 2005 Mirror Failover

• Michael Smith

  Valued Member

  Points: 55

  More actions

  October 9, 2006 at 9:07 am

  #67647

  Has anyone had any issues or experience with apps using the jTDS driver and being/not being able to failover seamlessly to a database mirror?  We are hoping to avoid clustering...

  Thanks

  Mike

• edouglas

  Valued Member

  Points: 61

  More actions

  May 8, 2007 at 4:14 pm

  #705100

  Yes, I am wondering about the jTDS driver and failover support as well. Ideally, the freely available driver we're looking for would do the following:

  Provide failover support (MS driver only, AFAIK)

  Provide SSL Encryption (jTDS only, AFAIK)

  Be able to connect from Linux using Integrated Security (no drivers that I know of)

  Doug

• estevens

  SSC Rookie

  Points: 25

  More actions

  May 18, 2007 at 3:53 pm

  #707597

  I'd also really like to know if this is possible, although I suspect it is not without a bit of "glue".

• rbaum

  SSC Rookie

  Points: 27

  More actions

  July 2, 2008 at 1:38 pm

  #837464

  Any answers on this one? For example, can a VirtualIP switch be triggered by the witness server when it executes a failover?