ODBC 32 bit drivers on Windows 7
When I opened the ODBC control panel (on Windows 7) and started enumerating the built-in database drivers, I got a bit of a shock. Not only were the Microsoft Access drivers missing from the list – so were a bunch of other default ODBC drivers. In fact, the only drivers available were for SQLServer (which I had recently installed). What gives?
The 32 bit ODBC driver panel
It turns out that those drivers are available via a DIFFERENT odbc control panel – the 32 bit one. The default ODBC control panel is the 64 bit one – and does not list any of the older, 32 bit drivers.
To get to the older drivers, you have to fire up this odbcad32.exe – found under the folder C:\Windows\SysWow64.
Once you launch this panel, you should see all your old friends again.
Leave a Reply