Windows 7 – Unable to Create System DSN on 64-bit

64-bitdsnodbcwindows 7

Environment:
Windows 7 Professional 64-bit Operating System

Problem:
(ODBC Data Source Administrator)
Opening Administrative Tools -> Data Sources (ODBC) -> Click "System DSN" tab.

Error:
ODBC System DSN Warning
You are logged on with non-Administrative privileges.
System DSNs could not be created or modified.

Failed Troubleshooting so far:
Enabled local Administrator account logged in under this account.
Navigated to C:\Windows\System32\ right clicked odbcad32.exe Run as Administrator

Notes:
I am an Administrator on this machine.
The 32-bit version runs fine if I open C:\Windows\SysWoW64\odbcad32.exe
However, I need the data source to be 64-bit.
I am not experiencing this problem on any of my other 64-bit machines.

Any help would be greatly appreciated.

Best Answer

In my case HKLM\SOFTWARE\ODBC\ODBC.INI was missing, which is where 64-bit odbcad32.exe loads list of DSNs from.

So I just created ODBC.INI and ODBC.INI\ODBC Data Sources under HKLM\SOFTWARE\ODBC and that annoying dialog box went away.

Related Topic