Can not update from view of linked server

Hi, All,
I got a problem with linked server, I cannot fix it, if anyone can help will
be appreciated.
The problem is two instance of sql server in one machine, A and B, in A made
a linked server to B. and a view in A. actually I can view the data from
view, but I can not update from view. I get error message:
7395, "42000", [microsoft][odbc sql server driver] unable to start a nested
transation for ole db provider 'sqloledb'. A nested transaction was required
because the xact_abort option was set to off.
7312, "01000" [microsoft][odbc sql server driver] [sql server] [ole/db
provider"] 'sqloledb' ITransationlocal::starttransaction returned
0x8004d013:isolevel=1048576
Thanks
Yifei
On the client where you are trying to update the view, try
executing: SET XACT_ABORT ON
before doing the update.
-Sue
On Mon, 31 Oct 2005 14:59:54 +1100, "Yifei"
<yjiang@.sdg.aust.com> wrote:

>Hi, All,
>I got a problem with linked server, I cannot fix it, if anyone can help will
>be appreciated.
>The problem is two instance of sql server in one machine, A and B, in A made
>a linked server to B. and a view in A. actually I can view the data from
>view, but I can not update from view. I get error message:
>7395, "42000", [microsoft][odbc sql server driver] unable to start a nested
>transation for ole db provider 'sqloledb'. A nested transaction was required
>because the xact_abort option was set to off.
>7312, "01000" [microsoft][odbc sql server driver] [sql server] [ole/db
>provider"] 'sqloledb' ITransationlocal::starttransaction returned
>0x8004d013:isolevel=1048576
>Thanks
>Yifei
>
|||It works, thanks Sue
Yifei
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:g5pem19r6401plkh1741bbt1at0bkvhi71@.4ax.com... [vbcol=seagreen]
> On the client where you are trying to update the view, try
> executing: SET XACT_ABORT ON
> before doing the update.
> -Sue
> On Mon, 31 Oct 2005 14:59:54 +1100, "Yifei"
> <yjiang@.sdg.aust.com> wrote:
will[vbcol=seagreen]
made[vbcol=seagreen]
nested[vbcol=seagreen]
required
>