Issue: An ODBC error is generated when attempting to log on to the OnBase Client on a Windows 64-bit workstation.
In a Windows 64-bit environment there are two different registries: 32-bit and 64-bit. This can cause issues to occur when setting up System DSN ODBC sources. In addition, there are two different odbcad32.exe programs which exist on any workstation running in this environment. Each of these versions writes to different parts of the registry for the System DSN.
The 64-bit program version, which is found in the WINDOWS\system32 directory, stores its System DSN settings in the 64-bit registry. ODBC sources created via the 64-bit odbcad32.exe are not displayed in the OnBase Client since it is a 32-bit application.
Resolution: The 64-bit odbcad32.exe is what will be invoked by the Control Panel and by the Start | Run command. In order to create System DSNs that OnBase can use, the odbcad32 program in the %systemroot%\WINDOWS\SYSwow64 directory must be used. This writes to the HKEY_CURRENT_USER\software\wow6432node\ODBC entries.
To launch the 32-bit odbcad32: