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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-01 : 07:56:10
|
| Richard Eames writes "I'm trying to update a database using linked servers. this is the SQL I'm running :update OPENROWSET('SQLOLEDB','UKAP0IDC012';'richardea';'plasma', 'SELECT * FROM LegacyInterface.dbo.center') set centeraddress1=cr.address1, centeraddress2=cr.address2 , centeraddress3=cr.address3, centerzipcode=cr.postal, centerfax=cr.main_fax, centerphone=cr.main_phone, directionshtml=cr.directions,replicationstatus='2'FROM centres crWHERE centerid=cr.centre_id AND cr.replication_status='2'and getting the following error :Could not fetch a row using a bookmark from OLE DB provider 'SQLOLEDB'. OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetLocate::GetRowsByBookmark returned 0x80040e21: ].Any hints/solutions greatfully received!!!" |
|
|
|
|
|
Could not fetch a row using a bookmark from OLE DB provider 'SQLOLEDB'.