Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Defaulting to Teradata DSN User and Password Throws Error Message: Table List Error: Error SQL[DriverConnect: [Teradata][ODNC][10380] Unable to establish connection with data source. Missing settings: {[Password}]

JLinAltX
Alteryx
Alteryx
Created

Error: “Table List Error: Error SQL[DriverConnect: [Teradata][ODNC][10380] Unable to establish connection with data source. Missing settings: {[Password}]”

 

Environment Details

 

When defaulting to the Teradata user and password stored in the DSN to make a connection, Designer throws a Table List Error message regarding the password.

Table List Error: Error SQL[DriverConnect: [Teradata][ODNC][10380] Unable to establish connection with data source. Missing settings: {[Password}]
 
image.png

image.png
  • Alteryx Designer
    • All
  • Teradata Database 
    • v16
  • Teradata Database ODBC Driver 16.20.00.108, 16.20.00.110


Cause

The issue is not with Alteryx but with the Password string value not being written into the Teradata ODBC Registry Key.

 
Spoilers
In Windows REGEDIT go to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<Name of your ODBC DSN> and you will see that that Password string value is missing.

image.png


Resolution 1

We have only noticed two affected versions so far: 16.20.00.108, 16.20.00.110.  The ODBC version that we have found to not have this issue is 16.20.00.098.  Beyond this, you will need to try different versions of the ODBC driver or contact Teradata.     
 

Resolution 2

Enter in the user name and password directly into the ODBC prompt when setting up the connection in the workflow.

image.png

Additional Resources

 
No ratings