March 31, 2009 at 6:00 am
Hi, was wondering if there is a way or software to have a setting on ODBC to accept multiple sql servers for failover situations. so instead of doing clustering, you would have 2 entries in the ODBC, the first one for the primary server and the 2nd is for the secondery server.
instead of managing it at the application level, it can be managed at one place (odbc)
of course replication should be setup to mirror both servers in case the first server was unreachable.
is there such a thing/program? prefer free 🙂
thank you
March 31, 2009 at 9:36 am
Hi
I don't know about this ODBC driver. Seems to be a custom ODBC driver developed by any third party company.
We have another solution for this and it works just fine:
We use NAT for a specific ip. This ip is usually translated to the primary server. In cause of a failover we just map the ip to the secondary server.
This also avoids that any application connects to secondary server only because the primary server is currently not responding because of network problems or huge load.
Greets
Flo
April 1, 2009 at 9:20 am
if you do db mirroring, i think the sql native client and .net 2 and up supports it. as well as the microsoft jdbc drivers
April 1, 2009 at 9:45 pm
i am completely with your opinion. But to make your application support woking with DB mirroring , you should change alittle in application , and the problem is here> if it is not your own application , how will you change code to support that function/;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply