How to determine if 32-bit or 64-bit ODBC driver is required?

How to determine whether a 32-bit or 64-bit ODBC driver is required?

How to choose which ODBC driver to install? 32-bit or 64-bit?

Should the 32-bit or 64-bit OpenEdge ODBC driver be used to connect to an OpenEdge database?

Can a 32 bit ODBC client connect to a 64 bit OpenEdge database?

Does bitness matter in connections between ODBC and an OpenEdge database?

Does bitness matter when connecting a SQL client to an OpenEdge database?

 

The choice depends entirely on the SQL client that is going to be used, e.g. the software that will make the ODBC connection to the OpenEdge database.
The ODBC driver architecture (32-bit / 64-bit) must match the architecture of the SQL client. Encountering "architecture mismatch" errors is an indication that an attempt is being made to use 32-bit with 64-bit or vice versa.

For example, 32-bit Microsoft Excel would need to use the 32-bit OpenEdge ODBC driver; 64-bit Microsoft Excel would need to use the 64-bit OpenEdge ODBC driver. 

The OpenEdge database is agnostic with regards to driver architecture. It does not "care" whether the ODBC driver is 32-bit or 64-bit; a 32-bit OpenEdge ODBC driver can connect to a 64-bit OpenEdge database and vice versa. 

References to other documentation:

Progress Article(s):
Error "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting via DataServer for MS SQL Server
Connection to SQL Server fails with architecture mismatch error
Architecture mismatch error occurs attempting to establish an ODBC connection via a SQL client