by Ron Van Zante » Tue, 01 May 2001 23:59:01
Server: Msg 7353, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column
was supplied during execution that was not found at compile time.
I have dropped and resetup the linked servers. But the error is still there.
Anybody have any ideas?
by Tibor Karasz » Thu, 03 May 2001 04:25:11
--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.
Quote:> We have two linked servers Version 7.0 SP3. They work fine except for one
> table. When we do a select from this table we get the following error:
> Server: Msg 7353, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column
> was supplied during execution that was not found at compile time.
> I have dropped and resetup the linked servers. But the error is still
there.
> Anybody have any ideas?
by Ron Van Zante » Thu, 03 May 2001 06:53:15
> --
> Tibor Karaszi, SQL Server MVP
> FAQ from Neil at: http://www.sqlserverfaq.com
> Please reply to the newsgroup only, not by email.
> > We have two linked servers Version 7.0 SP3. They work fine except for
one
> > table. When we do a select from this table we get the following error:
> > Server: Msg 7353, Level 16, State 1, Line 1
> > OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra
column
> > was supplied during execution that was not found at compile time.
> > I have dropped and resetup the linked servers. But the error is still
> there.
> > Anybody have any ideas?
1. SQL Server 7 Linked Server Help
Hi All,
I am just getting in to SQL 7 and i need to now the following:
1. Is it possible to link to an Informix database on a Unix box through the
linked servers option?
2. Can i set the link up to only allow read only connections to the linked
database?
What i need to do is to live link a number of tables to an SQL database for
real time querying purposes rather than bcp'ing the data accross as we do at
present in 6.5
Can anyone give me detailed answers to these questions please.
Thanks in advance
Please respond via email:
3. SQL Server 7 Linked Servers Help Please
4. $$$$$$$ NEED QUICK CASH? $$$$$$$$
5. Linked Servers Help I am going crazy
6. SQL Question
8. CORRECTION TO VB CONNECT TO PDOX WIN VER 4.5
9. alter table in Excel linked server-help!!!
10. Linked Server - Help please
11. Linked servers -- HELP!!!!!!!!!