Forum Discussion

trentsb55's avatar
trentsb55
Regular Visitor
1 year ago
Solved

IBM Db2 Connector Issues

Is there a known issue with the IBM DB2 connector? I've been using this connector for a while now and recently got a new PC and having issues getting it to work. I thought it may be a driver issue bu...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi trentsb55  ,
    Thanks for reaching out to the Microsoft fabric community forum.

    The IBM Db2 database connector, when using the IBM Db2 driver for .NET, doesn't work with IBM i systems.
    In this scenario please try to connect using Microsoft driver and check if it is able to create a connection.
    You can find the option to select Microsoft driver in Advanced options.

     


    Reference article: Power Query IBM Db2 database connector - Power Query | Microsoft Learn

    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thank you

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi trentsb55  ,
Thanks for reaching out to the Microsoft fabric community forum.

The IBM Db2 database connector, when using the IBM Db2 driver for .NET, doesn't work with IBM i systems.
In this scenario please try to connect using Microsoft driver and check if it is able to create a connection.
You can find the option to select Microsoft driver in Advanced options.

 


Reference article: Power Query IBM Db2 database connector - Power Query | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you