Re: How to connect to other IDS with Linux

From: root <root@Max.SIT.com.tw> > >My E-mail: kevinl@mail.cju.edu.tw > >The error code is: > >908: (ids0, conerr=-25555, oserr=0) 908 is a bit vague: -908 Attempt to connect to database server (servername) failed. The program or application is trying to access another database server but has failed. Note the server name in the current statement. The desired database server is unavailable, or the network is down or is congested. Ask your DBA and system administrator to verify that the server and network are operational. If the network is congested, use the environment variables INFORMIXCONTIME and INFORMIXCONRETRY to tune connection timing. For information on setting these environment variables, see the Informix Guide to SQL: Reference. This message appears in Version 6.0 and later versions. 25555 is a bit more useful: "-25555 Server server-name is not listed as a dbserver name in sqlhosts. The database server name that is mentioned in the current command is not listed in the sqlhosts file. Check the server name for accuracy. Check that all database servers to be accessed are included in the sqlhosts file. If you are using INFORMIX-SE, your current working directory might be an NFS-mounted directory. Change your current working directory to a local directory, or add appropriate local directories to your DBPATH." There could be a case sensitivity issue...the error lists server "ids0", the SQLHOSTS file lists "IDS0" >my /etc/hosts, /etc/service is ok, because I can connect to both IDS >servers Is that from a client PC or what? >in dbaccess C/connect item, but can't connect in SQL command such as > >SELECT * FROM mis@IDS1:data_table; Is that from IDS0? Are the hosts trusted by each other? In /etc/rhosts? >The follow is my onconfig and sqlhost wish it can help you debug. > >SERVERNUM 0 # Unique id corresponding to a Dynamic>Server instance >DBSERVERNAME IDS0 # Name of default database server >DBSERVERALIASES # List of alternate dbservernames> >IDS0 onsoctcp Max IDS0 >IDS1 onsoctcp Infx IDS1 HTH. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com