IBM Data Server Provider for .NET HDR Failover
Posted in 2018
We are using the IBM Data Server Provider for .NET with our Windows client applications and are trying to configure it to use the Connection Manager to handle auto fail-over when our primary goes down. With the Informix .Net Provider one may configure a fail-over server group name with setnet and everything works. However, with the DB2 Data Server driver one must connect to a server (host:port) and there does not seem to be a way to specify the primary and secondary servers in the HDR pair. Does anyone have any experience with doing this? The documentation that We have searched is painful to work through and we have not come across anything that provides the information needed to get this scenario configured properly for our applications. Seems to be a little disconcerting knowing that the Informix .Net Provider is being deprecated. We're thinking there must be a simple solution. Thank you for any help or light on the subject. -Gregg