Re: Remote SQL server connections

[Marc Rauzier <mrauzier@xxxxxxx>]

Le jeu. 23 sept. 2004 16:22:19, Mike Silvers écrivait:

> All,
> 

Hello

>  
> 
> 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
> 

This is not the right server. You have to start the DDM one : STRTCPSVR 
SERVER(*DDM)

> 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."  
> 

The security mechanism is configured using the CHGDDMTCPA command.

>  
> 
> Does anyone have any ideas?  Is there something I am missing in
> the setup? 
> 
>  
> 
> Thanks
> 
>  
> 
> Mike
> 



-- 
Cordialement/Best regards
Marc Rauzier

Opinions I stated here are my own.