Post reply

Linked Server to DB2 using IBMs OLEDB Provider (IBMDADB2)

  • June 15, 2004 at 9:47 am

    #82993

    Has anyone gotten that driver to work as a linked server?  It works fine as a Linked Server using the MS ODBC, and it works fine as a OLEDB provider in a DTS package (which annoyed me even more).

    What are the values that the 3 settings need to be (Product Name, Data Source, Provider String)?

    What security options should I use?

    I would be eternally grateful for any assiatance

  • June 15, 2004 at 1:15 pm

    #510535

    is this db2 on os390 or AS400 or UDB on win/unix/..

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • June 15, 2004 at 1:21 pm

    #510538

    Thanks for responding.

    It's UDB on UNIX...

  • June 16, 2004 at 12:13 am

    #510579

    I haven't used that combination yet.

    We only use linked servers to non-sqlserver for problem solving. Only then the definitions are added and removed asap.

    This is because we don't want to have all systems down because one is in maintenance or has an issue.

    And (maybe more important) we have had serveral issues with these drivers failing when applying db2-fixpacks or ptf-s.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • June 16, 2004 at 12:56 am

    #510584

    Product Name IBMDADB2, and can be anything really.

    Data Source normally this is the DB2 DBname

    Provider String can be something like

    "Provider=IBMDADB2;Database=dbname;hostname=dbserver; port=dbserverport;protocol=TCPIP;uid=dbusername; pwd=db2pass"

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply