Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
liqila
Regular Visitor

unable to connect to mysql

liqila_0-1651660080775.png

the connection works well until yesterday.

It says: Details: "An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'".

 

Any ideas on this? thanks

1 ACCEPTED SOLUTION

I downgraded my MySQL/Net Connector to 8.0.28 and that seemed to fix the issue 

https://downloads.mysql.com/archives/c-net/

View solution in original post

8 REPLIES 8
KhaledAbuNada
New Member

My problem is solved

I do the following
1- You delete the current data source via -> File -> Options and settings -> Data source settings

2- I deleted MySQL Connector/NET 8.0.30

3- I downloaded MySQL Connector/NET 8.0.28

Download Link :
MySQL Connector/NET 8.0.28 

It is working fine for me nowScreenshot 2022-09-01 120635.png

redbenn
New Member

I am having the same issue. Tried installing different versions of Mysql/Net connector, reinstalled gateway and no luck. The previous comment links to a database that was changed from MySQL to MariaDB, which is not my case either. It was working perfectly until this morning and nothing changed on the MySQL database

I downgraded my MySQL/Net Connector to 8.0.28 and that seemed to fix the issue 

https://downloads.mysql.com/archives/c-net/

Anonymous
Not applicable

Thank you! This is the first thing that worked for me after spending at least 4 to 5 hours trying to resolve it with various older connector/net versions and other interventions.

 

Anonymous
Not applicable

same!!

yes, that works. thanks very much

Thanks, Amit. Could you please advise how to do it? thanks. 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.