How I fixed the "The specified DSN contains an architecture mismatch" error

I got the infamous architecture mismatch trying to set up an ODBC Data Source from Cold Fusion(2011) to an AS400 data source(1st screentshot).

Since it took me two days to track this one down I thought I'd pay it forward by showing you how I fixed it in the hopes of saving someone some time in the future.

I tried many different fixes to match architectures thinking I had the 32 bit version of the ODBC driver vs the 64 bit version and vice versa. I have both, it didn't matter.

The problem was in the Windows Registry, specifically the data source HAS TO HAVE the same name across 32 and 64 bit ODBC entries for it(2nd and 3rd screenshots).

Stack Trace:

Connection verification failed for data source: AS400
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application