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

  • mubarakmayyeri's avatar
    mubarakmayyeri
    New Member
    4 years ago

    Thanks a lot, bro. Have been searching everywhere for a solution to this problem. I am using .Net version 8.0.30, I changed this in your code and it worked like a charm..... 

  • Duno's avatar
    Duno
    New Member
    4 years ago

    Thanks a lot! it worked with version Version=8.0.30.0, thanks again!

    • Rajesh9021's avatar
      Rajesh9021
      New Member
      3 years ago

      Hi , i installed version 8.0.33. 
       <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.33.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
      </DbProviderFactories> 

      After adding this  , getting different problem , as like this , 
      failureCould not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

      Please help advise me Thanks a lot.

  • jorgecastro2022's avatar
    jorgecastro2022
    New Member
    4 years ago

    Edit this file

    C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

    And this file

    C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

  • ov3rtim1's avatar
    ov3rtim1
    New Member
    3 years ago

    I have not this tag <DbProviderFactories> and with 8.0.30 I cannot connect ( i uninstalled it and installed the .23 version of the connector ).

  • 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>