Hi,
I am trying to use a linked server from SQL Server to DB2 FP16 using the IBM
OLE DB Provider for DB2. After I create the linked server, I get the
following error when I try to view the tables for the Linked Server:
7352: OLE DB Provider 'UNKNOWN' provided inconsistent metadata. The object
[master].[dbo].[SYSREMOTE_TABLES] was missing expected column 'DESCRIPTION'.
The issue is because IBMDADB2.DLL is returning REMARKS instead of
DESCRIPTION. This is correct according to IBM's CLI Standards. However,
Microsoft's sp_tables_ex procedure expects the column DESCRIPTION to be
returned.
Has anyone else hit this issue?
Kind Regards,
G.