Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
franz
Starting Member
4 Posts |
 Posted - 2002-02-11 : 09:25:10
|
chaps, if anyone can help me with this problem I would be VERY grateful.I have a SP to access data from tables on a linked server. I can access data from all tables but two, when it gives the following error:Server: Msg 7353, Level 16, State 1, Line 1OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.This error is given whether trying to access data from the SP, or Query Analyser window if using the linked server.If I connect a Query Analyser window directly to the server with the tables on, all is fine, and I get the data.I'm stumped, any ideas?Franz. |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-11 : 09:38:23
|
| Sounds like the stored procedure needs to be recompiled. Here are some suggestions:1) Run the sp sp_recompile2) Include the WITH RECOMPILE in your sp to force a recompile. If the query plan is correct, you can remove it.3) If none of these steps work, you can try dropping and recreating the sp |
 |
|
|
franz
Starting Member
4 Posts |
Posted - 2002-02-11 : 11:38:00
|
| thanks for the speedy response andre.have tried using sp_recompile, and have tried dropping the sp / restarting server /recreating sp, but to no avail - still get the same error message.this sp worked fine on a previous version of the database I am accessing, but the new version has extra fields added to the table (but I am not doing anything with these), so I can't see that being the problem as the keys are the same as before. the access permissions on the table are the same also.Are there any other options I can try? I can't seem to find this error documented anywhere.:::Franz::: |
|
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-11 : 11:56:30
|
| The only other idea I have is to drop the linked server and recreate it. |
|
|
|
franz
Starting Member
4 Posts |
Posted - 2002-02-11 : 12:32:07
|
| ok thanks - I'll try that:::Franz::: |
|
|
|
franz
Starting Member
4 Posts |
Posted - 2002-02-13 : 08:19:02
|
| ok, have tried that, but no joy.however, the workaround I'm using now is this:create an SP (on the server with the tables I can't access remotely on), and call this to select the data from the tables.not ideal, but it works ok.thanks for your help.:::Franz::: |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-02-13 : 09:06:02
|
| Check out this KB article and see if it applies to your scenario[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q255097[/url]hth,Justin |
|
|
|
|
|
|
|
|
inconsistent metadata problem