Unanswered: Error 7399 in Openquery. GetNextRow in Informix
When I execute a Select using Openquery against Informix, sometimes I receive the error below:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Informix][Informix ODBC Driver]Error in row.]
[OLE/DB provider returned message: sqlerrm(table_name)]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ].
I noticed that the error is occuring when an user is Updating/Deleting or Inserting data in the table at the same time.
SQL Server 2000 with SP 3a
SDK Client 2.81 for Informix
ODBC 3.81 for Informix