Not able to see some DSN's from Windows ODBC on sql_response probe

Document ID : KB000093143
Last Modified Date : 27/04/2018
Show Technical Document Details
Issue:

Sql_response probe connecting via DSN
The probe are not able to see all the DSN's already set via windows ODBC

Windows ODBC View:
User-added image

Probe view:
User-added image
 
Environment:
UIM 8.5.x
sql_response any version
Cause:
Basically DSN must match the bits version of the OS.
​So if you tries to use a DSN created with ODBC Data Sources 32-bits on a probe installed on a 64-bit OS will not able to see the 32-bits and vice versa.
DSN needs to be the same bits version as the Operating System of the robot where the sql_response is running.
Resolution:
Creates ALL DSN's with the same Operating System Bits version