All Forums Connectivity
Hanco 4 posts Joined 05/12
22 May 2012
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?!?
 

NetFx 259 posts Joined 09/06
22 May 2012

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 4 posts Joined 05/12
23 May 2012

Genius!  Thank you NetFx

That Connection String is exactly what it needed.

Much appreciated.

You must sign in to leave a comment.