SQL Transaction across two database server

#1

I m using sql server 2000.
i have Two database server in network having same configuration

I have written one trigger which will update Second database and then first
database.

But this does not happen and i get error. as follow:

The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
3

What could be this problem?
Please help required urgent.

Thanks
Labhesh Shrimali
Bangalore

#2

Hi..have you tried linking the servers? That should fix your issue.

"Labhesh Shrimali - Bangalore" wrote:

Quote:

I m using sql server 2000.
i have Two database server in network having same configuration

I have written one trigger which will update Second database and then first
database.

But this does not happen and i get error. as follow:

The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
3

What could be this problem?
Please help required urgent.

Thanks
Labhesh Shrimali
Bangalore

#3

Hi..have you tried linking the servers? That should fix your issue.

"Labhesh Shrimali - Bangalore" wrote:

Quote:

I m using sql server 2000.
i have Two database server in network having same configuration

I have written one trigger which will update Second database and then first
database.

But this does not happen and i get error. as follow:

The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
3

What could be this problem?
Please help required urgent.

Thanks
Labhesh Shrimali
Bangalore

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Transaction across two database server

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

SQL Transaction across two database server - 02-15-2006 , 07:49 AM

RE: SQL Transaction across two database server - 02-15-2006 , 01:39 PM

RE: SQL Transaction across two database server - 02-15-2006 , 01:39 PM