Error: "Error while trying to retrieve text for error ORA-12705" when adding multiple IN-DB tools to different Oracle databases

[gtorres8]

Environment Details

When adding in at least two In-DB tools to a workflow where each one connects to a different database, one of the In-DB tools will error with the following message:
 

ERROR [HY000] [Oracle][ODBC][Ora] Error while trying to retrieve text for error ORA-12705

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed

ERROR [HY000][Oracle][ODBC][Ora] Error while trying to retrieve text for error ORA-12705
 

• Alteryx Designer
  • 2019.1.7.18602
  • 2019.4.8.22007
• Oracle 11g+
• It doesn't matter the order in which connection is brought into the workflow, a single In-DB Oracle connection works fine, the error only exists if multiple In-DB tools to different Oracle databases.

Cause

Multiple Oracle clients setup or incomplete Oracle client setup left on the system.

Resolution

Setup the variable NLS_LANG in the Environment Variables.

1. Go to Start and in the Run field type sysdm.cpl and press Enter.
2. Click the Advanced tab and then click the Environment Variables button.
3. In the System Variables section, click New.
4. Type the following for each field:
   • Variable name: NLS_LANG
   • Variable value: AMERICAN_AMERICA.WE8MSWIN1252
5. Click OK and close Designer and re-test the issue.

Additional Resources
 

• Oracle Support Article on ORA-12705
• Other causes of the ORA-12705 error