Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smurug
Starting Member
2 Posts |
 Posted - 2006-01-19 : 00:21:09
|
I have this following query to update a field in the linked server,UPDATE [172.25.26.112].[pubs].[dbo].SAMPLE1 set name1 = 'Murugan' WHERE age = 24 it produces the following error message,"Could not open table '"pubs"."dbo"."SAMPLE1"' 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.]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset returned 0x80040e21: [PROPID=DBPROP_BOOKMARKS VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID VALUE=True STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_IRowsetChange VA..."When i run the same query with the name1 field as varchar type it runs fine, but with text datatype it is producing this error, can someone help me out to solve this problem...  , is there any other solution to this problem other than changing the field's data type....Winners never quit,Quitters never win.Warm Regards,S.Murgan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How to update a text column in a linked server