dbTalk Databases Forums  

Sql Server 2005 triggers

comp.databases.pick comp.databases.pick


Discuss Sql Server 2005 triggers in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
CJS
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.