March 4, 2005 at 8:05 am
hai,
i was trying to distributed query linked server
begin tran T1
insert into [172.16.2.155].mydb.dbo.tblcustname (name) values('suh')
commit tran T1
i am getting the following error....
Server: Msg 7391, Level 16, State 1, 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].
Any idea how to resolve this error
subban
March 4, 2005 at 8:21 am
Hi,
Probably silly question, but are you running MS DTC on both servers? Is the other database Sqlserver?
Pete
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
March 4, 2005 at 8:28 am
yes, infact both the databases are in the same instances (it is specific to application requirement)... and MSDTC is running
pls help
subban
March 4, 2005 at 9:56 am
If both the databases are in the same machine, loopback situation arises and it will not be supported..
am i right ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply