Client load balancing helps distribute new connections in your environment so that no one server is overwhelmed with connection requests. When client load balancing is enabled, the order in which primary and alternate database servers are tried is random.
When Connection Retry is also enabled, the ADO.NET Client tries to connect to the primary OpenAccess SDK Server and alternate OpenAccess SDK Servers in a random order until a successful connection is established. If the connection attempt fails, the ADO.NET Client again randomly selects from the list of servers until all OpenAccess SDK Servers in the list have been tried or a connection is successfully established.
