Re: End-user software to query a warehouse?

> I'm curious whether you ever found a solution? I battled with the exact
> same thing for weeks on end 3 years ago. I found a solution that sort of
> worked, using ODBC, but now I'm battling a slightly different battle, with
> V5R2, IBMDA400 linked server, and translation...

i never did get it to work. It really sucks that "ordinary" ODBC client
applications can query the DB2 no problems, but when SQL Server
uses ODBC to try to talk to DB2, it doesn't work.

i'm *sure* the answer is something like, "SQL Server uses some of the
more esoteric functions in the ODBC API, and the IDB ClientAccess
drivers don't fully and properly implement all of the ODBC driver
spec. So, it's not really our SQL Server's fault, it the fault of IBM's
driver."

Which is a fair point, but perhaps SQL Server should be less agressive
with the API functions it uses to talk to IBM's drivers. Sucks for
Microsoft,
but i think MS would be more likely to ship a hackfix sooner than IBM
would fix their drivers.

> Thanks for your insigths into databases, I enjoy your posts :)

That's quite a different reaction to my posts. Most people find me a grumpy,
short-tempered, pessimistic, cranky, cermudgeon. i like to think that i a
refreshing spring breeze to the groups :)


.

Relevant Pages