I have (only) a 32-bit Ingres ODBC driver and 64-bit MS Access. I want to create linked tables in Access that point to an Ingres database.
I know about needing to use
c:\windows\sysWOW64\odbcad32.exe to create and manage 32-bit ODBC connections on a 64-bit machine. But even doing this, and creating a 32-bit ODBC connection with a 32-bit driver, I get the error:
The specified DSN contains an architecture mismatch between the Driver and Application(#0)
when attempting to use the ODBC connection in 64-bit Access.
Is there any way to use a 32-bit ODBC driver with a 64-bit application?