Try Change DDM TCP/IP Attributes (CHGDDMTCPA) command.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Silvers
Sent: Thursday, September 23, 2004 5:22 PM
To: Midrange-L list
Subject: Remote SQL server connections


I am attempting to connect one 400 to another and run SQL commands.  I
am running into a problem on the connect.  Here are the details:

On the source 400, I added an entry in the RDB table (ADDRDBDIRE)
indicating the name of the connection, the IP address, and the
connection type of *IP.

On the destination 400, I started the TCP server *EDRSQL

On the source 400, I try to connect to the remote 400 using the command
STRSQL) CONNECT TO (target 400) USER (username) USING (password)

I get the error indicating that "The security mechanism requested by the
client is not supported or allowed by server." 

Does anyone have any ideas?  Is there something I am missing in the



Mike Silvers
Senior Programmer/Analyst
iSeries Websphere Certified
Hainey Business Systems
Main Office:  (717) 718-9601 ext 237
Branch Office:  (410) 219-2695
Fax: (877) 804-9589
AIM:  IBMJavaMan

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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at

This message and attachments are confidential and intended solely for the 
individual(s) stated in this
message.If you received this message although you are not the addressee you are 
responsible to keep the
message confidential .The sender has no responsibility for the accuracy or 
correctness of the
information in the message and its attachments.Our company shall have no 
liability for any changes
or late receiving,loss of integrity and confidentiality,viruses and any damages 
caused in
anyway to your computer system.

Bu mesaj ve ekleri mesajda gonderildigi belirtilen kisi/kisilere ozeldir ve 
gizlidir.Bu mesajin muhatabi
olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin gizliligi 
ve bu gizlilik yukumlulugune
uyulmasi zorunlulugu tarafiniz icin de soz konusudur.Mesaj ve eklerinde yer 
alan bilgilerin dogrulugu ve
guncelligi konusunda gonderenin ya da sirketimizin herhangi bir sorumlulugu 
mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan, 
butunlugunun ve gizliliginin
korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi 
herhangi bir zarardan
sorumlu tutulamaz.

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page