Re: Informix Connect

On Tue, 20 Apr 2004 21:33:28 +0100, Paul Watson <paul@oninit.com> wrote: >What does the release notes say the connection should be? I don't >have a Sco box. > >Have you started sqlexecd ? > >I would expect the Unix end to be > >pei setlitcp eptsco sqlexec > >with a line in /etc/services for sqlexec > >at the PC end I tend to start with DBPing if it doesn't just work. >If DBPing doesn't work then nothing else will > >Tom wrote: >> >> Great. Here goes... >> >[cutting] > >> When I run Setnet32... >> >> Environment TAB >> INFORMIXDIR=C:\\Program Files\\Informix\\Connect\\ >> INFORMIXSERVER=pei>> INFORMIXSQLHOSTS= >> >> Server Information TAB >> IBM Informix Server - <pei> >> Hostname - <server's IP address> >> Protocolname - <sesoctcp> >> Service Name - <1525> >> Options - <empty> >> >> Host Information TAB >> Current Host - <server's IP address> >> User Name - <informix> >> Password Option - <password> >> Password - <informix's password> >> >> About Setnet32 >> 9.53 2.81.TC2 > >Looks OK, I tend to run regcopy after changing setnet32 > >> >> When I run ILogin Demo... >> >> Login parameters >> Server pei >> Hostname server's IP address >> Servicename 1525 >> Protocolname sesoctcp >> Username informix >> Password informix's password >> Stores Database Stores7 <or one of my databases> >> >> I get an error message... >> >> Message from ILogin Demo >> Database: Sqlcode = -908 >> Refer to informix Find Error utility or > >Is sqlexecd listening on the port, you can use netstat -a on server >to check. When I check for sqlexecd running, I use: ps -eaf | grep sqlexec and I see two processes running. "pei" and "pei2". When I use the netstat -a command, I see: eptsco.sqlexec eptsco.sqlexe2 in the Local Address column, and the state for both is "LISTEN". in the Foreign Address column I see "*.*". > >[cutting]