Linked Server with Informix on AIX Server ✗ Answered: red (solid confidence) — Single unanswered detailed question about configuring a SQL Server linked server to Informix on AIX via the OLE DB provider, hitting a connectivity error after configuration.

Advisory only.

Hello, Have you ever managed to create a linked server with an Informix server on AIX? Here is my problem (at a client society): 1. I installed "IBM Informix Client-SDK 3.50FC9" on the SQL Server. 2. I configured the provider with "Setnet32.exe" 3. I verified that the connection is good with "ILogin Demo" 4. I installed Microsoft Data Access Components (MDAC) 2.8 Software Development Kit ( http://www.microsoft.com/download/en/details.aspx?id=21995 ) 5. I tried to connect to the Informix server with the Microsoft OLE DB RowsetViewer and I get this error : http://www-01.ibm.com/support/docview.wss?rs=681&context=SSVT2J&dc=DB550&uid=swg 1IC57452&loc=en_US&cs=UTF-8&lang=en&rss=ct681db2 This one has been identified by IBM and should be repaired since version CSDK 3.50.FC3. 6. After clicking Ok, I can ask my Informix database ! Strange 7. I configured my supplier "IfxoledbcSQL" in SQL Server USE [master] GO EXEC master.dbo.sp_MSset_oledb_prop N'Ifxoledbc 'N'AllowInProcess', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Ifxoledbc 'N'DynamicParameters', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Ifxoledbc 'N'IndexAsAccessPath', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Ifxoledbc 'N'NestedQueries', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Ifxoledbc 'N'SqlServerLIKE', 1 GO 8. I configured my linked server but can not be accessed, the error obtained here: http://pulsweb.fr/tmp/RowSetViewer_SQL.png -> I recorded the correct 64-bit versions with the command "regsvr32.exe% INFORMIXDIR% \\\\ bin \\\\ ifxoledbc.dll." -> The command "dbaccess sysmaster coledbp.sql" was carried out by the user Informix on the Informix server. -> The service "Distributed Transaction Coordinator" is running on the SQL Server. The characteristics of environments: Informix server: - IBM Informix Dynamic Server Version 11.50.FC6W1 AIX - Port = 1529 - = Db_locale en_US.8859-15 - = CLIENT_LOCALE en_US.8859-15 SQL Server: I managed a virtual machine to achieve a linked Informix server, however the two servers are on the same machine (Windows Server 2003). Would there be a conflict with an AIX server? What can you advise me to do? Thank you for your help