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.
- Go to Start and in the Run field type sysdm.cpl and press Enter.
- Click the Advanced tab and then click the Environment Variables button.
- In the System Variables section, click New.
- Type the following for each field:
- Variable name: NLS_LANG
- Variable value: AMERICAN_AMERICA.WE8MSWIN1252
- Click OK and close Designer and re-test the issue.
Additional Resources