1

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?

2

Is there any way to use a 32-bit ODBC driver with a 64-bit application?

No.

You absolutely cannot mix 32bit application and 64bit driver (or vice-versa).

Basically, an ODBC driver is, typically, a dll (windows) or a shared object (linux...) which is loaded by its parent application.

All executables, dlls, etc that share the same process space must be the same bit'ness...

Source Can i use a 32 Bit ODBC Driver for my 64 Bit app, answer by Garry M. Biggs

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.