[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Auto logon to SQL Server using SQRW and batch file
- Subject: Re: Auto logon to SQL Server using SQRW and batch file
- From: Kristy Engelkes <Kristy_Engelkes@RSMI.COM>
- Date: Mon, 23 Aug 1999 14:13:59 -0500
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>