Forum Discussion

robarivas's avatar
robarivas
Post Patron
9 years ago

IBM DB2 vs ODBC

My IT department tried to set up a connection to IBM DB2 but could only get it to work through ODBC. This doesn't seem right. Also, the performance over ODBC is horrible. Trying to filter a multi-mil...
Need Help
arify's avatar
arify
Microsoft Employee
9 years ago

That looks interesting. Can you please send us traces for that error too?

 

Thanks

robarivas's avatar
robarivas
Post Patron
9 years ago

Ok, I just sent the additional trace files.

  • arify's avatar
    arify
    Microsoft Employee
    9 years ago

    Thanks, we found where that error is coming, and will fix that soon. About the performance, I didn't see the ODBC traces. Can you try that again, and make sure you pick Verbose level?

    • robarivas's avatar
      robarivas
      Post Patron
      9 years ago

      Fantastic, thank you. Hopefully "soon" means really, really, really soon :smileyhappy: 

       

      How will I know when it's fixed?

       

      I'm assuming this means once it's fixed I should be able to connect using the "IBM DB2 Database" option from the "Database" category of the "Get Data" dialog using the "Microsoft (requires .Net 4.5 or higher)" option under the "Advanced options" dropdown, correct?

       

      I don't have the ODBC set-up yet on the machine I am using at the moment but I do have it on my machine at my home so I will generate the trace data on that tonight and email that you. (of course my hope is to eventually not have to use the ODBC approach)

      • arify's avatar
        arify
        Microsoft Employee
        9 years ago

        We don't really have an ETA yet, it seems like an external issue. But, my guess, it probably won't take more than a few releases.

         

        You'll know if it's fixed if someone updates this thread, or just start trying every new release in 2017 :) If there are no other issues, you should be able to use that "Microsoft" option.