Google Groups Home
Help | Sign in
sp_tables_ex expects DESCRIPTION column instead of REMARKS.
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  1 message - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Ger  
View profile
 More options Jun 5, 7:44 am
Newsgroups: microsoft.public.data.oledb
From: Ger <G...@discussions.microsoft.com>
Date: Thu, 5 Jun 2008 04:44:02 -0700
Local: Thurs, Jun 5 2008 7:44 am
Subject: sp_tables_ex expects DESCRIPTION column instead of REMARKS.
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.


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google