all groups > sql server connect > september 2003 >
You're in the

sql server connect

group:

Connections


Connections Antonio
9/29/2003 5:43:20 AM
sql server connect:
Hello people, I am experimenting some problems with two
linked server (the first one with SQL 7.0 SP 4 and the
other with SQL 2000 with SP 6), when I try to run some
querys I get the follow message:

"OLE DB provider 'SQLOLEDB' supplied inconsistent
metadata for a column". Somebody can help me to solve
this.

Re: Connections Antonio
9/29/2003 6:12:16 AM
No, the complete message is : "Server: Msg 7356, Level
16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata
for a column. Metadata information was changed at
execution time."

Some ideas?

[quoted text, click to view]
Re: Connections Antonio
9/29/2003 7:02:14 AM
Sue:
Is correct, that article mentions the problem, but it
suggest that chenge the type of the column (imposible)
and the other solution say that create a view, but it did
not works. Any other idea?

[quoted text, click to view]
Re: Connections Sue Hoegemeier
9/29/2003 7:35:30 AM
Then maybe this applies:
BUG: Error 7356 from a Distributed Query
http://support.microsoft.com/?kbid=255097

-Sue

On Mon, 29 Sep 2003 06:12:16 -0700, "Antonio"
[quoted text, click to view]
Re: Connections Sue Hoegemeier
9/29/2003 9:58:50 AM
Other than making sure the view is on the local server, no
ideas. The only other guesses I'd have would be if you are
accessing the linked server with a 4 part name, try changing
to OpenQuery (or if you are using OpenQuery, try to
reference the linked server with a 4 part name.).

-Sue

On Mon, 29 Sep 2003 07:02:14 -0700, "Antonio"
[quoted text, click to view]
Re: Connections Allan Mitchell
9/29/2003 1:53:57 PM
Are you experiencing this ?

http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fbin%2Fkbsearch.asp%3FArticle%3D306401

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]

AddThis Social Bookmark Button