Hi
The environment my Windows app runs in has recently changed and uses LDAP as the authentication method for connection to the Teradata warehouse.
But I'm really stuck, I am unable to connect using my app now. I can connect ok using the Queryman application, using the same User ID and Password values, so I know the connection is possible and queries will run and return results from the Queryman application.
My ConnectionString looks like this:
DRIVER={Teradata};DBCName=###.##.##.##;User ID=hanco;Password=abcdef1
(of course the IP will have the actual IP of the data server)
The error message I receive is this:
[NCR][ODBC Teradata Driver][Teradata Database] The UserId, Password or Account is invalid.
Any ideas?!?
What is the ODBC Driver for Teradata version?
Try:
Driver={Teradata};DBCName=XXXX;Authentication=LDAP;AuthenticationParameter=userName@@Password;
for additional information about Authentication and AuthenticationParameter refer to the ODBC Driver for Teradata User Guide.
Genius! Thank you NetFx
That Connection String is exactly what it needed.
Much appreciated.