Teradata Connector Invalid password

[Terala]

Hi,

Does anyone has solution to this error message:

Code: Select all

Teradata_Connector_0: RDBMS code 3003: Invalid password. (CC_TeraConnection::connect, file CC_TeraConnection.cpp, line 841)

I am able to connect to Teradata DB from Unix Server using tbuild and bteq but unable to connect from DataStage 8.5 using Connector stage.

Appreciate your help !

Thanks

[ray.wurlod]

Check and double check the user name/password combination specified in the Connector or its associated Data Connection.

[PaulVL]

Other than "you have a bad password..." this may sound silly but change your character set to UTF-8 or 16 on the TD connector stage.

We've seen this happen in our shop.

[bobyon]

You should also try surrounding the password with quotes. Unfortunately I don't remember if it requires single or double quotes.