Free Information Technology Magazines and eBooks

Monday, November 29, 2010

Missing ODBC Drivers In Windows 7 64 Bit

Missing ODBC Drivers In Windows 7 64 BitYesterday 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.

13 comments:

Anonymous said...

Thank you! This has helped me find those missing ODBC drivers. Brilliant.

Anonymous said...

Thanks...This helped me...:)

Anonymous said...

Magnificent! MS wouldn't tell you that! :) Crappy shortcut then... :)

FuriousPig said...

Thank you!

Anthony said...

I did what you said here but It still shows
"[Microsoft][ODBC Driver Manager] The specified DSN contains an architechture mismatch between the Driver and Application"
Can you give me solution to this?

suneel kumar said...

Thank u my problem is solved. Thank you once more

Anonymous said...

It fixed my problem. When I changed to the 64bit directory, I had to re enter the system DSN. It was lost when I changed the short cut to 64 bit.

Anonymouse said...

This really saved my life man!
Have been searching for this for quite a weeks!! Our customer moved the server so had to change the IP address in ODBC, but couldn't change it anymore because of this stupid error. Even now, only User-DSN is allowed and no System-DSN, but at least it works! Thnx again!

And to Microsoft: SHAME on you!

Anonymous said...

Thanks a ton ...

RAVIKC

Anonymous said...

nice worked sucessfully
thanks

Anonymous said...

amazing!!!

Anonymous said...

this is really amazing........thank you

Anonymous said...

this is amazing......thank you :)