Delphi - ADO Connection String?

Connectivity
Fan

Delphi - ADO Connection String?

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?!?

2 REPLIES
Teradata Employee

Re: Delphi - ADO Connection String?

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.

Fan

Re: Delphi - ADO Connection String?

Genius!  Thank you NetFx

That Connection String is exactly what it needed.

Much appreciated.