[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQR



You can run sqr from a batch file from Windows, but you have to pass in the
sysadm password, and all of the flags information.

ac

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Ben Le
Sent: Friday, December 07, 2001 2:20 PM
To: SQR-USERS@list.iex.net
Subject: Re: SQR


Hi SQRers,
Would some one out there tell me what is wrong with running SQR program at
the command line in Unix. Here is the problem:

Work: 'sqr program.sqr username/password' (work with username and password
are in the same line)

Does Not Work: 'sqr program.sqr' (system prompts for username and password).
Errors:
(SQR 5528) ORACLE ORLON error -12154 in cursor 0:
    ORA-12154: TNS:could not resolve service name
(SQR 4701) Cannot logon to the database.

SQR: Program Aborting.

Thanks.

Benjamin Le
ITS, System Development
Portland Community College
12000 SW 49th Ave. Portland, Oregon 97219
(503)-977-4970    Fax:(503)-977-4987
Mailto:ble@pcc.edu      http://www.pcc.edu