Thank you Kristy!
I had given up until your message. Your method does work for me, and has already saved me a lot of typing!!
It did help!
Bob
-----Original Message-----
From: Kristy Engelkes [mailto:Kristy_Engelkes@RSMI.COM]
Sent: Monday, August 23, 1999 3:14 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Auto logon to SQL Server using SQRW and batch file
Not sure if you got this to work yet or not. I use database/userid/password
instead of userid/password@database and it works.
Hope this helps.
Kristy
SQR-USERS@list.iex.net on 08/18/99 04:11:35 PM
To: SQR-USERS@list.iex.net
cc: (bcc: Kristy Engelkes/Davenport/MP/RSMi)
Subject: Auto logon to SQL Server using SQRW and batch file
Hi all,
I'm trying to set up a batch file that I can call from within PFE to launch
SQRW.exe for a specific file.sqr. I'm querying against a SQL Server
database. I'm not able to get a connection. Would someone please confirm
my syntax (SQR 4.3.2.2)
command line inside test.bat:
s:\hr751\sqrbinw\sqrw.exe c:\galworkord.sqr userid/password@database
-is:\hr751\sqr\ -ms:\hr751\sqr\allmaxes.max -oc:\windows\desktop\sqr.log
-fc:\temp\ -ZIFs:\hr751\sqr\pssqr.ini
Thanks,
Bob
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2232.0">
<TITLE>Auto logon to SQL Server using SQRW and batch file</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Courier New">Hi all,</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">I'm trying to set up a batch file that I can
call from within PFE to launch SQRW.exe for a specific file.sqr. I'm
querying against a SQL Server database. I'm not able to get a
connection. Would someone please confirm my syntax (SQR
4.3.2.2)</FONT></P>
<BR>
<P><FONT SIZE=2 FACE="Courier New">command line inside test.bat:</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">s:\hr751\sqrbinw\sqrw.exe c:\galworkord.sqr
userid/password@database -is:\hr751\sqr\ -ms:\hr751\sqr\allmaxes.max
-oc:\windows\desktop\sqr.log -fc:\temp\ -ZIFs:\hr751\sqr\pssqr.ini</FONT></P>
<BR>
<P><FONT SIZE=2 FACE="Courier New">Thanks,</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Bob</FONT>
</P>
</BODY>
</HTML>