Error "The specified DSN contains an architecture mismatch between the Driver and Application"

Why am I getting an error ‘The specified DSN contains an architecture mismatch between the Driver and Application.’ when running a Crystal Report in DRM?

This error can occur if you create an ODBC using the ODBC Applet in the Control Panel on a 64 bit Windows machine, it will create a 64 bit ODBC.

Just like GP requires a 32 bit ODBC, so does DRM and the DRM Report Engine it uses.

Recommendation:

Remove the 64 bit ODBC connection and then create a new 32 bit ODBC by running c:\windows\sysWOW64\odbcad32.exe rather than by clicking the ODBC Applet in the Control Panel.