MySQL Data Source not appearing in Visual Studio

by

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.

More Related Contents:

  1. Using MySQL with Entity Framework [closed]
  2. i have an error which i dont understand. can you help me? [closed]
  3. what will be the sql query code of this “Healthcare” database?
  4. Find nearest latitude/longitude with an SQL query
  5. mysql error 1364 Field doesn’t have a default values
  6. SQL: What is the default Order By of queries?
  7. How to group by week in MySQL?
  8. Can I use a function for a default value in MySql?
  9. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  10. Mysql order by specific ID values
  11. How do I check if a column is empty or null in MySQL?
  12. ON DUPLICATE KEY + AUTO INCREMENT issue mysql
  13. MySQL versus PDO [duplicate]
  14. Mysql string split [duplicate]
  15. What is this operator in MySQL?
  16. SELECT * WHERE NOT EXISTS
  17. Increment a database field by 1
  18. Measuring actual MySQL query time
  19. Am I Using JDBC Connection Pooling?
  20. MySQL VARCHAR Lengths and UTF-8
  21. mysql query show multiple tables from one ID column
  22. MySQL: ALTER IGNORE TABLE gives “Integrity constraint violation”
  23. How do I refer to capture groups in a MySQL regex?
  24. What is the default MySQL JOIN behaviour, INNER or OUTER?
  25. What is the difference between SQL and MySQL? [closed]
  26. How to get the mysql table columns data type?
  27. how to use a like with a join in sql?
  28. Escaping the colon character ‘:’ in JPA queries
  29. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment