MSSQL Failover and Connection String

Question

Hi,
I am using Coldfusion 8. In CFIDE I saw "Connection String"
parameter under Advanced setting for MSSQL Data connection.

I was wondering if we can use it for failover using a
connection string like:
"Data Source=server1;FailoverPartner=server2;Initial
Catalog=db_name;Uid=db_user;Pwd=db_pass;"

Where server2 is mirrored database.

thanks in advance :)

Sébastien Close · Answer

Hi,You have to create a specific dsn to use this feature.First create a new ColdFusion datasource of type“Other”. Enter the following settings, replacing XXXs with yourdetails; CF Data Source Name: XXX JDBC URLjdbc:macromedia:sqlserver://ipaddress_server1:1433;databaseName=XXX;SelectMethod=direct;sendStringParametersAsUnicode=false;MaxPooledStatements=1000;AlternateServers=(ipaddress_server2:1433)Driver Class : macromedia.jdbc.MacromediaDriver Driver Name: SQL2005 User Name : XXX Password : XXX If you use unicode for string (nvar, ntext, ...), you have tochange sendStringParametersAsUnicode=false to trueEnjoy!Sébastien

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.