Raised this in a GitHub issue for the docs on the MySQL logic app connector but wondered if there was any help in the community here.
Has anyone successfully connected to an on-premise MySQL instance via the on-premise data gateway with Logic Apps?
We're using the out-of-the-box MySQL Logic App Connector but are coming up against a problem when we try to connect. We thought that the issue might be due to the instance being on a different port number but this doesn't seem like it would affect the connection.
This is the error we are seeing during the test connection.
Test connection failed. Error 'MySQL: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885'
We have installed the required MySQL Connector/Net version on the server where our MySQL instance exists. We also confirmed that we can connect using tools like Jetbrains DataGrip so we definitely have the right server address and credentials.
If anyone has had success with this, any help would be appreciated.