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.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact