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 (http://dev.mysql.com/doc/refman/5.1/en/connector-net-visual-studio-making-a-connection.html) 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?
DermofitAsked:
Who is Participating?
 
Atdhe NuhiuCommented:
Yeah it looks like you can't connect the way you intended.

Have a look hear http://dev.mysql.com/doc/refman/5.1/en/connector-net.html

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

some code like
      MySqlConnection conn;

      conn = new MySqlConnection(connectionString);

			try
			{

   			        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 + "')" ;

                                conn.Open();

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

Open in new window

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

"Once the connector is installed, "

or the connector has not installed correctly
0
 
Atdhe NuhiuCommented:
0
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:

mysql-connector-odbc-5.1.10-winx64.msi
mysql-connector-net-6.5.4.msi

So obviously, it didn't get installed correctly. Anything like that has happend to you?
0
 
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?
0
 
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?
0
 
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
0
 
Atdhe NuhiuCommented:
No I am pretty sure you can do it. Just give a while to dig out an example
0
 
DermofitAuthor Commented:
Do you know if I can access .net Entity Fremework using and ODBC connection?
0
 
Atdhe NuhiuCommented:
Don't know I'm afraid
0
 
DermofitAuthor Commented:
That can work too... Thank you Andy!
0
 
Atdhe NuhiuCommented:
Thanks
0
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.