Thank you to everyone for your input.
I can run an SQL manually that points to the DDM file as long as it is setup with RDB. It does not work using embedded SQL.
The users all sign on under a group profile, but I cannot do an ADDSVRAUTE because I do not know the password of the group profile.
With turnover here, nobody else would know the password either, I hesitate to change it.
I have to qualify the SQL with the name of the local DDM library. But when I do that, it fails with an authorization error.
The other DDM files open with no problem, just when I attempt the SQL it fails.
I guess I am Sorta Outa Luck.
DDM object XXXPY80P in CLNPYLIB uses remote object IC1PYLIB/XXXPY80P.
Database connection started over TCP/IP.
Database connection ended over TCP/IP.
Authorization failure on DRDA/DDM TCP/IP connection attempt.
Authorization failure on distributed database connection attempt.
Authorization failure on distributed database connection attempt.
Cursor C1 not open.
Cursor C1 not open.
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
