Distributed Transactions

[jcrivera]

Is there a way I could put the statement
BEGIN DISTRIBUTED TRAN
to work among two servers?

I already checked that the MSDTC service is running and from my local server I can see the remote server as a linked server.

Please advise.

J.C.
[sig][/sig]

 

[foxdev]

By definition, a distributed transaction involves two or more servers. The server that first issued the BEGIN DISTRIBUTED TRANSACTION statement, or that first executed a remote procedure call or query that caused the promotion of a local transaction to a MS DTC-managed transaction, becomes the "controlling" server for the purposes of the transaction. Commits and Rollbacks are participated in by all affected servers.

If this doesn't answer your question, could you be more specific on what you are trying to do? [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[jcrivera]

Hi Robert...
Sorry for not being more specific.

My question comes to the fact that whenever I want to use this mentioned statement to run a transaction involving a local and remote servers, I always get an error message indicating that my SQL-OLE DB provider doesn't support it.

Even more, when I try to run a trigger that has to access a remote server's database (without including the BEGIN DISTRIBUTED TRAN statement) I get the same error message when the trigger is fired.

Please advise. [sig][/sig]