Linked Servers.....

[David Hunter]

Hi All,
I have successfully linked a server and had SQL queries running
OK for a few weeks, but today I get the following message....

"OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time."
(Server: Msg 7353, Level 16, State 1, Line 1)

I've dropped the link and recreated it but I still get the same error
message. Can anyone help???

Thanks
David.

[Ananth]

First of all, it seems like an extra column may have been added on the linked server side.

If that is the case, and you have a query/ stored procedure where you're doing a select * from linkedserver table, then you will need to edit/ recompile the procedure, if it's not equipped to handle the additional column. Nothing else occurs to me at the moment ...


------------
David Hunter at 5/10/01 7:45:07 AM


Hi All,
I have successfully linked a server and had SQL queries running
OK for a few weeks, but today I get the following message....

"OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time."
(Server: Msg 7353, Level 16, State 1, Line 1)

I've dropped the link and recreated it but I still get the same error
message. Can anyone help???

Thanks
David.

[David Hunter]

Thanks Ananth,
But I'm running the query from Query Analyzer (therefore it compiles
as I run it), and other queries against other tables in the linker
server work fine. Something to do with the system catalogs maybe?!?!
David.


------------
Ananth at 5/10/01 8:23:05 AM

First of all, it seems like an extra column may have been added on the linked server side.

If that is the case, and you have a query/ stored procedure where you're doing a select * from linkedserver table, then you will need to edit/ recompile the procedure, if it's not equipped to handle the additional column. Nothing else occurs to me at the moment ...


------------
David Hunter at 5/10/01 7:45:07 AM


Hi All,
I have successfully linked a server and had SQL queries running
OK for a few weeks, but today I get the following message....

"OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time."
(Server: Msg 7353, Level 16, State 1, Line 1)

I've dropped the link and recreated it but I still get the same error
message. Can anyone help???

Thanks
David.