Hi, I want to add username and password to my shortcut for SQL Assistant (version 15.11) so I can get in and out of a lot of databases in a hurry. In the User guide I see the following:
-c <dsn>[ [ \<user> ] \<pwd> ] Automatically connect to the data source named <dsn>, with
optional <user> and <password> parameters.
I have tried the following but I still get prompted for Password
"C:\Mypath\My_exe" -c Teradata.net \MyUserID \MyPwd
"C:\Mypath\My_exe" -c MyTeradataServer \MyUserID \MyPwd
Does this only work with ODBC? So I would have to create an ODBC connection and do this?
"C:\Mypath\My exe" -c MyODBCName \MyUserID \MyPwd
Solved! Go to Solution.
start -> program files -> ODBC Administrator -> edit your DSN -> and add UserID / Password
or the DSN definition can be edited from
SQLA -> Choose ODBC drop down next to the connect icon -> Tools -> Define ODBC Data Source
or if you use Teradata.Net driver to connect
SQLA -> Choose Teradata.Net drop down next to the connect icon -> Hit Connect icon -> you should be able save the UserID and Password there.
Thanks! However I cannot save password in SQL Assistant for .net, I can only enter it. What I am looking for is the command line arguments to pass to the exe in the shortcut so when i start i automatically log in...
FYI. Starting in SQL Assistant 16.0 you can now save passwords for Teradata.Net also.