Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Informix as a linked server in SQL Server

    Posted 01/14/20 08:53 AM

    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
    image2020-1-14_13-40-30.png



    ------------------------------
    Jacqui Doyle
    ------------------------------

    #Informix


  • 2.  RE: Informix as a linked server in SQL Server

    Posted 01/14/20 09:27 AM
    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
    ------------------------------



  • 3.  RE: Informix as a linked server in SQL Server

    Posted 01/14/20 10:04 PM
    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
    ------------------------------



  • 4.  RE: Informix as a linked server in SQL Server

    Posted 01/14/20 10:47 PM
    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
    ------------------------------



  • 5.  RE: Informix as a linked server in SQL Server

    Posted 01/15/20 02:39 AM
    Hi Jacqui.

    See also:

    https://www.oninitgroup.com/ms-sql-informix-linked-server

    ------------------------------
    Doug Lawry
    ------------------------------



Related Content