KB31003: "Cannot locate xps service/tcp service in /etc/services" error message occurs when attempting to connect to an Informix XPS database using the MicroStrategy ODBC driver for Informix XPS on Windows

SYMPTOM
The Strategy ODBC driver for Informix XPS is shipped with Strategy products and is used to facilitate connectivity to an Informix Extended Parallel Server (XPS) database. This driver is manufactured by DataDirect Technologies. This driver is called 'Strategy ODBC driver for Informix XPS' in Strategy 9.4.x 10.x.
 
User attempts to connect to an Informix XPS database using the Strategy ODBC driver for Informix XPS on Windows and obtains the following error:
 

"Cannot locate xps service/tcp service in /etc/services.

Unknown error message 11004"

• Go to the file called ‘services’ which is located at C:\WINDOWS\system32\drivers\etc. Add the following entry (assuming the Service Name is ‘xps’):
  
  
  

  
  xps           <service port number>/tcp

  
  
  
  The following is an example entry where the service port number is 50100 (the comment part “#Informix XPS” is optional and user can write whatever describes the service best or leave it blank):
  
  
  

  
  xps           50100/tcp                   #Informix XPS

  
  
  OR
   
  
  
  
• Directly use the service port number in the ‘Service Name’ field of the DSN instead of the service name. For the above example, replace xps by 50100 in the ‘Service Name’ field of the DSN.
  

 
For details on configuring a DSN for the Strategy ODBC Driver for Informix XPS on UNIX/Linux platforms, refer to the information provided in the product manual, Installation and Configuration Guide
 
Third Party Software Installation WARNING
 
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.