32bit ODBC connector not allowing connection

Hi, have installed an ODBC x32 connector for a SYSTEM/4 database. have tested using MS ODBC connector test tool and can access the database. When I attempt to access using ODBC connector in ETL Processor will not allow "Browse data" - fails with "Failed to connect to DSN" message. If I try and use Lookup it fails with "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application" error. Does ETL Processor not support ODBC using 32bit drivers? Thanks Martin

32-bit windows applications only work with 32-bit ODBC drivers.
64-bit windows applications only work with 64-bit ODBC drivers.
It is been like this since Windows32/64 was created.
We do have both 32-bit nd 64-bit versions of our software.

Thanks for informative reply.

The ETL iteration we are running is 64bit, it accesses a native 32bit database (MariaDb) with no problem and there is no mention in the selection list of DSN's that we are selecting a 32bit ODBC driver.

As there are different versions of the software how do we run the 32bit version as well as the 64bit version please? If I attempt to execute the 32bit executable it does nothing.

1) The ETL iteration we are running is 64bit, it accesses a native 32bit database (MariaDB) with no problem and there is no mention in the selection list of DSN's that we are selecting a 32bit ODBC driver.
We do not use ODBC for MariaDB connections.
Or software connect directly to it via TCP/IP. So it does not matter if MariaDB is 32 bit or 64 bit.
2) In the case of ODBC, it is different. 64 bit software cannot work with 32 bit dll's (ODB driver is a dll file)
3) 32-bit folder allows running transformation/packages in the 32-bit mode, ONLY when it is executed using the agent. EG you have to design the transformation first then you will be able to execute it.
4) Install the 32-bit version of our software (just designer), connect to the same repository and design the transformation.
Please post more screenshots the do help a lot

Thanks again - will get the 32bit Designer installed on the box and try again! Watch this space.

Hi, attempting to download the 32bit "Enterprise" version (which is the version licensed by the client) and the file downloaded is empty - the 64 bit download is the same, "Professional" download works however. Is there another way of accessing the Enterprise version software please? Thanks Martin