1 Reply Latest reply on Mar 8, 2012 7:33 AM by davidjhayden

    ESS "Architecture Mismatch" error - Windows 7

    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?

       

      Thanks!

       

      Dave

       

      dhayden@museumdatasolutions.com