Delphi - ADO Connection String?

[Hanco]

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

[NetFx]

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.

[Hanco]

Genius!  Thank you NetFx

That Connection String is exactly what it needed.

Much appreciated.