Sql Server 2005 triggers -
12-01-2006
, 08:28 AM
Hi Everyone,
I'm trying to get a trigger to fire off a Universe subroutine through
a linked UniOleDb Server. It works through query analyzer but not
through the trigger. Paul Chang at IBM said to contact Microsoft but I
think it's an IBM issue. Here's the error message:
No row was updated
The data in row 55 was not committed.
Error Source : .Net SqlClient Data Provider.
The requested operation could not be performed because OLE DB provider
"IBM.UniOleDB" for linked server "UVADVANTAGE" does not support the
required transaction interface.
Correct the errors and retry or press ESC to cancel the change(s).
Any ideas?
thanks,
Carl |