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 meTry taking a look over this
http://blogs.msdn.com/florinlazar/a...1/02/47239.aspx
Message posted via http://www.droptable.com
Friday, February 17, 2012
distributed transaction giving error on win2003
Labels:
2000onwin2k,
database,
distributed,
error,
guys,
microsoft,
mysql,
oracle,
server,
sql,
transaction,
win2003,
working
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment