Re: Re: Re: Re: Re: 908: Attempt to connect to dat

My suggestion then would be: 1) As the db server goes up then I assume the sqlhosts files on the server is fine. However, check the sqlhosts file on the client......to see if for any strange reason it has some special characters .....so you open it up with vi then you use set list command to see any special characters in the file. 2) I would check with a sniffer how the tcp connection goes out from the client ( I assume you have this problem only from one client). Is it trying to go to the servername:15038 ? 3) try to connect from any other clients to ensure that the problem is not on the db server (I think you did this before though). I hope this will help esteban.- On 17/12/14 15:25, GILLES TCHAPPI wrote: > Hi Esteban, > > I changed server sqlhosts : > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> echo > $INFORMIXSQLHOSTS > /produits/informix/115FC9/etc/sqlhosts.hdbafdba > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> cat > $INFORMIXSQLHOSTS | grep hdbafdba_tcp > #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 > hdbafdba_tcp onsoctcp hmba04 15038> > Stopped/Restarted the dataserver : > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> onstat - > > IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 00:06:40 --> 1040368 Kbytes > > But still have the same error on client side : > > informix@PBDDLX03: # time dbaccess sysmaster << EOF^Jselect count(*) from > sysdatabases;^JEOF > > 908: Attempt to connect to database server (hdbafdba_tcp) failed.> > ISAM error: record is locked.> > real 1m0.05s > user 0m0.01s > sys 0m0.01s > informix@PBDDLX03: # > > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >