Oct 14, 2019 12:08 PM|PatriceSc|LINK
Seems your intent was to use :
using (OdbcConnection conn=_GetDataConnection())
For now you just call your method but you do nothing with the returned connection and you use a 3rd connection string in your main code. It could be optimized (for example keeping the last connection string name that worked to try it first).
Also what will happen when the first server comes back online ? What are you using for now to keep server in sync? If built in feature, you usually add something in the connection string so that the driver is handling that for you.
If not how do you ensure they are kept in sync before and after the problem or do you plan some manual intervention when it happens?