Re: new ODBC driver

On Thu, Jun 20, 2019 at 11:47 AM Andrew Lopez (SXS US)
<Andrew.Lopez@xxxxxxxxxxxxxxxxxx> wrote:

My problem is companies that keep trying to use Power BI (and other tools) with "IBM DB2" drivers, and not listening when I try to re-enforce that the standard driver is for DB2 on other platforms. While there are ways of tweaking the default DB2 drivers in Microsoft to work with the IBM i, they don't work that well.

In your shoes, I would keep fighting to explain that Db2 for i
requires its own driver. The driver comes from IBM, so it's not some
unknown, untrusted source. And it's no extra charge. Do your customers
use ACS or IBM i Access at all? The driver comes "bundled" with either
of those (but in principle is separately installable if need be).

If I can't find another solution, we'll have to setup Microsoft SQL Server with a Linked Server back to our system.

That seems so convoluted when a proper, direct connection is right at
their fingertips.

John Y.