Re: Trouble connecting to DB using TCP

Michael L. Gallagher wrote: > > Hello all: > I've finally gotten my database working...albiet using a shared memory > connection. What I would like to do is have a TCP connection set up (in > case the server ever moves onto a machine of it's own). I've checked > all the configuration files (/etc/services /etc/system sqlhosts.ifmx > config.ifmx), but oninit still complains that it can't find my service > listing in /etc/services. My plaform is UNIX (Solaris 2.5.1) and we are > running an NIS+ environment. Anyone have any experience with this? I'm > getting a little tired of being asked the same questions over and over > again by Informix tech support. This stuff works. Email me or post your sqlhosts, ONCONFIG(TBCONFIG) file, and the relevent section of /etc/services. I'll try to help. BTW what version of Informix? Some hints to try first: 1) 5.x needs an sqlexecd process running with the service name passed to it on the command line. This is the network listener. 2) 7.x needs you to use a separate servername for each interface and to include the alias servernames in the ONCONFIG file in the DBSERVERALIASESline. Then the engine must be shutdown and restarted to recognize the new services and start up listeners for them. Art S. Kagel