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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DermofitAuthor Commented:
That can work too... Thank you Andy!
0
Atdhe NuhiuCommented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.