×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

asp, MTS, and credit card transactions

asp, MTS, and credit card transactions

asp, MTS, and credit card transactions

(OP)
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?



RE: asp, MTS, and credit card transactions

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!

RE: asp, MTS, and credit card transactions

(OP)
Thanks.

I'll ask Versign about the component.

any other comments appreciated.

RE: asp, MTS, and credit card transactions

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

We use software from Retail Logic for the bank connectivity.

RE: asp, MTS, and credit card transactions

(OP)
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?

RE: asp, MTS, and credit card transactions

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

RE: asp, MTS, and credit card transactions

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close