It is important to understand which kind of DSN you have. In Windows x64 system, you can create an ODBC connection (DSN) on the 32-bit side of the system or on the 64-bit side of the system.
Most of the 32-bit applications will only see ODBC connections created in the 32-bit side, and 64-bits applications will only see ODBC connections from the 64-bit side. Each kind of application (32-bit or 64-bit) has its own registry entry in the registry.
To setup DSN you must follow these steps:
- Press the Windows key + r in the keyboard and this will bring the run command.
- Type the following and press Enter:
- %WINDIR%\SysWOW64\odbcad32.exe (for Windows 32-bit application)
- %WINDIR%\System32\odbcad32.exe (for Windows 64-bit application)
Now, you create the ODBC for your application.