Db2

 View Only

db2 and odbc

  • 1.  db2 and odbc

    Posted Wed November 06, 2019 04:28 AM
    I need to setup an odbc connect to db2 luw 11.5 on linux
    I installed db2 data server driver package 11.5 on windows : ok
    defined an odbc dsn to the database - try connect : ok
    now I need to try getting data - excel 2016 pro is available

    in excel you have an option : new query - from other source - from odbc : dsn list is presented, but limited and db2 source is not available

    there is also an option : get from other sources - from MS query
    same problem over here : dsn / db2 is not displayed

    and a last option : new query - from database - from db2 db
    in this screen, you can define server/db/uid/pw but not the port
    tried hostname:port or hostname : connection refused

    all the doc is "very" clear .. but no solution found...
    does anyone know the correct procedure to connect through odbc from excel to db2 ?





    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    #Db2