I have in Microsoft SQL Server 2008 R2 SP1 a Connect-Server with ODBC to a MySQL database. ODBC-Driver: MySQL ODBC 5.2a on Microsoft Windows Server 2008 R2 64bit

All queries actually run properly. Also Inserts and Updates.

The problem is an update with BLOB-data. (images, ...)

Initially it worked, but when there is more data were not. Then I limited the update statement.

Now it doesn't even work with one image.

The table has 2540 datasets.
142 datasets have BLOB-Field = NULL

MySQL TABLE:

```
-ID int not null Primary Key
-ARTIKEL int 
-BILD blob

```

**MySQL ODBC**

![http://vvcap.net/db/uXBos_1v0Sm4qk-lA6SD.png](https://i.stack.imgur.com/83ub9.png)

**Parameter MSDAQL**
![enter image description here](https://i.stack.imgur.com/eua3n.png)

**Parameter Verbindungsserver (in MSSQL)**
![enter image description here](https://i.stack.imgur.com/Xc0vr.png)

This ist the SQL query:

```
update shop...EXTERN_BILDER 
set BILD = (select b.BILD from INTERN_BILDER b where b.ID = EXTERN_BILDER.ID)
where (BILD is null) AND (ID in (select ID from _temp_ID))

```

table \_temp\_ID has the IDs to update. I can adjust, how many.

This is the error from MSDASQL for connected server `shop` (translated from german, as best as I could):

> 
> The rows to be updated were not found. Some values were modified since last read.
> 
> 
> Message 7343, Level 16, Status 4, Row 2
> The OLE DB-Provider 'MSDASQL' for the connection server 'shop' couldn't execute UPDATE
> for the [shop]...[extern\_pictures] table. For the rowset complete parallelism was used and the value of a row has been modified, after the corresponding row was last read or synchronized.
> 
> 
>