The mysql odbc driver works fine on Visual Studio 2008 but not on Visual Studio 2010

Question

Hey guys, I got a problem that makes my head up and was hoping someone could point me in the right direction.

I have an aC # application that I wrote using visual studio 2008 while I installed the mysql odbc 3.51 driver. This application worked perfectly with mysql db on my localhost and allowed me to do what I needed to do.

I got a copy of visual studio 2010 from the smartsoft dreamspark website, installed it, opened the solution for the application that I wrote in 2008, made some changes, and it works fine.

Then I created a new application this time, starting it in vs2010, creating my odbc connection the same way as in the 2008 application, but now I get the error message:

"ERROR [IN002] [Microsoft] [ODBC Driver Manager] Data source name not found, and default driver not specified"

Then I opened vs2008 and again tried to create a simple program to test my connection, and it worked perfectly.

I can only say that it has something to do with visual studio 2010.

any ideas would be very welcome :)

Pocket

Answer 1

Try reinstalling the MySQL driver, maybe some of the changes in Visual Studio that it wants to make will be present in your 2008 project, but not in the new 2010 project, if installed later.