Bug #112361 MySql connector/NET 8.1.0 not working
Submitted: 15 Sep 2023 16:02 Modified: 19 Sep 2023 12:18
Reporter: Raj Maddala Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Connectors: Document Store: DevAPI Severity:S2 (Serious)
Version:8.1.0 OS:Windows
Assigned to: CPU Architecture:Any

[15 Sep 2023 16:02] Raj Maddala 
Description:
I have installed Connector/.NET 8.1.0 on my machine. Installation succeeded. When I open VS 2019 SSIS project and trying to create connect manager(ADO.NET source)

I am getting error after selecting New connection.NET provider\MySql Data Provider

Error: Failed to find or load the registered .NET Framework data provider

I have checked GAC, I can see MySql.Data.dll in it

What is the issue? Why am I getting that error even after successful installation?

I have tried even SSMS\Import data wizard. I am getting the same error when selected .NET framework data provider for MySQL.

After a long search on google, I found that we need to amend <system.Data) section in machine.config

I have checked GAC, I can see MySql.Data.dll in it

I have tried even SSMS\Import data wizard. I am getting the same error when selected .NET framework data provider for MySQL.

Note: I have .Net 4.0 installed. SSMS 2019
I have tried installing older versions but the installation failing. I can't install any archived versions.

The installation file 8.1.0 is not asking Typical/Custom/Complete options. Its just installing. In the assemblies, I can see only MySql.Data.dll

I can't find MySql.Data.Entity.dll or any

I have old laptop where 8.0.16 was installed and was working.

How to repeat:
I have installed Connector/.NET 8.1.0 on my machine. Installation succeeded. When I open VS 2019 SSIS project and trying to create connect manager(ADO.NET source)

I am getting error after selecting New connection.NET provider\MySql Data Provider

Error: Failed to find or load the registered .NET Framework data provider

I have checked GAC, I can see MySql.Data.dll in it

What is the issue? Why am I getting that error even after successful installation?

I have tried even SSMS\Import data wizard. I am getting the same error when selected .NET framework data provider for MySQL.

After a long search on google, I found that we need to amend <system.Data) section in machine.config

I have checked GAC, I can see MySql.Data.dll in it

I have tried even SSMS\Import data wizard. I am getting the same error when selected .NET framework data provider for MySQL.

Note: I have .Net 4.0 installed. SSMS 2019
I have tried installing older versions but the installation failing. I can't install any archived versions.

The installation file 8.1.0 is not asking Typical/Custom/Complete options. Its just installing. In the assemblies, I can see only MySql.Data.dll

I can't find MySql.Data.Entity.dll or any

I have old laptop where 8.0.16 was installed and was working.
[15 Sep 2023 16:03] Raj Maddala 
n/a
[19 Sep 2023 12:18] MySQL Verification Team 
Hello Raj,

Thank you for the bug report.
Imho this is duplicate of Bug #112232, please see Bug #112232.

Regards,
Ashwini Patil