Microsoft KB Archive/255097: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 59: | Line 59: | ||
<div class="errormessage"> | <div class="errormessage"> | ||
OLE DB error trace [Non-interface error: Column 'derived' (compile-time ordinal 1) of object ' | OLE DB error trace [Non-interface error: Column 'derived' (compile-time ordinal 1) of object '"pubs"."dbo"."vwTest"' was reported to have a PRECISION of 2 at compile time and 3 at run time]. | ||
</div> | </div> |
Latest revision as of 13:52, 21 July 2020
Article ID: 255097
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q255097
BUG #: 57407 (SQLBUG_70)
SYMPTOMS
When you attempt to execute a distributed query, against a view on a remote linked server, the query fails with the following message:
If you have trace flag 7300 enabled for extended OLE DB messages, you may also see something similar to the following (the object name may be different):
This problem occurs if:
- You are executing the query on one server against a view on a linked server. -and-
- The data type of the column is numeric or decimal.
WORKAROUND
To work around this problem, try either of the following:
- Change the data type of the column. -or-
- Create a view on the local server and then select from that view, instead of selecting from the view on the remote linked server.
STATUS
Microsoft has confirmed that this is a problem in SQL Server 7.0.
Additional query words: datatype
Keywords: kbbug kbpending KB255097