Page 1 of 1

Teradata Connector Invalid password

Posted: Sat Oct 06, 2012 5:00 pm
by 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

Posted: Sun Oct 07, 2012 3:52 pm
by ray.wurlod
Check and double check the user name/password combination specified in the Connector or its associated Data Connection.

Posted: Sun Oct 07, 2012 5:49 pm
by 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.

Posted: Tue Oct 09, 2012 2:30 pm
by bobyon
You should also try surrounding the password with quotes. Unfortunately I don't remember if it requires single or double quotes.