Neil, Here's all I can find on the DataDirect site, http://www.datadirect.com/products/jdbc/overview/index.ssp
* SQL Server 2005 Features Support for MAX data types, XML data type, Snapshot transaction isolation levels, DML with Results, and Multiple Open Result Sets. * Connection fail-over support and load balancing for all databases. * Support for distributed transactions across all major databases JTA/JTS (Java Transaction Architecture/Java Transaction Services) support for Oracle, SQL Server, Informix, Sybase, and DB2. I don't know if that answers your question enough, but it does say it supports failover. I wouldn't know how to turn it on, but it is technically supported. You may want to check with the DataDirect support site to read more. I believe the currently available driver version for CF is 3.5, and I think CF7.0 comes with version 3.4. You can get 3.5 from the adobe support/hotfix page: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17883&sliceId=2 -- nathan strutz http://www.dopefly.com/ On 7/16/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > Does anyone know if the vanilla DataDirect drivers which ship with > ColdFusion 7 support SQL Mirror Failover Partners? I can't find any info > on > this so I am guessing no and as a result it looks like I will have to move > to Microsoft SQL 2005 JDBC 1.1 driver. > > I just thought I would ask incase I get pleasantly suprised! > > > > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283796 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
