Using MySQL on Visual Studio 2008

Question

I am using the ODBC connector to access a MySQL db from visual studio 2008 and i am facing performance problems when dealing with crystal reports and to solve this i need a native connector to visual studio. if someone has had a similar problem and knows a solution or tools ( freeware preferable ) , i would be really grateful.

Answer 1

You want Connector/Net

Update: This link should take you to a more recent version: http://dev.mysql.com/downloads/connector/net/5.2.html

Answer 2

Thanks for the answer, but i've already tried that solution but i do not know how to integrate that connector into Visual Studio in order to use crystal reports with such connector. Thanks in advance

Answer 3

Connector/Net is the native provider you are looking for. If you're having trouble using it then you should open a new question asking how to get it working with crystal reports. I don't use crystal reports, so I can't help you there myself.

Answer 4

hi am felix and want to know how to connet mysql database to a c# project in visual studios.please help

Answer 5

i have the same question now......

Answer 6

Refer the below link: You will get more knowledge: http://www.codeproject.com/KB/database/MySQLCrystal.aspx

Answer 7

You need add reference to Mysql.Data.dll. Put the dll in Bin folder and right click - add reference. its sample.