Re: Connect string for sqrw.exe with ODBC

[Kathy Anderson <AndersoK@ROTARYINTL.ORG>]

connect string for SQL Server is
<databasename>/<dblogin>/<dbpasswd>

So if my database name = bluedb
                  dblogin = kathy
                  dbpasswd= 1234

the entire command line to run c:\abc.sqr would look something like this:

<path>\sqrw.exe c:\abc.sqr bluedb/kathy/1234 -ic:\user\sqr -oc:\temp\sqr.log
-fc:\temp  -zif..

> -----Original Message-----
> From: Doug Hovanec [SMTP:dahovanec@YAHOO.COM]
> Sent: 20 June 2000 2:06 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Connect string for sqrw.exe with ODBC
>
> Currently using peoplesoft & sybase and writing an SQR to connect to SQL
> Server.  Will need to select data from SQL Server and insert into Sybase.
> Has anyone done this before?  Having trouble connecting to the SQL Server
> database.  Not sure about the correct syntax to use.  I do have the odbc
> data source setup.
>
> Thanks in advance for any assistance
> doug