DTS problem: Transfer failed, error: Unable to enlist in the transaction

Hi everyone,

I have a VB.Net Windows app. that transfers MS Access data over the internet to a SQL Server. It works fine. The thing is when I want to use transaction in order to have rollback in case of error, I get :
Transfer failed, error: Unable to enlist in the transaction

MSDTC service is running on both client and server machines.
I tweaked a little to no avail:
Control Panel>>Administrative Tools>>Component Services>>My Computer>>(right click) Properties: MSDTC tab.
There is a "Security configuration" button for "Transaction Coordination", I checked the unchecked: "Transaction Internet Protocol (TIP) Transactions" box but it didn't help.
When I unchecked "Use local coordinator" and entered the name/IP of the server it returned "remote machine does not exist" whereas I could access it through Enterprise manager...
It's frustrating, I can't find anything on the web!


Therse are the properties I changed in the module with rollback:

 goPackage.FailOnError = True
.....
 oStep.JoinTransactionIfPresent = True

oStep.FailPackageOnError = True

Thanks in advance

Its a basic flaw of Access I'm afraid (well the underlying Jet engine anyway), you can't enlist it in a distributed transaction like this. You'll just have to do without the transaction.

Wow... Is this true? Just think about all the pain I had to go through!
Thanks a lot anyway pgtips, and I trust you on this, but is there a knowledge base where this is discussed? Isn't there any workaround?

http://support.microsoft.com/?kbid=167743
rgds
Phil