question

jamesmcroft avatar image
0 Votes"
jamesmcroft asked MayankBargali-MSFT commented

Test connection failed to on-premise MySQL instance with MySQL Logic App Connector

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.

azure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MayankBargali-MSFT avatar image
1 Vote"
MayankBargali-MSFT answered MayankBargali-MSFT commented

@jamesmcroft You need to install the MySQL Connector/Net on the same machine where you have installed the OPDG. I will pass your feedback to the document team as of now I can see only MYSQL connector reference.

Let me know if it helps you

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the help on this one. We thought this might be the case but didn't want to start randomly installing it in a bunch of places to see what worked.

Thanks for confirming this 👍

0 Votes 0 ·

@jamesmcroft Thank you for your response. Feel free to 'Accept as answer' if it helped so that it can help others in the community looking for help on similar topics.

1 Vote 1 ·