Re: Configuring remote tcp connections.

Hi, no. Server names must be unique. You could choose e.g. "porto_tcp". You then also have to have this name in the list of DBSERVERALIASES in your $ONCONFIG file of that server. ( For ease of administration I would even keep server names unique across different machines if you have multiple IDS instances on different machines.) Additionally, you have to make this server known to the clients. They will also have their sqlhosts file. This does not need to be the same as the server's sqlhosts file. But the server name that you want your clients to connect to (i.e. "porto_tcp") should be in clients' sqlhosts file, complete with protocol, hostname and port specification. If you use a service name for the port, then that service name must be mapped to the correct port in /etc/services file (or whatever equivalent place on Windows). Basically with this you tell the clients how to reach the server. Client application gets IDS server name to connect to and then uses its own sqlhosts file to find out, which protocol to use, which host to connect to and which port to use (i.e. the port where the IDS listener thread is listening for connect requests). Depending on how many clients you want to be able to connect to the server you may have to consider a NETTYPE entry for this protocol in your $ONCONFIG file (for the server). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 03.11.2005 18:07:43: > Hi group, > > I need to configure my Informix system to accept remote tcp > connections. This Informix DB is running on an AIX server. > Here is the output of /informix/etc/sqlhosts file: > porto onipcshm portonova sqlexec > lisboa onipcshm portonova lis_sqlexec > euro onipcshm portonova euro_sqlexec> > As you can see my system only accepts shared memory. Now I want to > connect from windows clients and I need to configure TCP connections. > I was reading about it and someone told that I have to configure > sqlhosts file. > If I append the next line will it work? > porto olsoctcp portonova sqlexec> I search inside /etc/services and it already has sqlexec reference, by > the way, it's using port 1525. > Can I have "porto" dbservername parameter defined twice? > Any help would be greatly appreciated. > > Regards, > Nuno Paquete sending to informix-list

Hi, "Depending on how many clients you want to be able to connect to the server you may have to consider a NETTYPE entry for this protocol in your $ONCONFIG file (for the server). " Can you be more specific? Regards, Nuno Paquete