Connecting to a Teradata odbc with Python using LDAP authentication

Third Party Software
New Member

Connecting to a Teradata odbc with Python using LDAP authentication

I need to connect to a Teradata odbc in a Python script over a network using LDAP authentication.   I have downloaded the teradata library and installed it using pip.   Below is my script:

 

import teradata

 

udaExec = teradata.UdaExec (appName="test", version="1.0", logConsole=False)

session = udaExec.connect(method="odbc", system=myServerName",
username="myuserID", password="mypassword");

for row in session.execute("SELECT GetQueryBand()"):
print(row)

 

Something I did seemed to block my access to the server, because it is no longer accepting my user ID and password, before running my script I was able to run queries using Teradata SQL assistant, but it no longer accepts my userID and password as if it was locked for some reason.   I would like to clear up what caused my account to lock, before I ask our Teradata administrator to unlock my password.   Any answers I could get would be appreciated.