asp, MTS, and credit card transactions

[Guest_imported]

I know virtually nothing about MTS.

I have an asp page which uses a third party credit-card processing component (Verisign's PaymentFlowPro). I have the page working OK and it approves or denies credit-card transactions appropriately which is followed by a some database actions on my server.

Suppose that the transaction is approved but an error then occurs in my asp page (or the connection is lost or whatever). I think I understand that if I make this page transactional, MTS will rollback any local database changes. However, if the bank transaction was successful on the remote server and funds were transferred, but then an error occurs in my asp page, how will MTS also rollback the remote changes? There would be no record in my database of an order but the user will get a credit-card bill...

Does this question make sense? Maybe I don't understand what MTS is doing. Can anyone explain this to me?

 

[zallen]

If the DBMS supports XA/OLE transaction protocol,then any error will cause the transaction roll back normally!

But i donnot know if the credit card component will compatible with MTS!


Regards!

 

[Guest_imported]

Thanks.

I'll ask Versign about the component.

any other comments appreciated.

 

[karlp]

We've written our own credit/debit card payment system using ASP & MTS.

We use software from Retail Logic for the bank connectivity.

 

[Guest_imported]

In your custom system, how does MTS rollback the remote transaction? For example if the remote back transaction involves moving funds and a local error of somekind occurs does the remote transaction somehow get undone? Can you describe a little bit how you used MTS for this task?

 

[TomSark]

The MSDTC (Distributed Transaction Coordinator) takes care of the two-phase commit work done here. It's all documented in MSDN, and if you don't have the CDs, visit msdn.microsoft.com and search on MSDTC, etc...

Tom

 

[karlp]

We cannot use MS-DTC to rollback the transaction as our links to the bank do not support it.

If the communcation fails then we simply set the status of a SQL Server record to Error.