Hi all, We're using SQL Server mirroring w/ SQL Server 2k8, and have setup for automatic failover in the connection string attribute (Other JDBC type). The one thing that is a bit of pain is that the CF instances have to get a failure message back from the DSN before actually failing over -- e.g., the first caller will get an error message; the 2nd caller will get success. This is because the datasource maintains connection (which we want for resource and performance reasons of course).
Has any one come across something that we could add to this connection string that would automatically failover when unreachable? jdbc:macromedia:sqlserver://mydb.mydomain.com:1433 ;databaseName=mydbname;SelectMethod=direct;sendStringParamatersAsUnicode=false;MaxPooledStatements=1000;AlternateServers=( myaltdb.mydomain.com:1433) Cheers, Kris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
