-
More linked servers and ole db problems
Hi,
We have a problem with the linked server, ole db and statement UPDATE.
We have many remote servers with linked servers. There are Sql-Server 7.0 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|