Select OK and return to the property form.Ħ.
Informix does not support nested queries in the FROM clause and SQL Server will send a nested query to Informix when there are 2 or more joins to a table residing on the linked server This was a very difficult bug to find.ī. I have Dynamic Parameters and Allow In Process checked.ĭO NOT CHECK "Nested Queries". Should you need to change this options later you must create a new linked server, change these optionsĬlick OK and return to the Properties form, then cancel the new server. The options selected apply to all linked servers that use the Informix OLE DB provider. Note: This button will be grayed out except while creating a new linked server For this document, I am naming it IFXexample.ģ.Select IBM Informix OLE DB Provider from the drop down box. You should be on the general tab of the properties formġ.Name the Linked Server.
Select "Security" from the tree then right click "Linked Servers"Ī. Select the SQL Server instance you wish to link the Linker server to.ģ. Using sp_addlinkedserver and have not fully researched the proper connection string for Informix.Ģ. It is possible to use sp_addlinked server, but I had difficulties with the Informix connection string Should the SDK be updated in the future, this procedure must be followed as well The scripts are backward compatable, but must be run for any upgrades. The current path on the dev server is:Ĭ:\Program Files\IBM\Informix\Client-SDK\etc These scripts are included with the installation. IBM provides 2 scripts that need to be run against the Informix database:įrom the sysmaster database as user informix.
Prior to creating the connection, be certain that Informix Client SDK 2.90 or newer is installed on the server.īe certain to uninstall any earlier versions first, then reboot, install the newest SDK and reboot again. Procedure for creating an OlE DB linked server to Informix. I did experiment with ODBC but was not able to make ODBC work reliably I have just went through this if you are trying to create a linked server through sql Server 2000.