Forum Discussion

robarivas's avatar
robarivas
Icon for Post Patron rankPost 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
Icon for Microsoft Employee rankMicrosoft 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
Icon for Post Patron rankPost Patron
9 years ago

That's great news arify. I really appreciate the responsiveness. I'm kind of in awe to be honest. I look forward to hear what you may find related to ODBC performance...though it sounds like I may not have to deal with that much longer if I get the October release :smileyhappy: