Unix Technical Forum

Updating linked server avoiding DTC

This is a discussion on Updating linked server avoiding DTC within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Help!!! I have a problem updating field on an RDB linked server. The code I am running is: begin ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:15 PM
 
Posts: n/a
Default Updating linked server avoiding DTC

Help!!!

I have a problem updating field on an RDB linked server.

The code I am running is:
begin tran
update openquery(TAVNIOT, 'select TAVNIT, TAV_STAT from
TAVNIOT where TAVNIT = 1') set TAV_STAT = 8 where TAVNIT =
1
commit

The error I am getting is:
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB
provider 'MSDASQL' was unable to begin a distributed
transaction.
OLE DB error trace [OLE/DB Provider 'MSDASQL'
ITransactionJoin::JoinTransaction returned 0x8004d00a].

I understand the reason for that error but wondering, is
there a way around it, such as avoiding the DTC?
I tried setting the "Non transacted updates" on the linked
server provider, with no results.
The reason this is transacted is because the code must be
run from a trigger.

Help!!!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:13 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com