Why can't I setup a Reality 32 bit ODBC connection on Windows 7 – 64 bit

There's an issue when trying to setup a DSN using RealSQL Driver 32 bit on a Windows 7 64bit system.
This isn’t peculiar to Reality, but to any 32 bit ODBC driver.

Reality V14.x and the ODBC driver was installed, deciding to configure connections later. However, when trying to setup an ODBC connection, the windows ODBC administrator program does not list the RealSQL 32 bit driver. 

Notice that it also does not show the usual Microsoft Excel ; Access ; dBase ; Foxpro etc. even if the drivers are installed. When listing the available drivers via the ODBC Data Source Administrator, it only shows SQLServer 64 bit.
The issue is that there are two versions of odbcad32. A 32 bit and a 64 bit. They are both named odbcad32.exe.

The problem occurs because the 32 bit odbcad32.exe resides in the syswow64 directory and the 64 bit odbcad32.exe is in the system32 directory.  While applications will pick up the correct registry setting, i.e. 32 bit apps will pick up the 32 bit registry setting and 64 bit will pick up the 64 bit registry setting, setting up a DSN from Control Panel defaults to 64 bit.

To recover:
If you manually run odbcad32.exe, in the syswow64 directory, you are able to configure 32 bit connections, as normal.
It is suggested that shortcuts are created, under Start Menu Reality items or in relevant utility folders, which indicate the relevant version of odbcad32.exe to run.

Back to articles