April 19, 2007 at 3:51 am
Hi folks,
i got sql server 2000 sp4 and im trying with a linked server to insert the same data in a sql table and also in a as400 (db2) table
i think the linked server is fine because i can see the tables and also i can insert data in as400 tables but with a simple insert but i created a trigger to do the replication of data in sql and as400 and when i try to insert and invoke the trigger it gives me this error:
Server: Msg 7391, Level 16, State 1, Procedure INSERT_WMCS01F, Line 18
The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction.
[OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver]Enlist with DTC phase failed. 2]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a].
I would appreciate if you could help me...
PD: I already have tried many solutions presented in other foruns.. Someone who have already worked with this can say to me if the MSDASQL provider supports distributed transactions?
I also used the db2oleb to the linked server and i can see the tables i want in the enterprise manager so i guess the connection is fine but if i query the linked server with a select * from for example i get this error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'DB2OLEDB' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'DB2OLEDB' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].
Regards,
Joel
April 19, 2007 at 11:24 pm
1) Make sure MSDTC is up and running
2) Make sure that journaling option is set on the DB2 table (ask the administrators of the AS/400 to do it)
Good luck
Dmerm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply