The specified DSN contains an architecture mismatch between the Driver and Application

[Former Member]

I am trying to create aWin32 Dll to reuse some code from an old 32 bit MFC app that connects to a SQL Anywhere12 DB. This will run on a 64 bit W7 system When connecting I get the error [Microsoft][ODBC] The specified DSN contains an architecture mismatch between the Driver and Application. I found several places telling me to use c:windows sysWOW64odbcad32.exe to setup a 32-Bit DSN. The problem is that when I run odbcad32.exe the only non Microsoft driver is UltraLite 12. I need the SQL Anywhere 12 driver. Thanks In advance for any words of wisdom

[former_SQLA_member1694868]

In order to get that SQL anywhere 12 driver to show up in the 32 bit configuration screen you have to install the 32 bit client package for SQLA 12 or install the admin tools' 32 bit version. Then you get the driver in the 32 bit configuration. The 64 bit one is probably installed, but it will not talk to the 32 bit applications I think.

This question has more information and links to even more questions:

ODBC Question