Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

sp_tables_ex expects DESCRIPTION column instead of REMARKS.

0 views
Skip to first unread message

Ger

unread,
Jun 5, 2008, 7:44:02 AM6/5/08
to
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.

0 new messages