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 |
|
richard.eames
Starting Member
2 Posts |
 Posted - 2005-01-28 : 17:44:21
|
| Am trying to update an SQL table using linked servers. This is the SQL I'm using :update OPENROWSET('SQLOLEDB','UKAP0IDC012';'username';'password', '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'But whatever I try I keep 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 help/assistance GREATFULLY received!Cheers,Richard Eames |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-28 : 22:33:55
|
| Upgrade your MDAC to at least MDAC 2.7 SP1 Refresh. You can find the downloads here:http://www.microsoft.com/dataI haven't seen this particular problem for the last two MDAC upgrades. Is this SQL Server 2000 or 7.0?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
richard.eames
Starting Member
2 Posts |
Posted - 2005-01-29 : 03:18:31
|
| i think it's version 7? does this make a difference? Many thanks! |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-29 : 10:55:47
|
| It can. Check the version of your MDAC. Upgrade to MDAC 2.7 SP1 Refresh and see if it makes a difference. If you haven't upgraded the drivers from 7.0, you could still have this issue. I just haven't seen it since I've been using 2000.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
SQL linked servers problem