CANNOT Select data Oracle from SQL [Urgent]
Dear All,
we got some problem where we try to select / delete data Oracle Table from SQL.
Datatype column 'ID' in Oracle table is number.
OLE DB error trace [Non-interface error: Column 'ID' (compile-time ordinal 1) of object '"oracle_user"."oracle_table"' was reported to have a DBTYPE of 130 at compile time and 5 at run time].
Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
we use Linkedserver with provider MSDAORA and Oracle 9.1 version and SQL 2000
please help help ..
Thank you for your solution :)