?
Solved

OLE DB provider "SQLNCLI10" for linked server "" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Posted on 2012-04-11
5
Medium Priority
?
2,634 Views
Last Modified: 2012-04-22
Hi,

I am getting error given below while updating record from SQL SERVER 2008 R2 64 bit to SQL SERVER 2000 32 bit. I have installed instcat.sql and now sql server 2000's system stored procedures are compatible for 64 bit operations. All datatype in the update statement are same on both sides of the database tables.

OLE DB provider "SQLNCLI10" for linked server "" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Your help is appreciated.

Thanks.
0
Comment
Question by:ezkhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 37838599
Did you check this article? http://support.microsoft.com/kb/269495/en-us
0
 

Author Comment

by:ezkhan
ID: 37845161
Hi,

I have managed to resolve the issue by myself. Actually, while running the distributed transaction accross linked servers, table on the remote servers requires primary key or constraint. If it is not present then it returns the error as mentioned in question. Thanks for the comments.

Thanks.
0
 

Accepted Solution

by:
ezkhan earned 0 total points
ID: 37853306
I've requested that this question be closed as follows:

Accepted answer: 0 points for ezkhan's comment #37845161

for the following reason:

I have managed to resolve the issue by myself. Actually, while running the distributed transaction accross linked servers, table on the remote servers requires primary key or constraint. If it is not present then it returns the error as mentioned in question.
0
 

Author Comment

by:ezkhan
ID: 37853307
Why 0 points are being awarded to me. Is this because I managed to resolve it by myself or do you not consider it as  valid solution ??????????????
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question