Home Dashboard Directory Help
Search

SQL Server 2005 OLE DB Provider Update Error (Linked Server) by live4you


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 545592
Opened: 3/30/2010 12:40:39 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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".
Details
Sign in to post a comment.
Posted by Microsoft on 12/13/2010 at 5:14 PM
Dear customer,

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.

Best regards,

Vassilis Papadimos
SQL Server development.
Posted by live4you on 4/7/2010 at 11:44 PM
1. Query
            UPDATE r_server.database.[dbo].[table_1]
                SET field=0
                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)
Posted by Microsoft on 4/7/2010 at 4:58 PM
Dear Customer,

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.

Regards,

Joachim Hammer

Program Manager
SQL Server
Sign in to post a workaround.