I installed a new server with SQL 2000. I am having a problem updating tables on this server from my other servers. I don't know whether it is something in the SQL settings or the database creation settings. I created a simple 2 column table on the new server. I can insert records into the table from the other servers. However, when I try a remote update with a very simple where clause, I get the following error message:
Could not open table '"hhdb"."dbo"."test"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
We have other remote servers that I do not have this problem with. Does anyone have any suggestions of where I should look for a solution?