MySQL Data Source not appearing in Visual Studio

F

12

69

I just installed the ADO.NET connector from here http://dev.mysql.com/downloads/connector/net/

Yet MySQL doesn't appear as a data source like it should. I tried restarting Visual Studio. It doesn't fix my issue. Did I install the wrong connector?

enter image description here

EDIT: STill nothing. I'm using Visual Studio Express For Desktop. Do I need to pay for the Ultimate edition to use a MySQL Data Source?

Fecal answered 2/6, 2013 at 3:18 Comment(5)

Check out my answer here for VS2013: https://mcmap.net/q/281876/-mysql-database-connection-with-visual-studio-2013-preview – Chickenlivered 14/12, 2013 at 22:38

I have the same issue for VS2013 but it is appearing well in VS2012... – Last 22/1, 2014 at 11:53

As stated in release notes, MySql Visual Studio integration has never been supported in Visual Studio Express editions. – Disvalue 15/7, 2014 at 1:43

Install an archive 6.9.5, 32 bit, from downloads.mysql.com/archives/c-net. – Declivous 26/1, 2018 at 6:2

In visual studio 2022 doesn't work – Stores 19/10, 2023 at 13:12

H

43

I was having the same problem just now. I solved it by uninstalling the latest Connector/NET drivers (6.7.4) and then installed the older drivers (6.6.5) and it works.

I am using Visual Studio 2010. I uninstalled the latest ones because I figured they were somehow related to .NET4.5, which I'm not able to use.

Update #1:

Supposedly another way is to register the MySql Connector with various Visual Studio versions (2010/2012/2013/2015...) during installation: Go to Modify Product Features and select all the relevant Visual Studio versions.

see Image

Update #2 - Visual Studio 2019 Update:

When I installed MySQL Community with the ConnectorNET and VisualStudio Plugin options included - MySQL didn't show up as a data provider in Visual Studio.

The installer I used included the VS Plugin version 1.2.9, which had supposedly fixed installation issues from 1.2.8, but still didn't work for me...

The solution for me was to uninstall the Connector and the Visual Studio Plugin, download them as individual components, and then install them separately (not as part of the MySQLServer Installer). Install the Connector first, then VS plugin after.

I found the solution here, Thanks to @LambertHeenan.

NOTE about Visual Studio Express

The OP asks whether MySQL is supported with Visual Studio Express (which as far as I can tell has been renamed to Visual Studio Community). In the past MySQL officially didn't support Visual Studio Express, as per @Paul's answer below, but they do officially support Visual Studio Community 2017 and 2019, according to this page.

Henceforward answered 21/7, 2013 at 17:34 Comment(10)

Worked for me using VS 2010 Ultimate. Downloaded from link – Lientery 19/9, 2013 at 19:45

yes also had troubles with 6.7.4, 6.6.6 worked for me. - i also find it important to point out that it might not work with vs2010 express - version – Howlend 5/12, 2013 at 9:26

Starting Connector/Net 6.7, Visual Studio support was splitted into this product, dev.mysql.com/downloads/windows/visualstudio (you need to install both Cnet 6.7+ & MySql for Visual Studio for latest features). – Disvalue 15/7, 2014 at 1:45

its 2k17 but still this works. latest version didnt work for me – Crocket 27/2, 2017 at 13:31

I opened the same screenshot in this answer but since i had installed MySql before having installed VS 2017 it wasn't listed there. The solution was to up – Not 11/10, 2017 at 21:38

can anyone tell me which version is used for Vs 2015 ? – Syblesybley 12/3, 2018 at 16:21

Exact Solution! I tried many times re-installing from MySQL Installer but issue remained same. But then saw your answer, downloaded & installed separately and now it is working! Thanks a lot! – Ogee 27/7, 2022 at 10:11

I have the same problem but in this case with VS2022, MySQL for Visual Studio 2.0.5 is the only one supported but when it try to install it over W10, the wizard "closed repently". Any work arrond, pls? – Stores 6/9, 2023 at 13:56

@DavidCon I also had the same issue. Has anybody found any solution yet? – Allbee 5/11, 2023 at 9:56

@Allbee I personally prefer to use MariaDB (drop in replacement of MySQL) with Pomelo.EntityFrameworkCore.MySql nuget package instead of using MySQL EF. – Henceforward 21/11, 2023 at 20:30

H

15

Stuzor and hexcodes solution worked for me as well. However, if you do want the latest connector you have to download another product. From the oracle website:

Starting with version 6.7, Connector/Net will no longer include the MySQL for Visual Studio integration. That functionality is now available in a separate product called MySQL for Visual Studio available using the MySQL Installer for Windows (see http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html).

Hubblebubble answered 24/7, 2013 at 17:54 Comment(2)

Be warned that the MySql Installer has some issues. There is a version that will download the sources for you - that would not work for me. Kept 404'ing on the download. I had to download the complete 190MB installer to get the Visual Studio tools installed (they are under the "Applications" section, not "Connector"). – Justin 20/8, 2013 at 16:43

The standalone installer for MySql for Visual Studio is available here, dev.mysql.com/downloads/windows/visualstudio – Disvalue 15/7, 2014 at 1:45

T

14

I found this on the MySQL support page for the Visual Studio connectors.

It appears that they do not support the MySQL to Visual Studio EXPRESS editions.

So to answer your question, yes you may need the ultimate version or professional edition - just not Express to be able to use MySQL with VS.

http://forums.mysql.com/read.php?38,546265,564533#msg-564533 enter image description here

Thirzi answered 17/3, 2014 at 13:39 Comment(1)

Alas, this is true - but! Visual Studio 2013 Community Edition, also free, does support MySQL connections, using this: dev.mysql.com/get/Downloads/MySQL-for-VisualStudio/…. Thanks to blogs.oracle.com/MySqlOnWindows/entry/you_can_use_mysql_for. – Triumvir 23/12, 2014 at 0:15

N

12

From the MySql site.

Starting with version 6.7, Connector/Net will no longer include the MySQL for Visual Studio integration. That functionality is now available in a separate product called MySQL for Visual Studio available using the MySQL Installer for Windows (see http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html).

Nun answered 5/11, 2013 at 23:31 Comment(1)

This sounded like a good lead, but did not solve the problem. No mySQL options appear. – Changeling 17/2, 2015 at 1:30

C

9

Tried everything but on Visual Studio 2015 Community edition I got it working when I installed MySQL for Visual Studio 1.2.4+ from http://dev.mysql.com/downloads/windows/visualstudio/ At time of writing I could download 1.2.6 which worked for me.

Release notes of 1.2.4 which adds support for VS2015 can be found at http://forums.mysql.com/read.php?3,633391

Chronologist answered 9/1, 2017 at 19:35 Comment(5)

Mine refused , i did all that what is the possiblity of the problem am using VS2015 – Ahner 11/3, 2017 at 8:36

Wat was refused, be more precise. – Chronologist 11/3, 2017 at 8:39

Mysql Databse is still not visible in my Visual Studio 2015 , i tried all what you said , i read several forums but still it has refused , Is there any manual way of making it work – Ahner 11/3, 2017 at 9:44

Wow..! Your solution worked like a charm for VS2012. GBU. thanks – Shirtwaist 24/4, 2018 at 10:42

same for me for Visual Studio Enterprise 2019: needed to install MySQL for Visual Studio 1.2.10+; you can find it at dev.mysql.com/downloads/windows/visualstudio – Module 10/12, 2021 at 16:44

D

2

The Connector 6.7.x does not integrate the native data provider anymore. For "Visual Studio 2012" or less, you have to install "MySQL for Visual Studio". If you are using "Visual Studio 2013" there is no possibility to integrate MySQL for the "Entity Framework" yet. A solution should be available on 10/2013!

Dulcedulcea answered 17/10, 2013 at 8:31 Comment(1)

MySQL for Visual Studio is supposed to be out 2nd week in November 2013 now. – Nun 14/11, 2013 at 23:9

H

1

Just struggled with Visutal Studio 2017 Community Edition - none of above options worked for me. In my case what i had to do was:

Run MySQL Installer and install/upgrade: Connector/NET and MySQL for Visual Studio to current versions (8.0.17 and 1.2.8 at the time)
Run Visual Studio Installer > Visual Studio Community 2017 > Modify > Individual components > add .NET Framework Targeting Packs for 4.6.2, 4.7, 4.7.1 and 4.7.2
Reopen project and change project target platform to 4.7.2
Remove all MySQL-related nuGET packages and references
Install following nuGET packages: EntityFramework, MySql.Data.Entity, Mysql.Data.Entities
Upgrade following nuGET packages: MySql.Data, BouncyCastle nad Google.Protobuf (for some reason there is an update available just after install)

Homes answered 25/7, 2019 at 9:19 Comment(0)

M

0

Uninstall later version and install mysql-connector 6.3.9 for visual studio 2010.

After installing add the dll files and restart the visual studio.

It works fine.

Muhammadan answered 17/10, 2013 at 15:7 Comment(0)

S

0

i install mysql for visual studio and the problem simply solved.although version of my visual studio is 2012!

Sporangium answered 28/5, 2015 at 15:57 Comment(0)

H

0

I tried to install to VS 2015 using the Web installer. It seemed to work, but there was still no MySQL entry for Data Connections. I ended up going to http://dev.mysql.com/downloads/windows/visualstudio/, using it to uninstall then re-install the connector. Not it works as expected.

Hsining answered 8/6, 2016 at 14:27 Comment(0)

F

0

I have faced the same problem and i have installed mysql-connector-net-8.0.11. But in visual studio is not showing the db connector for mysql. Then I was installed the mysql-for-visualstudio-1.2.8 and run the visual studio. Its working fine.

Thank you!

Freda answered 11/7, 2018 at 6:24 Comment(0)

O

0

It works when I right-click the MysqlConnection tab and hit Re-Run This Query

Oxygen answered 12/2, 2024 at 21:19 Comment(0)

Recommended topics

Hot tags