RE: Help wanted with AS400 DDM file accessing a non-AS400 system

["Walden H. Leverich III" <WaldenL@xxxxxxxxxxxxxxx>]

Gohar,

Just a wild guess, but try changing the password on the DB2/NT machine to
all UPPER CASE. I know the iSeries translates passwords at times to
uppercase.

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: Gohar Mukhtar [mailto:gohar71@xxxxxxxxx] 
Sent: Wednesday, August 20, 2003 7:20 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Help wanted with AS400 DDM file accessing a non-AS400 system


Hi

>From an AS400, I'm trying to access a remote DB2 UDB
table that resides on a W2K server.

Through interactive SQL/400, I'm able to access this
remote table using CONNECT TO and SELECT commands. But
I want to access the same through an AS400 DDM file.
When I do this, it gives me "Authorization failure on
DDM TCP/IP connection attempt" error, with reason code
2 i.e. "Password not valid". I've verified through my
job log that it is sending the user id that I've
defined through ADDSVRAUTE command and it is the same
valid combination that lets me logon to the remote
server through IBM DB2 UDB Ver. 7 installed on my PC.

Could someone please help me find what am I missing
here? I've found this relevant entry in the archive
but without any workable resolution.
http://archive.midrange.com/midrange-l/200208/msg00850.html

Would greatly appreciate your help.
Gohar

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.