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

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

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.

 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.

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 Business View Manager , How To

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