Fred Suggested: In the Teradata ODBC driver configuration, Advanced options, try selecting "Custom Catalog Mode".
Fred, I tried that - but now it gives me message "The user does not have any access to database <myUserId>."
Which is confusing - because
1. why is it confusing the DB (server?) with my user Id?
2. I can use the same ODBC (even after the change you suggested) to connect to the database through 'Teradata SQL Assistant'.
Any help would be greatly appreciated.