Distributed Transaction Problem

[Scott.Macmaster]

I'm using a linked database (SQL Server 2000) and can do any kind of query I want but I can't get them to work within a transaction. The error message I get back is

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].

I'm guessing one or both of the SQL Server databases isn't configured correctly. Can someone tell me how to get this to work.


Thanks

[jp140768]

To use transactions between databases, as far as I know you have to have MS DTC running. This is done from the properties of the database you are using, there is one under the General tab, and one under the Connections tab.

HTH