This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Hi, Currently I am having a Teradata Connection Issue. Very very wield one and it seems to be product bug to me.
I changed my system password and I can still log into my Teradata Studio but not from Alteryx with my original connection name, let's say it's TDPRD. Error message:
Error: Connect In-DB (6): Error SQLDriverConnect: [Teradata][ODBC Teradata Driver][Teradata Database] The UserId, Password or Account is invalid. [Teradata][ODBC Teradata Driver] Not enough information to log on
I actually can see those table names and view names in query builder but it still shows error when I run the workflow.
So I build another connection with a different connection name, let's say it's TDPRD2 and it would work. I tried to delete my old connection TDPRD and rebuild it with same name TDPRD again and it would still shows up error.
No matter how I configure the ODBC driver , or delete it and rebuild a new one, it won't work but the new connection TDPRD2 would work just fine.
And no matter whether I type in my passoword in ODBC connection, it would shows error. But again, the new connection TDPRD2 would still be fine.
It looks like a cache issue to me. I really need my TDPRD connection as whe whole team is using this connection to run workflow.
Please Help Me Out! Thank you so much! Already stuck on this issue for two days...
@JasonH123The password seems to be cached somewhere, probably in the registry key. Go to HKLM\SOFTWARE\ODBC\ODBC.INI\<CONNECTION NAME> and check the password key. You can change it there manually as well.
I am having the exact same problem. I have tried Options-Advanced Options-Manage Data Connections with no luck. Was a definitive solution found? I have no idea where to find HKLM\SOFTWARE\ODBC\ODBC.INI\<CONNECTION NAME>
@DiganP is referring to a registry path within regedit.exe. One thing to note though - The path is dependent on the connection type (User vs. System). A User connection will reside in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI, whereas a System connection will reside in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI.
I see the Computer\HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\Teradata_Production but what do I do once I am there. I am having the same problem as this thread. I was able to connect to Teradata last week but on Friday and today, it says invalid username and password. I have updated my Teradata driver but still cant connect.