Error During update or delete with ODBC connection to SQL Server

Sjors

New Member
Hello all,

In my SQL Server 7, I have got a linked server connection to a Progress 9.1 Database via a MERANT ODBC driver.
With this connection I can read and insert into all the tables without problems.
In most rows I don't have problems with updating or deleting either, but when I try to update or delete a row where one of the fields contains a NULL value, the following error occurs:

OLE/DB Provider 'MSDASQL' reported an error
[OLE/DB] provider returned message: Query-based update failed because the row to update could not be found.]

Is there anybody who is able to help me with this problem?

Allready thanks for your help.

Sjors Lubeek
 
Top