Yesterday afternoon, one of our technical support was having a problem configuring an application to connect to a Sql server. It returns an error something like "architecture mismatch between the Driver and Application". The application uses a System DSN to connect to the SQL server, so the first thing he looked at is the Data Sources (ODBC) tool but the correct DSN was already configured. But he also noticed that some of the ODBC drivers are missing but since he only needs SQL server, he just ignored it. He was out of solution when he turns to me, I asked him about the operating system of the client computer he was troubleshooting. These are the known facts I had.
- Operating System is Windows 7 Professional.
- The computer was upgraded from Windows XP 32 bit.
The answer to why is, since the computer's original OS was Windows XP, the upgrade process somehow did not update the shortcut of the Data Sources (ODBC) configurator (Control Panel > System and Security > Administrative Tools). So the tech support thought that he already configured the correct DSN but that was not what the operating system was using. The shortcut was still pointing to "odbcad32.exe" located in windows\system32 folder which is for 32 bit. To solve the problem, all you need to do is update the shortcut to point to the following directory: C:\windows\syswow64\odbcad32.exe or %windir%\syswow64\odbcad32.exe
Hope this help! Happy computing!
For More Computer Problem Fix, subscribe now.