server-Oracle

Posted - 09/29/2004 : 11:46:27
Hi folks,
I have a linked server pointing to oracle server 8i on my sql server 2000 box.
Initially i was able to run queries on sql server using the four part naming
convention. As of today i started to get this error:
Server: Msg 7356, Level 16, State 1Line 239
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'CALL_COUNT' (compile-time
ordinal 4) of object '"SUMMARY_OWNER"."IVRU_CALL_TRANSACTION_SUMMARY "' was
reported to have a DBTYPE of 130 at compile time and 5 at run time].
What would be causing this error?
Any suggesstions, thank you
Ramdas
Hi Ramdas,
It seems that you are facing the issue described in the following Microsoft
Knowledge Base Article No 251238.
Please visit the following link and see if it helps.
http://support.microsoft.com/?id=251238
Thanks
Soma Sekhara Reddy