64-bit Machine ODBC operation method and 32-bit machine is not the same, if directly from the Control Panel-Administrator tool-ODBC into the user DSN and the System DSN is empty, add when even ODBC driver can not be found, the correct method should be from after the C:\WINDOWS\SysWOW64 enters, locate the odbcad32.exe and open it to see the existing System DSN and the installed ODBC Driver. ( Why name it odbcad32 I really don't understand it.
Next to say that the System DSN removal, normally can be removed normally, but yesterday machine suddenly convulsions, I need to use the DSN anyway is not even, unexpectedly still deleted, so had to delete from the registration table. The location of the registry should, in a logical sense, be:
Hkey_local_machine\software\odbc\odbc. INI\ODBC Data Sources
However, if you do not see this directory directly from the run, the reason or because it is a 64-bit machine, running C:\WINDOWS\SysWOW64 in the Regedit.exe can be found and deleted ( this is not regedit32) .
Hkey_local_user\software\odbc\odbc. INI\ODBC Data Sources
Also want to delete in the
It's not so much about the design and naming of windows, but the problem is solved.
http://wander754085.iteye.com/blog/1708921
Win7 64-bit machine ODBC data source DSN additions and removal issues