How to connect to a MySQL Data Source in Visual Studio

mysql visual-studio-2010 datasource mysql-connector
JohnB picture JohnB · Nov 20, 2010 · Viewed 188.3k times · Source

I use the MySQL Connector/Net to connect to my database by referencing the assembly (MySql.Data.dll) and passing in a connection string to MySqlConnection. I like that because I don't have to install anything.

Is there some way to "Choose Data Source" in Visual Studio 2010 without installing something?

How can I get a MySQL option (localhost) to show up on one of these lists? Or do I have to install something?

(I don't want to use ODBC btw)

"Add Connection" from Server Explorer: alt text

Entity Data Model Wizard: alt text

Answer

Jon Black picture Jon Black · Nov 21, 2010

install the MySQL .NET Connector found here http://dev.mysql.com/downloads/connector/net/

alt text

Related questions

Configuration System Failed to Initialize

I'm new to Visual Studio. I'm currently creating a Login form. I have this code. string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; try { using (OdbcConnection connect = new OdbcConnection(connectionString)) { connect.Open(); OdbcCommand cmd = new OdbcCommand("SELECT username, password FROM receptionist", connect); …

Read More
Unable to connect to any of the specified mysql hosts. C# MySQL

I am getting the above error when I execute the code - MySqlConnection mysqlConn=new MySqlConnection("server=127.0.0.1;uid=pankaj;port=3306;pwd=master;database=patholabs;"); mysqlConn.Open(); I have tried setting server to localhost, user to root but I get the …

Read More
Error 175: The specified data store provider cannot be found

I'm using VS2010 with the MySQL .NET Connector. My project that used to work started reporting: Error 175: The specified data store provider cannot be found, or is not valid. I don't know why, though things got weird after a MS …

Read More