how to connect MySQL?

A naive question on how to connect MySQL DB from my C# application.
Kindly explain the steps to be taken to communicate with this DB.

Hi,

There're probably multiple ways of doing this, but one could be:

== Get an ODBC driver for MySQL, for instance here: http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32

== Use System.Data.Odbc namespace functions withC#

The latter is nicely explained in MSDN with samples, you shouldn't have any problems getting into it easily. Have you considered using SQL Express instead of MySQL? You might get richer functionality out of the SqlClient.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||hey!
Thanx for help. I successfully established connection through first method.
The second one I dont have an idea about what namespace is so didn't try to go that way.It would be helpful if you can shed some light on that method or provide some tutorial link.

Also, I have never heard of SQL express. MySQL is available free and being a student thats the best thing for me. Is SQL express free too? I guess it may be since other express editions are free for students. And is there any extra functionality that would entice me to use SQL express?

regarsd
Sumit Dagar.