How to Create an ODBC Connection in Windows x64 Bit

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:

  1. Press the Windows key + r in the keyboard and this will bring the run command.
  2. Type  the following and press Enter:
    1. %WINDIR%\SysWOW64\odbcad32.exe   (for Windows 32-bit application)
    2. %WINDIR%\System32\odbcad32.exe   (for Windows 64-bit application)

Now, you create the ODBC for your application.