I am a newbie in developing with any MySql product.
I have installed the following in my computer:
1. Mysql-installer-community-8.0.42
2. Mysql-for-visualstudio 1.2.10
3. Mysql-connector-net 8.0.33
4. Visual Studio 2019 Enterprise
5. Using C# language
Creating or displaying any data from the server in the workbench, I don’t have any problem. But I have the following problems accessing data from the server in the visual studio:
1. When I try to use the Data Source Connection am not successful and this error message displays: -
“Failed to open a connection to the database.
“Cannot obtain provider factory for data provider named ‘MySql.Data.MySqlClient.’”
Check the connection and try again”.
2. When I connect from the Server Explorer connection is successful. I can expand the database node and see the table and other sub-nodes, but when I make any attempt to create new table or view contents am not successful and this error message displays: - “Character set ‘utf8mb3’ is not supported by .Net Framework”
3. When I open the query window in the mysql toolbar from the visual studio and type SELECT * FROM sakila, the following error message displays: -
“Error establishing the database connection. Validate that the connection is open”.
Meanwhile, when I use the CREATE command in the same query window, I can create a new table and view it in the workbench.
I will appreciate if someone would help me successfully solve my problems in the mysql for visual studio.
Thanks.