TDWallet - Works for password but not username in connection string.

Tools

TDWallet - Works for password but not username in connection string.

Hi everyone,

I'm working on a system where we're connecting to a Teradata system through a python module. The module uses a connection string in the following format:

DRIVER={Teradata};DBCNAME=XXX;UID=*MYUSER*;PWD=*MYPASSWORD*;QUIETNIDE=YES;CHARSET=UTF8;

I've set up a Teradata wallet storing both the username and password. Replacing *MYPASSWORD* with $tdwallet(password_test) works well but when I'm replacing *MYUSER* with $tdwallet(username_test) it does not work.

Any ideas why this can be? All and any input appreciated. Thank you.

2 REPLIES
Teradata Employee

Re: TDWallet - Works for password but not username in connection string.

I'm guessing your connection string is going to the Teradata ODBC driver? Which version? Have you tried the latest efix? What are the details of "does not work"?

If the password works, the username should also work. Make sure the wallet item value was entered correctly (in your example the value would be MYUSER). If it still doesn't work, please capture the TDWALLET log file (described in the "Introducing Teradata Wallet" article on Developer Exchange).

Enthusiast

Re: TDWallet - Works for password but not username in connection string.

to capture the tdwallet log

TDWALLET_DEBUG_FILE=tdwallet.log
export TDWALLET_DEBUG_FILE