ESS "Architecture Mismatch" error - Windows 7

Discussion created by davidjhayden on Mar 6, 2012
Latest reply on Mar 8, 2012 by davidjhayden

Just finished building a small solution for a client that includes an ESS (MySQL) table. Unlike most of our solutions, this one will not be run on a server. On my end the solution was built on a Mac (OS 10.7.2) running FMPA 11v4. They are running Windows 7 (sp. 1) and FMP 11v3. We (seemingly) set up the DSN on her machine with the same name, specs, etc; through the Windows control panel she is able to test the connection successfully.


When she opens the file in FMP and tries to connect, she gets the following message - "ODBC Error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application" and is then prompted for a username and password for the MySQL account. The credentials are stored in FMP, so she shouldn't need them, and entering them here fails.


Any ideas? Is this a 64 bit issue? If so, how to resolve?