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 |
|
samsekar
Constraint Violating Yak Guru
437 Posts |
 Posted - 2002-02-06 : 07:09:21
|
HI,I have a Stored Procedure which updates a column of a Linked Server table. when i try to execute it givesServer: Msg 7306, Level 16, State 2, Procedure DtExpiryDisconnection, Line 14Could not open table '"SQL"."DBO"."SUBSCRIBER"' 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.]But iam able to insert a new row in the linked server table!!.I have also tried after installing MDAC 2.7  Thanks and Regards,Sekar |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-02-06 : 09:29:50
|
| I had this problem, it related to transactions across linked servers ... i think there is something on BOL about a SET <PROPERTY> for doing this... might want to give it a try... (SET REMOTE_PROC_TRANSACTIONS [ON|OFF]) ... see if that solves it...- Onamuji |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2002-02-07 : 00:12:14
|
| I have tried with SET REMOTE_PROC_TRANSACTIONS [ON|OFF]..It is not solving the problem.. :(Sekar |
|
|
|
|
|
|
Updation in Linked Server