I am trying to export a report to a MySQL database via the ODBC connection but I am getting the following error message:

ERROR: Failed to open database for connection string:

ERROR: m_strError: The specified DSN contains an architecture mismatch between the Driver and Application

I think the MySQL ODBC driver is 64bit - could that be causing the problem? Do I need the 32 bit version?


You need to use c:\windows\sysWOW64\odbcad32.exe to configure 32-bit ODBC DSN.

See also here:


http://msdn.microsoft.com/en-us/library/ms712362%28VS.85%29.aspx


And to configure 32-bit DSN you would need 32-bit version of MySQL driver.