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?
Solved. Had to install and use the 32 bit ODBC administrative tool. Once the DSN was set up as 32 bit all was well.