Geek Answers Handbook

Cannot get factory provider for data provider named MySql.Data.MySqlClient

I have Windows 8.1, MySql 5.6 and Visual Studio Ultimate 2012.

I am trying to install a DataSet, but I get a Cannot obtain provider factory for data provider named MySql.Data.MySqlClient when I try to drag a table into a DataSet.

a) Server Explorer can access the database and show me all the tables, and the "Test Connection" button returns a successful message.

b) I added MySql links to the bin folder ( MySql.Data , MySql.Data.Entity , MySql.Web ).

c) I edited the Web.config file by deleting the MySql.Data.MySqlClient invariant and adding it again with the “correct” settings. I tried setting <connectionStrings> , <DbProviderFactories> , membership providers, profile providers, and RoleManager providers;

d) I have already uninstalled and reinstalled MySql and Visual Studio.

Nothing seems to work and the same error persists. I have already tried many suggestions from this and other forums.

+6
source share
4 answers

you need to install mysql connector just download the latest version of MySql connector and install it when you close visual studio

+2
source

Worked for me, steps below:

  • Close Visual Studio
  • Launch MySQL Connector / Net and uninstall your installation.
  • Run the connector again and set how you did it before the deletion (typical / custom).
  • Open Visual Studio
  • Remove all connections to the server / database / dataset from the solution and server explorer. Do not delete lines of code.
  • Reconnect to your database by naming it as is.
  • Reconnect to your dataset for the dataset as is.
  • Click play, be happy!

Hope this helps.

+2
source

Make sure you install "Connector / NET" and "MySQL for Visual Studio." Launch the "MySQL Installer" and install the two.

0
source

C4U gave me the key I need after fighting this all day. Connector / Net seemed to install with MySQL for Visual Studio when I first used the installer. I could create a connection in Server Explorer, but could not create a new connection from my project. I also could not start the small blue button (setting up the MySQL site). I tried restarting the installer and could not find Connector / Net. It has not been fully installed.
What worked: I closed Visual Studio and opened the programs and functions from the control panel and uninstalled all MySql Connector programs, including Connector / Net. Then I repeated the same Visual Studio installer for MySql that I had worked with before, and, voila !, I could see Connector / Net and install it. Then I opened Visual Studio, deleted my connections and clicked on the little blue button (setting up the MySQL site). Works! I could also create a connection inside my project. And I did not need to add ANY links or ANYTHING to the configuration file.

0
source

More articles:


All Articles