Tag Archives: ODBC

ODBC Drivers Missing from Windows 7 64-Bit

If you go in to the Windows 7 Administrative Tools and double-click on the “Data Sources (ODBC)” icon just as you always have, and then attempt to add a new User DSN or System DSN, you will notice that there are almost no ODBC drivers to choose from.  This is especially confusing for end users who are simply trying to set up a connection to an Access or SQL database.

The secret is that most of those drivers are 32-bit, so, in order to access them you must right click on the “Data Sources (ODBC)” icon and choose “Run as Administrator” in order to see them.  Doing so allows the 64-bit Control Panel applet to display them.

Alternatively, you can simply launch c:\windows\sysWOW64\odbcad32.exe, which launches the 32-bit version of the “Data Sources (ODBC)” applet.

Bonus Tip:  With Windows 7, most organizations are no longer giving end users administrative rights to their workstations.  One consideration in regards to ODBC connections is that in order to create a System DSN, you must be an administrator of the local workstation.

Creating System DSN’s has been the defacto standard of most installation instructions that require DSNs for years, so you will likely need to modify any documentation.  User DSN’s work just as well as System DSN’s, except they must be set up individually for every user on a workstation.