Re: Command-Line syntax for Connectivity

[Richard Tomancikl <Richard_Tomancik@TIGINSURANCE.COM>]

You have to place a question mark in the command line to get it to prompt.
The command line below is from an icon on my WinNT desktop.  The SQRW
dialog box appears and the cursor is at the password line

T:\PSOFT\HR701\sqrbinw\sqrw.exe t:\psoft\hr701\sqr\temp.sqr
?username/@hrdev  {flags....}

You can place the question mark in other places, like program name, and it
will prompt you even if the program name is filled in.

RT




Les Hancock <les_hanc@YAHOO.COM> on 01/07/99 03:13:39 PM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Richard Tomancik/Consultant/Dallas/TIG)
Subject:  Re: Command-Line syntax for Connectivity




I've never been able to get an SQR to run in this manner
without specifying the password.  I tried this:

O:\fs610\SQRBINW\SQRW.EXE c:\misc\sqr\descrb2.sqr
-oc:\temp\descrb2.log -fc:\temp\descrb2.lis
-mo:\fs610\sqr\allmaxes.max -Io:\fs610\sqr -S
sysadm@tech

(All on the command line)


It never asks me for a password -- I get:

(SQR 5528) ORACLE ORLON error -1017 in cursor 0:
   ORA-01017: invalid username/password; logon denied
(SQR 4701) Can't logon to the database.

SQRW: Program Aborting.


If I am doing something wrong, let me know.  I hope that Chuck is
correct.
I have dozens of icons for SQR's and have the password in the command
line
in each to save time when executing.  I know this is not good for
security purposes.


LH


---------------------------------------------------




---Chuck Chauvin <CChauvin@STONECARLIE.COM> wrote:
>
> However, if I'm not mistaken, everyone with access to the logs will
be able
> to read your password.  If you enter Username@DBInstance,
> you will be prompted for your password, and
> others will not be able to read it.
>
> HTH
>

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com