SAP Knowledge Base Article - Public

1205813 - "Logon failed error" occurs when changing an Informix table location at runtime based on a native connection

Symptom

"Logon failed error" occurs when changing an Informix table location at runtime based on a native connection with Crystal Reports .NET SDK.

Resolution

Here are the steps:

1. First of all, edit the following registry key:
 
 "HKEY_LOCAL_MACHINE\SOFTWARE\Informix\SQLHOSTS"

2. Add the connection information of the Informix server where it is intended to change the table location (remote server) as follows:

 HOST=IPADDRESS or COMPUTERNAME
 SERVICE=TCP PORT (e.g. 1527)
 PROTOCOL=olsoctcp

3. Set the table location in code as follows:

 table.location="DatabaseName:hostname:tablename";

where:

 DatabaseName is the name of the database.
 
 Hostname is the name of the machine where the Informix server is installed.
 
 Tablename is the name of the table.

See Also

 Refer to the sample code named "CS_Win_RDObjMod_DBLogon" for more information about changing the table location at runtime. This can be found in the Developer Library.

Keywords

Changing an Informix table location at runtime based on a native connection with Crystal Report .NET SDK , 8656792 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2 ; SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008 ; SAP Crystal Reports, version for Visual Studio .NET 9.1