| Author |
Starting Transaction in Linked Server (When MSDTC installed).
|
|
| vignesh 2005-04-28, 7:23 am |
| We are using linked servers(Server1 & server2). MSDTC is installed.
When i try fire a query inside a transaction it gives an error.
Qry is :
BEGIN TRANSACTION
SELECT * FROM JDEDB.JDE_PRODUCTION.PRODDTA.F0911z1
COMMIT TRAN GO
Following Error Message :
"Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::Jo
inTransaction returned 0x8004d00a]. "
thanx in advance
| |
| Uri Dimant 2005-04-28, 7:23 am |
| Hi
Try
BEGIN DISTRIBUTED TRAN
........
COMMIT TRAN
"vignesh" <vignesh@discussions.microsoft.com> wrote in message
news:B682D4A6-0866-42E4-A8C3- 7C2036C59D0B@microso
ft.com...
> We are using linked servers(Server1 & server2). MSDTC is installed.
>
> When i try fire a query inside a transaction it gives an error.
>
> Qry is :
> BEGIN TRANSACTION
> SELECT * FROM JDEDB.JDE_PRODUCTION.PRODDTA.F0911z1
> COMMIT TRAN GO
>
>
>
> Following Error Message :
> "Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction.
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::Jo
inTransaction returned 0x8004d00a]. "
>
> thanx in advance
| |
| vignesh 2005-04-28, 7:23 am |
| Not working , Getting the same error.
"Uri Dimant" wrote:
> Hi
> Try
> BEGIN DISTRIBUTED TRAN
> ........
>
> COMMIT TRAN
> "vignesh" <vignesh@discussions.microsoft.com> wrote in message
> news:B682D4A6-0866-42E4-A8C3- 7C2036C59D0B@microso
ft.com...
> 'SQLOLEDB'
>
>
>
| |
| Uri Dimant 2005-04-28, 7:23 am |
| Well,does MSDTC service run ?
"vignesh" <vignesh@discussions.microsoft.com> wrote in message
news:F6EDFEA9-0E0D-4D3E-9888- 427D7DB29CB8@microso
ft.com...[color=darkred]
> Not working , Getting the same error.
>
> "Uri Dimant" wrote:
>
the[color=darkred]
| |
| vignesh 2005-04-28, 7:23 am |
| Yes it is running. modified the query as
BEGIN distributed TRANSACTION
SELECT * FROM JDEDB.JDE_PRODUCTION.PRODDTA.F0911z1
COMMIT TRAN GO
"Uri Dimant" wrote:
> Well,does MSDTC service run ?
>
>
> "vignesh" <vignesh@discussions.microsoft.com> wrote in message
> news:F6EDFEA9-0E0D-4D3E-9888- 427D7DB29CB8@microso
ft.com...
> the
>
>
>
|
|
|
|