Forum Discussion

itimatic's avatar
itimatic
Frequent Visitor
4 years ago
Solved

Refresh data error: Character set 'utf8mb3' is not supported by .Net Framework

When I try refreshing dataset I get error: An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.' Used to work fine before, I get ...
Need Help
  • itimatic's avatar
    itimatic
    4 years ago

    The issue has been resolved.

    The report was previously built based on MySQL database data source
    On server side MySQL database has been converted to MariaDB which caused utf8mb3 errors when establishing connection.
    Updating and downgrading of .Net framework didn't resolve the issue.

    The connection was re-established successfully using connector-odbc-3.1.4 available on https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.4/
    And data source settings I changed from MySQL Database to MariaDB, which resulted in datasets being treated as a completely new source, eventually all worked as before.




azaidi's avatar
azaidi
New Member
4 years ago

For all those still struggling with the issue. Please download the latest so far 8.0.29 version of MySQL .Net Connector from MySQL :: Download Connector/NET

 

and add below text to C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

 

under 

 <DbProviderFactories>
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=8.0.29.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories> 

 

Cheers

SzaboElek's avatar
SzaboElek
New Member
1 year ago

Brilliant , THX. It works : 

  • In ubuntu24.10.1   :    mysql version : 8.0.41-
  • In Windows 10 :  2025. februar gateway version 
  • MySQl connector version : 8.0.29.0  
    and need this too :
    <DbProviderFactories>
    <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=8.0.29.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>