Problem with linked Server

From: peter1502 <peter_at_brosi.com>
Date: 23 Oct 2006 06:34:36 -0700
Message-ID: <1161610476.198899.215690@f16g2000cwb.googlegroups.com>

Hallo

i hava a Problem with a linked server.
i have a oracle 9.2.0.6 Database which is connected to SQLServer 2000 SP4 as a linked server.
MDAC 2.8
if i want to make a query with OPENquery it works fine if i want to make a query with the 4 part names i got a fault

Server: Nachr.-Nr. 7356, Schweregrad 16, Status 1, Zeile 1 Der OLE DB-Provider 'MSDAORA' hat inkonsistente Metadaten für eine Spalte übergeben. Die Metadateninformationen wurden zur Ausführungszeit geändert.
OLE DB-Fehlertrace [Non-interface error: Column 'IK' (compile-time ordinal 1) of object '"INFOR"."RELFB"' was reported to have a DBTYPE of 130 at compile time and 5 at run time].

In the oracledatabase is the column IK a Number field with no limit in length and scale

what is the solution for the Problem.

The Database is created from our ERP-System. Is it possible to solute the Problem without changing datatype in the Oracletable ?

please help me

best wishes

Peter Brosi Received on Mon Oct 23 2006 - 08:34:36 CDT