Oracle, Sql server and ole db

From: Javi Fernández <javifm_at_arrakis.es>
Date: Sat, 4 Mar 2000 01:08:29 +0100
Message-ID: <38c05528_3@news.arrakis.es>

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 Received on Fri Mar 03 2000 - 18:08:29 CST