[sqr-users] SQL Server - Connect to different Server

[Jay <theliska@yahoo.ca>]

Hi all,

Peopletools 8.45.10, App 8.8, SQR for Peoplesoft
V8.45.10, NT servers.

I have a requirement to run an SQR that
truncates/selects from our HRPRJ81 (HR) database and
insert to our FSDEV8 (Finance) database. The databases
exist on physically different servers. I've gone
through the archives and used that as the basis for my
sql, but I'm not having any luck. 

This code:

Begin-SQL -DB'DSN=HRPRJ81;UID=peoXXX;PWD=peoXXX'
TRUNCATE TABLE PS_TL_PROJECT
TRUNCATE TABLE PS_TL_PRODUCT_TBL
TRUNCATE TABLE PS_TL_USER_FIELD_1
TRUNCATE TABLE PS_TL_USER_FIELD_2
end-SQL

when running on our FSDEV8 gives this error:

SQR 1803) CONNECT failed.  Perhaps username/password
incorrect.
SQR for PeopleSoft: Program Aborting.

Some of the archives mention an ODBC version of SQR.
Do we have to use a different version of SQR? I am
using the same User ID and Password I specify in my
local ODBC setup for HRPRJ81. Is that correct? Do I
have to put the server name in front of the database
name like I do through Query Analyzer?

Any help appreciated.

thanks
jay


______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users