First you have to install the appropiate .NET based provider (driver) on application server and web frontend server. Please take care about 32/64-bit: The driver should be the same as your SharePoint currently runs.
For 64-Bit / Windows 2008 Server please goto IBM web site and use:
Informix Client Software Development Kit 3.70.xC1
For 32-Bit use this link to download:
http://www14.software.ibm.com/webapp/download/search.jsp?rs=ifxdl
Possible Issues:
Failed to find or load the registered .Net Framework Data Provider.
Please install the latest IBM drivers. The versions 3.5 FC6 before does not write entries into machine.config. Registering their drivers using regsvr32 and setting the path variable below solve the issue.
Next steps:
After successful installation it appears in the provider list of the BDLC settings dialog. Just select and enter connection string, similar to this one:
Fig.: Implementation sample SharePoint-Informix integration.
Just enter your query after the connection is validated.
Some customers get the following error while trying to connect:
Could not find or load IfxDotNetIntrinsicModule
More information from vendor:
New PATH required to run .NET applications on 64-bit Windows operating systems
If you run .NET programs on Microsoft Windows 64-bit systems, such as Windows Vista and Windows Server 2003/2008, set the PATH environment variable to include the path to IfxDotNetIntrinsicModule.dll:
• %INFORMIXDIR%/bin/netf11/ if you use the Microsoft .NET Framework Version 1.1
• %INFORMIXDIR%/bin/netf20/ if you use the Microsoft .NET Framework Version 2.0
The DLL is not required on 32-bit Windows operating systems. If you move your application from a 32-bit to a 64-bit Windows operating system, you must update the PATH environment variable or you will receive an error.
Thanks Ramesh Natarajan for evaluating this.