Username and Password Parameters for SQL Assistant Shortcut

Teradata Applications
Enthusiast

Username and Password Parameters for SQL Assistant Shortcut

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


Accepted Solutions
Enthusiast

Re: Username and Password Parameters for SQL Assistant Shortcut

This command line worked for me:

 

SQLA -p ODBC -c "DSNName\Userid\Pwd"

1 ACCEPTED SOLUTION
5 REPLIES
Enthusiast

Re: Username and Password Parameters for SQL Assistant Shortcut

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

Then

SQLA -> Choose Teradata.Net drop down next to the connect icon -> Hit Connect icon -> you should be able save the UserID and Password there.

Enthusiast

Re: Username and Password Parameters for SQL Assistant Shortcut

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...

Enthusiast

Re: Username and Password Parameters for SQL Assistant Shortcut

This command line worked for me:

 

SQLA -p ODBC -c "DSNName\Userid\Pwd"

Enthusiast

Re: Username and Password Parameters for SQL Assistant Shortcut

Awesome, thank you very much.

Teradata Employee

Re: Username and Password Parameters for SQL Assistant Shortcut

FYI. Starting in SQL Assistant 16.0 you can now save passwords for Teradata.Net also.