Thank you Evan, your advice got me past the authorization error.
I'm a bit unclear on the specifics here, but you could perhaps create a user profile on the remote system with the required authority then do an ADDSVRAUTE for each of your local users and point them all to that same user on the remote system.
ADDSVRAUTE USRPRF(LOCALUSER) SERVER('RMT_SVR')
USRID('NEW_RMTPRF') PASSWORD('xxxxx')
Now I am getting the error stating that the SQL package was not created when I run the RPG program. All I got was a printout stating that, no other information.
Harriscomputer
Tom Deskevich
Programmer/Analyst
P: 814-472-6066 x201134
F: 814-472-5019
E: TDeskevich@xxxxxxxxxxxxxxxxxx
[cid:HLG_logo_14bd0fcf-3182-4b52-9120-a2e250d74b09.jpg]
172 Gateway Road PO Box 568
Ebensburg, Pennsylvania
15931
www.harrislocalgov.com<
http://www.harrislocalgov.com>
This message has been sent on behalf of a company that is part of the Harris Operating Group of Constellation Software Inc.
If you prefer not to be contacted by Harris Operating Group please notify us<
http://subscribe.harriscomputer.com/>.
This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
midrange.com
