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

Oh, I just learned that this (Value cannot be null. error) was a known issue and it was already fixed :) It'll be out in (end of) October release.

 

I'll look into the traces about the performance, my guess is the driver reports us that its unable to compare dates, so we have to pull all the data.. I'll let you know once I take a look at them.

robarivas's avatar
robarivas
Post Patron
9 years ago

Hello arify. So I just downloaded the October 2016 update and tried to connect to the IBM DB2 database. This time the error I'm getting is: "Microsoft Db2 Client: The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805".

 

Any thoughts what might be going on now? I really want to use Power BI for my organization but I'm getting worn down by the connectivity problems. Please help.