Try Change DDM TCP/IP Attributes (CHGDDMTCPA) command.
Gokhan YILDIRIM
-----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
All,
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
(in
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
setup?
Thanks
Mike
=======================================
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
http://www.hbs-inc.com
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,
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.
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
bulunmamaktadir.Sirketimiz
mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan,
butunlugunun ve gizliliginin
korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi
herhangi bir zarardan
sorumlu tutulamaz.