Integrate Visual Web Developer 2010 Express with MySql

Hello Experts!

Do any of you know how to integrate MySql to Visual Web Developer 2010 Express. According to MySql Documentation ( it is posible to crate a new MySql Connection from its Add Connection wizard, like this:

Choose Data Source window
However, I'm not getting the MySQL Database option on my list.

Are there any steps I might be missing?
Who is Participating?
Atdhe NuhiuCommented:
Yeah it looks like you can't connect the way you intended.

Have a look hear

This is what I have used in the past install make a reference to the  and  add using MySql.Data.MySqlClient; then

some code like
      MySqlConnection conn;

      conn = new MySqlConnection(connectionString);


   			        string sql = "insert into userlogins " ;
				sql += "(logindate,username,password,success) ";
				sql += "values( '" ;
				sql += DateTime.Now.ToString("yyyy-MM-dd");
				sql += "', '" + this.UserName.Text + "', '" + this.Password.Text ;
				sql += "','" + intSuccess + "')" ;


                                MySqlCommand cmd = new MySqlCommand(sql, conn);
                                MySqlDataAdapter da = new MySqlDataAdapter(cmd);
				cmd.CommandType = CommandType.Text;

Open in new window

Atdhe NuhiuCommented:
I would suspect this is the step you are missing

"Once the connector is installed, "

or the connector has not installed correctly
Atdhe NuhiuCommented:
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

DermofitAuthor Commented:
Thanks Andy.

I forgot to mention. I've already run the following installers, making sure the "Visual Studio Integration" option was checked:


So obviously, it didn't get installed correctly. Anything like that has happend to you?
Atdhe NuhiuCommented:
No, afraid not. The next suggestion is shut everthing down, reboot etc bu you may already have done that.

I also assume that your Visual studio was installed before the connector.

I am using a full version of 2008. I don't know if this might be a limitation of the Express edition?
DermofitAuthor Commented:
I'm starting to think that might be true, and MySql can't be integrated to VWD IDE.

If that is the case, Is there another way of connecting to MySql?
Atdhe NuhiuCommented:
You can use odbc I think there was a download for a MySQL odbc. install that and then set up an odbc connection
Atdhe NuhiuCommented:
No I am pretty sure you can do it. Just give a while to dig out an example
DermofitAuthor Commented:
Do you know if I can access .net Entity Fremework using and ODBC connection?
Atdhe NuhiuCommented:
Don't know I'm afraid
DermofitAuthor Commented:
That can work too... Thank you Andy!
Atdhe NuhiuCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.