SQL Server Home
SQL Server 2005 OLE DB Provider Update Error (Linked Server)
as Not Reproducible
3/30/2010 12:40:39 AM
User(s) can reproduce this bug
When a linked server with this driver is used to update or delete data on the remote SQL Server 2005 sometimes i have, the following error occurs:
Cannot fetch a row using a bookmark from OLE DB provider "SQLNCLI" for linked server "r_server".
SQL Server 2005 - Standard Edition
Windows Server 2003 (all x64 editions)
Operating System Language
Steps to Reproduce
1) Add linked server
2) add/update or delete data on remote SQL Server 2005
Sometimes i have an error: Cannot fetch a row using a bookmark from OLE DB provider "SQLNCLI" for linked server "r_server".
How to protect from this error.
to post a comment.
Please enter a comment.
on 12/13/2010 at 5:14 PM
Unfortunately we were unable to reproduce the issue you reported. It is likely that the issue depends on the schema of r_server.database.[dbo].[table_1] and @tmp (and perhaps the data as well). If you can provide these to us, we'll be happy to investigate further.
SQL Server development.
on 4/7/2010 at 11:44 PM
FROM @tmp t inner join r_server.database.[dbo].[table_1] tb
on t.id = tb.id
2. Operating System: Windows Server 2003 (64 bit)
SQL Server 2005 Standard (64 bit)
on 4/7/2010 at 4:58 PM
Thanks for reporting on the provider problem with linked servers in SQL Server 2005. In order to help us better troubleshoot the problem, would it be possible for you to provide us with the following?
1. The query that’s causing the problem;
2. The version of SQL Server you are using; and if possible
3. Relevant parts of your database schema.
Thanks much in advance for your input and help with this investigation.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft