i have set a linked server in sql 200 sp4 to as4000 with the provider for db2 (host integration 2006)
im able to see the tables and all basic query's worked fine (i imported all the as400 tables i want with the same name in both servers)
anyway i got a trigger (insert) as i want to insert in as400 tables the same data that i insert in sql table (i could call it replication) but it gives me this error when i type a insert in the sql table.
Server: Msg 7391, Level 16, State 1, Procedure INSERT_WMCS01F, Line 18
The operation could not be performed because the OLE DB provider 'DB2OLEDB' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'DB2OLEDB'' ITransactionJoin::JoinTransaction returned 0x8004d00a].
I would appreciate if you could help me...
PD: MSTDC is active and i configured after have read some things in msdn website, i disabled also the connection pooling as says in another msdn article, and made many other things i still have this problem and dont know whtat is missing to work fine...