Troubleshooting
Problem
SQL Server Integration Services (SSIS) is used with Informix databases and Informix CSDK for things such as data extraction and data loading. After initial installation of oledb on a Windows environment, the oledb layer works with SSIS to pass data between SQLServer and the Informix database. During the initial setup, configuration issues may prevent connectivity.
Symptom
When the user tries an Informix connection using the OLEDB data source, an error similar to the following may be encountered:
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "database@servername" failed with error code 0xC0202009.
Cause
There is a 32 bit driver and a 64 bit driver with the same name for SSIS connection managers. If both providers are visible in the environment, the correct provider will be used. If the correct provider is not visible, you may get error code 0xC0202009 at connection time.
Diagnosing The Problem
In the properties of the SSIS project, locate the 'Run64BitRuntime' parameter.
Run64BitRunTime=False => will find and use the 32 bit provider.
Run64BitRunTime=True => will find and use the 64 bit provider.
Resolving The Problem
If you encounter the error code 0xC0202009 with SSIS and the Informix oledbc driver, you may be able to resolve the connection problem by setting the Run64BitRunTime to the opposite value (True=>False or False => True) before you try to connect.
Was this topic helpful?
Document Information
Modified date:
03 June 2021
UID
swg21611649