Oninit
Talk to an expert →

Informix Error -935

-935 Cannot obtain IPX address for service name servicename.

You are trying to connect to a database server with the indicated service name via the IPX/SPX network protocol on a system with portable IBM Informix OnLine for NetWare. The client application, IBM Informix NET or Informix STAR, is not able to determine the IPX address that is associated with the specified service name. Possibly the service name is misspelled in your sqlhosts file; the sqlexecd daemon or the database server is not running; or the portable IBM Informix OnLine for NetWare software is not operating properly. Verify the service name in your sqlhosts file. Ask your DBA or system administrator to verify that the sqlexecd daemon, the database server, and the portable IBM Informix OnLine for NetWare software are operational.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-935 is specific to portable IBM Informix OnLine for NetWare connecting via the IPX/SPX network protocol — per the official guidance, the client software can't resolve the IPX address for the named service, for one of three possible reasons.

  1. The service name misspelled in sqlhosts, per the official guidance.
  2. The sqlexecd daemon or the database server not running, per the official guidance.
  3. The portable IBM Informix OnLine for NetWare software not operating properly, per the official guidance.
Solutions / Resolution
  1. Verify the service name in your sqlhosts file, per the official guidance, as the first check.
  2. Ask your DBA or system administrator to verify that the sqlexecd daemon, the database server, and the portable IBM Informix OnLine for NetWare software are operational, per the official guidance, if the service name itself checks out.
Examples
Checking the service name in sqlhosts
cat $INFORMIXDIR/etc/sqlhosts
-- confirm the service name for the target server matches exactly
Diagnostic Checks
  1. Check the service name spelling in sqlhosts first.
  2. Escalate to the DBA/system administrator to verify sqlexecd, the database server, and the NetWare software are all operational.
Related Errors / Related Topics
  • -931 — "Cannot locate servicename service/tcp service in /etc/services." A related service-resolution error, for TCP rather than IPX/SPX.
  • -933 — "Unknown network type specified in DBNETTYPE." A related network-configuration error, relevant to the same IBM Informix OnLine for NetWare platform.

Specific to IPX/SPX on portable IBM Informix OnLine for NetWare — check the service name in sqlhosts first, then escalate to confirm the daemon/server/NetWare software are operational.