Install and ODBC problem

[Jeff A]

I'm having a problem connecting to a new MySQL 64bit installation using odbc with a W2008 server. I've successfully installed the odbc 5.2.2 64bit connector and have successfully configured a system DSN using it. When I use that ODBC connection from an application, I get the error, "The specified DSN contains an architecture mismatch between the Driver and Application." I've checked on the web and get various solutions including installing the 32 bit ODBC connector instead of the 64bit, installing an older version of the connector, etc. If I try to install a 32 bit version, the driver does not appear in the driver list in ODBC regardless of what connector version I use - so that doesn't seem to be an option. The application I'm trying to connect from is Visual Studio 2010, which, I thought was a 64 bit application, so I'm unsure what's going on. Can someone please explain in simple terminology because I'm new to this?

Thanks

Jeff