MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2004

RE: Remote SQL server connections



fixed


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.






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

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