1234067 - Error:"Error - 25596: The INFORMIXSERVER value is not listed in the sqlhosts file or registry” when using an Informix native connection in Crystal Reports

SAP Knowledge Base Article - Public

1234067 - Error:"Error - 25596: The INFORMIXSERVER value is not listed in the sqlhosts file or registry” when using an Informix native connection in Crystal Reports

Symptom

  • Login Error message In Crystal Reports
  • Error when using an Informix native connection
  • Error: "Error - 25596: The INFORMIXSERVER value is not listed in the sqlhosts file or registry'"

Reproducing the Issue

  • Using Informix server 10, create/rename a server so that the name is longer than 18 characters (for e.g. 'NineteenCharacter19');
  • In Crystal Reports, create a new report;
  • In Database Expert, create a native connection to Informix database using this server name;

Environment information:

  • Informix 10 (please note: previous versions of Informix have the limitation on the server name length);
  • Crystal Reports XI Release 2;

Cause

  • This issue has been identified as a possible bug.

Resolution

  • Reference number: ADAPT01106296
  • The target fix has been set to Service Pack 5

Keywords

Crystal XIR2 , KBA , BI , Business intelligence solutions , Bug Filed

Product

SAP Crystal Reports XI R2