"bijupg" wrote:

> Hi Guys,
>
> I AM USING DISTRIBUTED TRANSACTION WITH 2 sql server 2000
> on
> win2k and is working fine.
> but the same transaction not working in win2003.
>
> i am getting the following error.
>
> Server: Msg 7391, Level 16, State 1, Procedure P2, Line 5
> 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::JoinTransaction returned 0x8004d00a].
>
> NOTE: MSDTC IS RUNNING ON BOTH SERVERS AND ENABLED FOR
> NETWORK ACCESS.
>
> MY CODE IS LIKE THIS.
> CREATE PROCEDURE P2( @NO INT)
> AS
> BEGIN DISTRIBUTED TRAN
> INSERT INTO TESTB VALUES(1,'GH')
> EXEC server2.PUBS.DBO.P1 @NO
> COMMIT TRAN
>
> pls advice me
> ..
>