Menu
Simba Technologies
Simba Technologies

SimbaEngine X SDK 10.1.15
Build a C++ ODBC Driver in 5 Days (Windows)

32-bit vs 64-bit ODBC Data Source Administrator

On a 64-bit Windows machine, you can execute both 64-bit and 32-bit applications. Many applications are available in 32-bit versions only, and running 32-bit applications on 64-bit operating systems is common.

However, in a single running process, all of the code must be either 32-bit or 64-bit. A driver must have the same bitness as the application that loads it.

Important:

  • 64-bit applications can only load 64-bit drivers and 32-bit applications can only load 32-bit drivers.
  • In a single running process, all of the code must be either 64-bit or 32-bit.

Note:

  • Microsoft Excel is available in 32-bit and 64-bit versions.

Using the Correct ODBC Data Source Administrator

When using 64-bit Windows, it is very important that you configure 32-bit drivers with the 32-bit ODBC data source administrator, and 64-bit drivers with the 64-bit ODBC Data Source Administrator. This can cause confusion, where what appears to be a perfectly configured ODBC DSN does not work because it is loading the wrong kind of driver.

On a 64-bit Windows machine, use the Control Panel to launch the 64-bit ODBC data source administrator.

To launch the 32-bit ODBC data source administrator, run the following:

C:\WINDOWS\SysWOW64\odbcad32.exe.

Tip:

Create a shortcut to the 32-bit ODBC Data Source Administrator on your Desktop or Start menu if you configure 32-bit data sources frequently.