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.