Skip to main content
H
hobz2000
Participant
November 18, 2011
Answered

Coldfusion 9 SQL Mirror connection.

  • November 18, 2011
  • 1 reply
  • 1945 views

I have been trying to figure out how to connect to a MS SQL database with Mirroring on and autofailover. I am not having much luck with finding anything related to coldfusion 9. They had to have done something with this since MX. Mirroring seems like a very good way to improve server reliability.

Has anyone done this with CF9. I am still wondering why I upgraded.

Thanks in advance.

Dave

This topic has been closed for replies.
Correct answer hobz2000

Turns out to be very easy. AlternateServers=(xxx.xxx.xxx.xxx\instance:1433);

Just add it to the advance connection string.

1 reply

H
hobz2000AuthorCorrect answer
Participant
November 19, 2011

Turns out to be very easy. AlternateServers=(xxx.xxx.xxx.xxx\instance:1433);

Just add it to the advance connection string.

A
Anonymous
May 16, 2012

Hi,

does the native driver support it? or do you need Microsoft JDBC driver for this?

Thanks

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices