insert fails - accessing AS/400 from MS SQL Server linked server

[Daniel Adam]

Hi,
I configured a linked server in MS SQL Server v8 pointing to a remote
AS/400 DB2 database. I used Client Access ODBC driver (v7), installed
it from a Client Access Express v4.5.

Select/update/delete seems to be working fine, I just cannot execute
an insert statement. Here's the error I'm getting:

update as400..U1.TB1 set a = 4
select * from as400..U1.TB1
insert into as400..U1.TB1 ( a ) values (1)
------------------------------------------------------
Server: Msg 7399, Level 16, State 1, Line 4
OLE DB provider 'MSDASQL' reported an error. The provider did not give
any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow
returned 0x80004005: The provider did not give any information about
the error.].

I tried with and without a unique index on my table, same error.

Any help appreciated,
Daniel