ConnectionString and Failover

[lkrueger]

I'm a newbie here, switching over from MySQL Connector/Net, and the documentation is pretty vague on how the Server parameter of a connection string can be set up with multiple servers. Is this supported by devart dotConnect?

For example, I would like to construct my connection string to utilize failover/load balancing of a clustered database

Code: Select all

<connectionStrings>
  <add name="MySqlServices" 
     connectionString="server=192.168.1.1,192.168.1.2,192.168.1.3; Database=pri;
     User ID=***; Password=***;" />
</connectionStrings>

[Pinturiccio]

dotConnect for MySQL supports load balancing feature. This feature allows you to specify several hosts with their ports in the Host parameter of the connection string. For more information, please refer to http://blog.devart.com/oracle-12c-suppo ... ducts.html

[lkrueger]

For anyone else with this question, my problem was that I didn't have parenthesis around the IP addresses which is why it was giving me errors