I have -908 error for connection. (IDS 9.21 is the server)

sqlhosts contents are

sunfire ontlitcp sunfire turbo

server env variable is set as below.

INFORMIXSERVER=sunfire

client is Win 2000/NT, params are configured using setnet32. host file and services are edited to add the servers machine IP/address and servcie(turbo) entry. Not able to makeout why db is not reachable from client.

client protocol (setnet32) used fore connection is onsoctcp.

Any specific set of steps for verification are greatly appreciated.

Thanks
Laks

Did you check your DBSERVERNAME and DBSERVERALIASes in your $ONCONFIG file?
is your sqlhosts file located in $INFORMIXDIR/etc ?

Are you able to connect with iLogin demo?
What about dbping on your client machine?

Is the correct servername stated in your error message?
Did you try INFORMIXCONTIME and INFORMIXCONRETRY?

Are you sure your server uses the tli interface? Check the release notes in $INFORMIXDIR/release

I am having the same problem, did you end up resolving this problem? If so, what was the problem and how did you correct it.

a few possibilities:

- Wrong connection statement (check servername in your connection string - this is not the actual machine name, but the name of the informix instance)
- Network is congested: play with INFORMIXCONTIME and INFORMIXCONRETRY
- Your connection parameters are wrong! Check sqlhosts file and onconfig and INFORMIXSERVER variable!