To add. I am assuming it's a simple case of adding a failover partner to the connection string but when you use the vanilla DataDirect driver for SQL server it would appear you would have to edit the Neo-Query file directly to add it.
"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 -----Original Message----- From: Nathan Strutz To: CF-Talk Sent: Mon Jul 16 21:36:58 2007 Subject: Re: DataDirect - use with SQL Mirror Failover Partner 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
