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