An education isn’t how much you have committed to memory, or even how much you know. Its being able to differentiate between what you do know and what you don’t. Its knowing where to go to find out what you need to know; and its knowing how to use the information you get.

William Feather

Recently, I needed to configure an Oracle ODBC connection on a Windows 7, 64 bit,  workstation.  Oracle was loaded and functioning properly.  But no Oracle ODBC driver could be found.  In fact, all the ODBC drivers were missing except for Microsoft SQL Server.  Even the Excel ODBC driver was missing.

I rechecked my Oracle install, I confirmed that I was running as an administrator but the drivers just were not available.  Through a team effort, we found the solution.  It is not obvious and I have no clue what Microsoft’s thought process is.

I documented this solution because I am afraid I will forget it and it was hard to find this solution.  I hope other people find this of some help.

The first two images show the problem.  The next two show the solution by run the ODBC program from the SysWOW64 folder.

Tags: ,

Leave a Reply