Just a little note.
I discovered that one may access the 32 bit ODBC drivers on a 64 bit platform via: C:\Windows\SysWOW64\odbcad32.exe and the 64 bit ODBC drivers via: C:\Windows\System32\odbcad32.exe
This may be handy if one must access a 32 bit application (like Access 2007) via ODBC in a 64 bit environment. The standard ODBC application doesn’t allow you to directly access the 32 bit ODBC connections on a 64 bit platform. It is bit awkward and one could circumvent this issue via a direct call to the 32 ODBC driver environment.
One should always use the appropriate version of the ODBC Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe. The 64 bit ODBC drivers can be accessed directly using C:\Windows\System32\odbcad32.exe. To indicate the type of DSN, you can add “_32” to the 32-bit user DSNs and “_64” to the 64-bit user DSNs.
The 64-bit ODBC Administrator tool can also be invoked from Control Panel to manage user DSNs and system DSNs that are used by 64-bit processes. On a 64-bit operating system, the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64) processes. You must directly invoke the 32-bit ODBC Administrator tool from the SysWoW64 folder. You can use the 32-bit ODBC Administrator tool to manage user DSNs and system DSNs that are used by WOW64 processes.
On a 32 bit system, the 64-bit drivers cannot be installed (of course). The 32 bit ODBC driver are the only drivers that can be found; they can be accessed via the Control Panel.
So, what do we have?
In a scheme:
64-bit Windows | 32-bit Windows | |
64-bit Administrator | C:\Windows\odbcad32.exe or Start -> Control Panels -> Data Sources (ODBC) |
N.A. |
32-bit Administrator | C:\Windows\SysWoW64\odbcad32.exe | C:\Windows\odbcad32.exe or Start -> Control Panels -> Data Sources (ODBC) |