Re: Command-Line syntax for Connectivity -Reply

[Marian Swenson <A20MES1@WPO.CSO.NIU.EDU>]

This command line works with an Informix database:

E:\FsDevl\sqrbinw\sqrw.exe e:\fsdevl\sqr\gls4002.sqr
mydatabase/sysadm/sysadmpassword  -Ie:\fsdevl\sqr\
-Me:\fsdevl\sqr\allmaxes.max -oc:\temp\sqr.log  -pb -cb -printer:lp

>>> Les Hancock <les_hanc@YAHOO.COM> 01/07/99 03:13pm >>>
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