Informix as a linked server in SQL Server
Jacqui Doyle could not get Informix working as an SQL Server linked server after installing the Client SDK. Alexandre Marini advised enabling OLEDB on the Informix server. SangGyu Jeong asked for versions and described a working setup: setnet32 registration, the IBM Informix OLE DB provider with 'Allow inprocess', and openquery. Doug Lawry pointed to a guide. No outcome was reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Has anybody managed to get this operational? I'd really appreciate any advice, but I realise this is a long-shot. I suspect I've got a microsoft issue, but when I install the client SDK, the Microsoft Server cannot initialise the connection. I've been following this guide, but get errors on the final step https://www.ibm.com/support/pages/how-set-and-test-simple-ole-db-linked-server-microsoft%C2%AE-sql-server-allow-retrieval-data-ibm-informix-database-server ------------------------------ Jacqui Doyle ------------------------------ #Informix
Hello Jacqui. You should have OLEDB enabled in your IBM Informix server. Please follow this manual link: https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.oledb.doc/ids_oledb_008.htm ------------------------------ Alexandre Marini ------------------------------
Hi Jacqui, The picture file you attached (png) is not visible. Please upload the picture file again. And what's the version of Informix and sql server? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
I have created a linked server in the environment below. I hope this is for your reference. windows 10 pro x64 sql server 2017 x64 server management studio v18.4 informix client sdk 4.10.fc13 1. Register the server information with setnet32. (Tested with Informix Server version 12.1) 2. Create a linked server <General tab> Linked server : IDS1210 Provider : IBM Informix OLE DB Provider Product name : ifxoledbc Data source : stores_demo@ol_informix1210 <Security tab> Be made using this security context: (Remote login/with password) 3. Setting Provider Options Check the options 'Allow inprocess' 4. Run query with openquery ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Hi Jacqui. See also: https://www.oninitgroup.com/ms-sql-informix-linked-server ------------------------------ Doug Lawry ------------------------------