Xref: alice comp.databases.oracle.misc:54246
From: =?iso-8859-1?Q?Javi_Fern=E1ndez?= <javifm@arrakis.es>
Newsgroups: comp.databases.oracle.misc
Subject: Oracle, Sql server and ole db
Date: Sat, 4 Mar 2000 01:08:29 +0100
Lines: 33
MIME-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <38c05528_3@news.arrakis.es>
X-Trace: 4 Mar 2000 01:13:28 +0100, 212.59.207.107
Organization: Arrakis Servicios y Comunicaciones SLU
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!news.rediris.es!newsfeed.mad.ttd.net!caladan.arrakis.es!212.59.207.107

Hello,

We have a problem with the linked server, ole db and statement UPDATE from
Sql Server against Oracle.

We have many remote servers with linked servers. There are Sql-Server and
Oracle Server.
When we want to make update, we made in the next way:
    UPDATE OPENQUERY(LinkedServerName,"Select * from t_table where id=1")
    SET field='01'.

This statement is very fast against Sql-Server, faster than the four names
sintax :
Update LinkedServerName.DatabaseName.dbo.Table set field='01' where id=1.
(This sintax performs a
remote scan very slow).
The problem is when the remote server is a Oracle Server,
the statement :

UPDATE OPENQUERY(LinkedServerName,"Select * from t_table where id=1")
SET field='01' return the error:

    OLE DB provider 'MSDAORA' supplied inconsistent metadata.
    The object was missing expected column 'Bmk1000'.

What is the column Bmk1000???
Can help me anibody???

Regards