Coldfusion 9 SQL Mirror connection.

[hobz2000]

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

[hobz2000 · Accepted solution]

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

Just add it to the advance connection string.

[Guest]

Hi,

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

Thanks