MySQL Data Provider for VS 2005 & 2010

Question

I have VS 2005 ( for legacy apps) and VS 2010 (for new development) installed on my machine. To connect mysql through server explorer for typed dataset, I have installed connector 6.5.4 ( recent). It is appearing in VS 2010 server explorer (Server Explorer -> Add Connection -> Change -> Choose Data Source -> (MySQL Data Provider)). But it is not appearing in VS 2005. Is there a fix / workaround for this?

Answer 1

i am not getting your question clearly may be this will help you..

Check For Refernece to : System.Data.DataSetExtensions

Code

 using System.Data.Odbc;

 private const string ConnStr = "Driver={MySQL ODBC 3.5 Driver};Server=localhost;Database=test;uid=root;pwd=;option=3";