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
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