Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How do I connect to MySQL 5.1 in Visual Studio 2010?

Tags:

Does any one know how to connect to MySQL 5.1 with Visual Studio 2010?

I have already tried the MySQL Connector/ODBC route and it got me really nasty results. The table rows were all listed as a view in the views section and nothing at all was listed in the tables or procedures folder.

like image 354
jake Avatar asked May 23 '09 07:05

jake

People also ask

What version of Visual Studio do I need for MySQL?

If you are installing MySQL on Windows, It requires Visual studio to be installed on your system. At the time of answering this question, supported versions are visual studio 2012, 2013, 2015 or 2017.

Does Visual Studio work with MySQL?

MySQL for Visual Studio provides access to MySQL objects and data from Visual Studio. As a Visual Studio package, MySQL for Visual Studio integrates directly into Server Explorer providing the ability to create new connections and work with MySQL database objects.

2 Answers

To get the Entity Frame working with VS2010, I had to do the following:

  1. This only worked with Mysql .net Connector v6.3.1 (alpha). Previous versions ignored VS 2010 (click Development Releases)
  2. I had to rename my Framework\v1.1.4322\CONFIG folder. Otherwise the install will fail. Rename it back when finished

(I've blogged about this here)

Update 6.3.2 is in beta and I can confirm this works. (I didn't need to rename the framework folder)

like image 82
Christian Payne Avatar answered Sep 28 '22 16:09

Christian Payne

this seems to solve the issue

UPDATED LINK TO LATEST RELEASE THANKS @Christian Payne

Update: looks like there is already a non-beta!!!!

http://www.mysql.com/downloads/connector/net/

like image 25
Luiscencio Avatar answered Sep 28 '22 17:09

Luiscencio
Sign in to Comment

Related questions

Unable to make gray eol character by .vimrc
Activating OnBeforeUnload ONLY when field values have changed
what are the disadvantages of RPC with respect to message passing?
What are the containers in Java
Get the content of a sharepoint folder with Excel VBA
Best way to store enum values in database - String or Int
How to execute one test from large TestNG suite using testng.xml?
Provide value for self when using Proc#call
SQL count(*) and distinct
C#: Any benefit of List<T>.ForEach(...) over plain foreach loop?
Android hourglass
Why does adding a new value to list<> overwrite previous values in the list<>

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!