Skip navigation
hobz2000
hobz2000 Calculating status...
Currently Being Moderated

Coldfusion 9 SQL Mirror connection.

Nov 18, 2011 2:18 PM

Tags: #coldfusion9 #sql_mirroring #dsn

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

951 Views   2 Replies   Latest reply: JrLz, May 16, 2012 12:57 AM
 
Replies
  • hobz2000
    Currently Being Moderated
    1. hobz2000,
    Nov 18, 2011 4:34 PM   in reply to hobz2000
    Report

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

     

    Just add it to the advance connection string.

     
    |
    Mark as:
  • JrLz
    Currently Being Moderated
    2. JrLz,
    May 16, 2012 12:57 AM   in reply to hobz2000
    Report

    Hi,

     

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

     

    Thanks

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points